{"table_name":"jbusinessdirectory_company_contact","full_table_name":"wp_jbusinessdirectory_company_contact","description":"Stores jbusinessdirectory company contact data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_contact` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int NOT NULL, `contact_name` varchar(50) DEFAULT NULL, `contact_function` varchar(50) DEFAULT NULL, `contact_department` varchar(100) DEFAULT NULL, `contact_job_title` varchar(100) DEFAULT NULL, `contact_email` varchar(60) DEFAULT NULL, `contact_phone` varchar(20) DEFAULT NULL, `contact_fax` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`,`companyId`), KEY `R_13` (`companyId`) ) ENGINE","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"companyId","type":"int","nullable":false,"primary_key":false},{"name":"contact_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"contact_function","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"contact_department","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"contact_job_title","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"contact_email","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"contact_phone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"contact_fax","type":"varchar(20)","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/"}}