{"table_name":"jbusinessdirectory_orders","full_table_name":"wp_jbusinessdirectory_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_jbusinessdirectory_orders` ( `id` int NOT NULL AUTO_INCREMENT, `order_id` varchar(145) DEFAULT NULL, `invoice_number` varchar(145) DEFAULT NULL, `company_id` int NOT NULL, `package_id` int NOT NULL, `initial_amount` decimal(12,2) DEFAULT NULL, `amount` decimal(12,2) DEFAULT NULL, `amount_paid` decimal(12,2) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `paid_at` datetime DEFAULT NULL, `state` tinyint DEFAULT NULL, `transaction_id` varchar(145) DEFAULT NULL, `user_name` varchar(145) DEFAULT NULL, `service` varchar(145) DEFAULT NULL, `description` varchar(145) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `start_trial_date` date DEFAULT NULL, `end_trial_date` date DEFAULT NULL, `trial_initial_amount` decimal(12,2) DEFAULT NULL, `only_trial` tinyint(1) DEFAULT '0', `type` tinyint NOT NULL DEFAULT '0', `currency` varchar(10) DEFAULT NULL, `expiration_email_date` datetime DEFAULT NULL, `discount_code` varchar(50) DEFAULT NULL, `discount_amount` decimal(12,2) DEFAULT '0.00', `vat` decimal(12,2) DEFAULT NULL, `vat_amount` decimal(12,2) DEFAULT NULL, `observation` varchar(250) DEFAULT NULL, `trial_amount` decimal(6,2) DEFAULT NULL, `trial_days` tinyint DEFAULT NULL, `subscription_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, `notify_payment` tinyint NOT NULL DEFAULT '0', `expiration_processed` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `unq_invoice_numner` (`invoice_number`), KEY `idx_company` (`company_id`), KEY `idx_package` (`package_id`), KEY `idx_order` (`order_id`), KEY `idx_state` (`state`), KEY `idx_expiration_email_date` (`expiration_email_date`), KEY `idx_start_date` (`start_date`), KEY `idx_start_trial_date` (`start_trial_date`), KEY `idx_type` (`type`), KEY `idx_subscription` (`subscription_id`), KEY `idx_end_date` (`end_date`), KEY `idx_end_trial_date` (`end_trial_date`), KEY `idx_date` (`start_date`), KEY `idx_user_id` (`user_id`) ) ENGINE","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"order_id","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"invoice_number","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"package_id","type":"int","nullable":false,"primary_key":false},{"name":"initial_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"amount_paid","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false},{"name":"paid_at","type":"datetime","nullable":true,"primary_key":false},{"name":"state","type":"tinyint","nullable":true,"primary_key":false},{"name":"transaction_id","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"user_name","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"service","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"start_trial_date","type":"date","nullable":true,"primary_key":false},{"name":"end_trial_date","type":"date","nullable":true,"primary_key":false},{"name":"trial_initial_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"only_trial","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"type","type":"tinyint","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"expiration_email_date","type":"datetime","nullable":true,"primary_key":false},{"name":"discount_code","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"discount_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"vat","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"vat_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"observation","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"trial_amount","type":"decimal(6,2)","nullable":true,"primary_key":false},{"name":"trial_days","type":"tinyint","nullable":true,"primary_key":false},{"name":"subscription_id","type":"int","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"notify_payment","type":"tinyint","nullable":false,"primary_key":false},{"name":"expiration_processed","type":"tinyint(1)","nullable":false,"primary_key":false}],"plugin":{"slug":"wp-businessdirectory","name":"WP-BusinessDirectory – Business directory plugin for WordPress","active_installs":50,"version":"4.0.2","wp_org_url":"https://wordpress.org/plugins/wp-businessdirectory/"}}