{"table_name":"jbusinessdirectory_order_packages","full_table_name":"wp_jbusinessdirectory_order_packages","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_jbusinessdirectory_order_packages` ( `id` int NOT NULL AUTO_INCREMENT, `order_id` int NOT NULL, `name` varchar(145) DEFAULT NULL, `description` varchar(200) DEFAULT NULL, `expiration_type` tinyint(1) DEFAULT NULL, `price` decimal(12,2) DEFAULT NULL, `trial_price` decimal(12,2) DEFAULT NULL, `trial_days` smallint NOT NULL DEFAULT '0', `trial_period_unit` varchar(10) NOT NULL DEFAULT 'D', `trial_period_amount` smallint DEFAULT NULL, `recurrence_count` tinyint DEFAULT NULL, `special_price` decimal(12,2) DEFAULT NULL, `special_from_date` date DEFAULT NULL, `special_to_date` date DEFAULT NULL, `days` smallint NOT NULL DEFAULT '1', `ordering` tinyint NOT NULL DEFAULT '0', `time_unit` varchar(10) NOT NULL DEFAULT 'D', `time_amount` mediumint NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_price` (`price`), KEY `idx_order` (`order_id`) ) ENGINE","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"order_id","type":"int","nullable":false,"primary_key":false},{"name":"name","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"expiration_type","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"trial_price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"trial_days","type":"smallint","nullable":false,"primary_key":false},{"name":"trial_period_unit","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"trial_period_amount","type":"smallint","nullable":true,"primary_key":false},{"name":"recurrence_count","type":"tinyint","nullable":true,"primary_key":false},{"name":"special_price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"special_from_date","type":"date","nullable":true,"primary_key":false},{"name":"special_to_date","type":"date","nullable":true,"primary_key":false},{"name":"days","type":"smallint","nullable":false,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"time_unit","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"time_amount","type":"mediumint","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/"}}