{"table_name":"jbusinessdirectory_companies","full_table_name":"wp_jbusinessdirectory_companies","description":"Stores jbusinessdirectory companies data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_jbusinessdirectory_companies` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `alias` varchar(100) DEFAULT NULL, `comercialName` varchar(120) DEFAULT NULL, `short_description` varchar(500) DEFAULT NULL, `description` text, `meta_title` varchar(100) DEFAULT NULL, `meta_description` text, `street_number` varchar(100) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `city` varchar(60) DEFAULT NULL, `county` varchar(60) DEFAULT NULL, `province` varchar(60) DEFAULT NULL, `area` varchar(60) DEFAULT NULL, `countryId` int DEFAULT NULL, `website` varchar(250) DEFAULT NULL, `keywords` varchar(250) DEFAULT NULL, `registrationCode` varchar(20) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `fax` varchar(20) DEFAULT NULL, `state` tinyint DEFAULT '1', `typeId` varchar(255) DEFAULT NULL, `logoLocation` varchar(245) DEFAULT NULL, `creationDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `modified` datetime DEFAULT NULL, `mainSubcategory` int DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, `activity_radius` decimal(10,0) NOT NULL DEFAULT '0', `userId` int NOT NULL DEFAULT '0', `created_by` int NOT NULL DEFAULT '0', `averageRating` decimal(2,1) NOT NULL DEFAULT '0.0', `review_score` decimal(2,1) NOT NULL DEFAULT '0.0', `approved` tinyint(1) NOT NULL DEFAULT '0', `viewCount` int NOT NULL DEFAULT '0', `websiteCount` int NOT NULL DEFAULT '0', `contactCount` int NOT NULL DEFAULT '0', `taxCode` varchar(45) DEFAULT NULL, `package_id` int NOT NULL DEFAULT '0', `facebook` varchar(150) DEFAULT NULL, `twitter` varchar(150) DEFAULT NULL, `googlep` varchar(150) DEFAULT NULL, `skype` varchar(150) DEFAULT NULL, `linkedin` varchar(150) DEFAULT NULL, `youtube` varchar(150) DEFAULT NULL, `instagram` varchar(150) DEFAULT NULL, `pinterest` varchar(150) DEFAULT NULL, `whatsapp` varchar(150) DEFAULT NULL, `postalCode` varchar(55) DEFAULT NULL, `mobile` varchar(55) DEFAULT NULL, `slogan` varchar(500) DEFAULT NULL, `publish_only_city` tinyint(1) DEFAULT '0', `featured` tinyint(1) NOT NULL DEFAULT '0', `business_hours` varchar(255) DEFAULT NULL, `notes_hours` varchar(255) DEFAULT NULL, `custom_tab_name` varchar(100) DEFAULT NULL, `custom_tab_content` text, `job_tab_name` varchar(100) DEFAULT NULL, `job_tab_content` text, `business_cover_image` varchar(245) DEFAULT NULL, `publish_start_date` date DEFAULT NULL, `publish_end_date` date DEFAULT NULL, `notified_date` timestamp NULL DEFAULT NULL, `time_zone` varchar(15) DEFAULT NULL, `establishment_year` varchar(10) DEFAULT NULL, `employees` varchar(100) DEFAULT NULL, `ad_image` varchar(250) DEFAULT NULL, `disapproval_text` text, `yelp_id` varchar(255) DEFAULT NULL, `enable_request_quote` tinyint(1) DEFAULT '1', `trail_weeks_hours` text, `trail_weeks_status` tinyint(1) DEFAULT '1', `trail_weeks_address` varchar(100) DEFAULT NULL, `ad_caption` varchar(245) DEFAULT NULL, `recommended` tinyint(1) DEFAULT '0', `ordering` tinyint NOT NULL DEFAULT '0', `company_view` tinyint(1) DEFAULT '0', `opening_status` tinyint NOT NULL DEFAULT '0', `min_project_size` varchar(100) DEFAULT NULL, `hourly_rate` varchar(10) DEFAULT NULL, `tiktok` varchar(150) DEFAULT NULL, `areas_served` varchar(455) DEFAULT NULL, `available_dates` varchar(445) DEFAULT NULL, `review_status` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_type` (`typeId`), KEY `idx_user` (`userId`), KEY `idx_state` (`state`), KEY `idx_approved` (`approved`), KEY `idx_country` (`countryId`), KEY `idx_package` (`package_id`), KEY `idx_name` (`name`), KEY `idx_keywords` (`keywords`), KEY `idx_description` (`description`(100)), KEY `idx_city` (`city`), KEY `idx_county` (`county`), KEY `idx_maincat` (`mainSubcategory`), KEY `idx_zipcode` (`latitude`,`longitude`), KEY `idx_phone` (`phone`), KEY `idx_creationDate` (`creationDate`), KEY `idx_review_score` (`review_score`), KEY `idx_province` (`province`), KEY `idx_area` (`area`), KEY `idx_publish_start_date` (`publish_start_date`), KEY `idx_publish_end_date` (`publish_end_date`), KEY `idx_alias` (`alias`) ) ENGINE","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"comercialName","type":"varchar(120)","nullable":true,"primary_key":false},{"name":"short_description","type":"varchar(500)","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":"street_number","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"county","type":"varchar(60)","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":"countryId","type":"int","nullable":true,"primary_key":false},{"name":"website","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"keywords","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"registrationCode","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"fax","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"state","type":"tinyint","nullable":true,"primary_key":false},{"name":"typeId","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"logoLocation","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"creationDate","type":"timestamp","nullable":true,"primary_key":false},{"name":"modified","type":"datetime","nullable":true,"primary_key":false},{"name":"mainSubcategory","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":"activity_radius","type":"decimal(10,0)","nullable":false,"primary_key":false},{"name":"userId","type":"int","nullable":false,"primary_key":false},{"name":"created_by","type":"int","nullable":false,"primary_key":false},{"name":"averageRating","type":"decimal(2,1)","nullable":false,"primary_key":false},{"name":"review_score","type":"decimal(2,1)","nullable":false,"primary_key":false},{"name":"approved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"viewCount","type":"int","nullable":false,"primary_key":false},{"name":"websiteCount","type":"int","nullable":false,"primary_key":false},{"name":"contactCount","type":"int","nullable":false,"primary_key":false},{"name":"taxCode","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"package_id","type":"int","nullable":false,"primary_key":false},{"name":"facebook","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"twitter","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"googlep","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"skype","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"linkedin","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"youtube","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"instagram","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"pinterest","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"whatsapp","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"postalCode","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"mobile","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"slogan","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"publish_only_city","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"featured","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"business_hours","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"notes_hours","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"custom_tab_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"custom_tab_content","type":"text","nullable":true,"primary_key":false},{"name":"job_tab_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"job_tab_content","type":"text","nullable":true,"primary_key":false},{"name":"business_cover_image","type":"varchar(245)","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":"notified_date","type":"timestamp","nullable":true,"primary_key":false},{"name":"time_zone","type":"varchar(15)","nullable":true,"primary_key":false},{"name":"establishment_year","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"employees","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"ad_image","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"disapproval_text","type":"text","nullable":true,"primary_key":false},{"name":"yelp_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"enable_request_quote","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"trail_weeks_hours","type":"text","nullable":true,"primary_key":false},{"name":"trail_weeks_status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"trail_weeks_address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"ad_caption","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"recommended","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"company_view","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"opening_status","type":"tinyint","nullable":false,"primary_key":false},{"name":"min_project_size","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"hourly_rate","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"tiktok","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"areas_served","type":"varchar(455)","nullable":true,"primary_key":false},{"name":"available_dates","type":"varchar(445)","nullable":true,"primary_key":false},{"name":"review_status","type":"tinyint(1)","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/"}}