{"table_name":"jbusinessdirectory_company_offers","full_table_name":"wp_jbusinessdirectory_company_offers","description":"Stores jbusinessdirectory company offers data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_offers` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int NOT NULL, `currencyId` int NOT NULL, `subject` varchar(110) DEFAULT NULL, `description` text, `meta_title` varchar(100) DEFAULT NULL, `meta_description` text, `meta_keywords` text, `price` decimal(12,2) DEFAULT NULL, `specialPrice` decimal(12,2) DEFAULT NULL, `price_base` decimal(12,2) DEFAULT NULL, `price_base_unit` varchar(45) DEFAULT NULL, `special_price_base` decimal(12,2) DEFAULT NULL, `special_price_base_unit` varchar(45) DEFAULT NULL, `total_coupons` int NOT NULL DEFAULT '0', `startDate` date DEFAULT NULL, `endDate` date DEFAULT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `approved` tinyint(1) NOT NULL DEFAULT '0', `offerOfTheDay` tinyint(1) NOT NULL DEFAULT '0', `viewCount` int DEFAULT '0', `alias` varchar(100) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `street_number` varchar(100) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `short_description` varchar(255) DEFAULT NULL, `county` varchar(45) DEFAULT NULL, `province` varchar(60) DEFAULT NULL, `area` varchar(60) DEFAULT NULL, `publish_start_date` date DEFAULT NULL, `publish_end_date` date DEFAULT NULL, `view_type` tinyint NOT NULL DEFAULT '1', `url` varchar(145) DEFAULT NULL, `article_id` int DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, `featured` tinyint(1) NOT NULL DEFAULT '0', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `show_time` tinyint(1) DEFAULT '0', `publish_start_time` time DEFAULT NULL, `publish_end_time` time DEFAULT NULL, `expiration_email_date` datetime DEFAULT NULL, `main_subcategory` int DEFAULT NULL, `enable_offer_selling` tinyint(1) DEFAULT '1', `min_purchase` int DEFAULT NULL, `max_purchase` int DEFAULT NULL, `quantity` int DEFAULT NULL, `user_id` int DEFAULT NULL, `postalCode` varchar(55) DEFAULT NULL, `type` tinyint(1) NOT NULL DEFAULT '1', `countryId` int DEFAULT NULL, `price_text` varchar(100) DEFAULT NULL, `offer_type` int DEFAULT NULL, `time_zone` varchar(15) DEFAULT NULL, `item_type` tinyint(1) NOT NULL DEFAULT '1', `notify_offer_quantity` int DEFAULT NULL, `use_stock_price` tinyint(1) DEFAULT NULL, `contact_email` varchar(100) DEFAULT NULL, `add_to_price_list` tinyint(1) DEFAULT '0', `review_score` decimal(2,1) DEFAULT '0.0', `packages` varchar(75) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_alias` (`alias`), KEY `idx_company` (`companyId`), KEY `idx_country` (`countryId`), KEY `idx_approved` (`approved`), KEY `idx_type` (`type`), KEY `idx_featured` (`featured`), KEY `idx_latitude` (`latitude`), KEY `idx_longitude` (`longitude`), KEY `idx_price` (`price`), KEY `idx_specialPrice` (`specialPrice`), KEY `idx_subject` (`subject`), KEY `idx_city` (`city`), KEY `idx_county` (`county`), KEY `idx_area` (`area`), KEY `idx_province` (`province`), KEY `idx_short_description` (`short_description`(100)), KEY `idx_address` (`address`), KEY `idx_user_id` (`user_id`), KEY `idx_expiration_email_date` (`expiration_email_date`), KEY `idx_search` (`state`,`endDate`,`startDate`,`publish_end_date`,`publish_start_date`), KEY `idx_publish_time` (`publish_start_time`,`publish_end_time`), KEY `idx_offer_type` (`offer_type`), KEY `idx_packages` (`packages`) ) ENGINE","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"companyId","type":"int","nullable":false,"primary_key":false},{"name":"currencyId","type":"int","nullable":false,"primary_key":false},{"name":"subject","type":"varchar(110)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"meta_title","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"meta_description","type":"text","nullable":true,"primary_key":false},{"name":"meta_keywords","type":"text","nullable":true,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"specialPrice","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"price_base","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"price_base_unit","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"special_price_base","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"special_price_base_unit","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"total_coupons","type":"int","nullable":false,"primary_key":false},{"name":"startDate","type":"date","nullable":true,"primary_key":false},{"name":"endDate","type":"date","nullable":true,"primary_key":false},{"name":"state","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"approved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"offerOfTheDay","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"viewCount","type":"int","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"street_number","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"short_description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"county","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"province","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"area","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"publish_start_date","type":"date","nullable":true,"primary_key":false},{"name":"publish_end_date","type":"date","nullable":true,"primary_key":false},{"name":"view_type","type":"tinyint","nullable":false,"primary_key":false},{"name":"url","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"article_id","type":"int","nullable":true,"primary_key":false},{"name":"latitude","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"longitude","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"featured","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false},{"name":"show_time","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"publish_start_time","type":"time","nullable":true,"primary_key":false},{"name":"publish_end_time","type":"time","nullable":true,"primary_key":false},{"name":"expiration_email_date","type":"datetime","nullable":true,"primary_key":false},{"name":"main_subcategory","type":"int","nullable":true,"primary_key":false},{"name":"enable_offer_selling","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"min_purchase","type":"int","nullable":true,"primary_key":false},{"name":"max_purchase","type":"int","nullable":true,"primary_key":false},{"name":"quantity","type":"int","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"postalCode","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"countryId","type":"int","nullable":true,"primary_key":false},{"name":"price_text","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"offer_type","type":"int","nullable":true,"primary_key":false},{"name":"time_zone","type":"varchar(15)","nullable":true,"primary_key":false},{"name":"item_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"notify_offer_quantity","type":"int","nullable":true,"primary_key":false},{"name":"use_stock_price","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"contact_email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"add_to_price_list","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"review_score","type":"decimal(2,1)","nullable":true,"primary_key":false},{"name":"packages","type":"varchar(75)","nullable":true,"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/"}}