{"table_name":"jbusinessdirectory_conference_speakers","full_table_name":"wp_jbusinessdirectory_conference_speakers","description":"Stores jbusinessdirectory conference speakers data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_speakers` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(75) DEFAULT NULL, `alias` varchar(125) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `company_name` varchar(55) DEFAULT NULL, `company_logo` varchar(255) DEFAULT NULL, `countryId` int DEFAULT NULL, `speaker_language` varchar(100) DEFAULT NULL, `biography` text, `sessionId` int DEFAULT NULL, `photo` varchar(255) DEFAULT NULL, `speakertypeId` int DEFAULT NULL, `featured` tinyint(1) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `facebook` varchar(100) DEFAULT NULL, `twitter` varchar(100) DEFAULT NULL, `googlep` varchar(100) DEFAULT NULL, `linkedin` varchar(100) DEFAULT NULL, `short_biography` text, `additional_info_link` varchar(100) DEFAULT NULL, `viewCount` int NOT NULL DEFAULT '0', `published` tinyint(1) NOT NULL DEFAULT '1', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_published` (`published`), KEY `idx_speakertypeId` (`speakertypeId`), KEY `idx_name` (`name`), KEY `idx_title` (`title`), KEY `idx_company_name` (`company_name`), KEY `idx_phone` (`phone`), KEY `idx_countryId` (`countryId`), KEY `idx_alias` (`alias`), KEY `idx_session` (`sessionId`), KEY `idx_featured` (`featured`) ) ENGINE","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(75)","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(125)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"company_name","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"company_logo","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"countryId","type":"int","nullable":true,"primary_key":false},{"name":"speaker_language","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"biography","type":"text","nullable":true,"primary_key":false},{"name":"sessionId","type":"int","nullable":true,"primary_key":false},{"name":"photo","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"speakertypeId","type":"int","nullable":true,"primary_key":false},{"name":"featured","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"facebook","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"twitter","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"googlep","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"linkedin","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"short_biography","type":"text","nullable":true,"primary_key":false},{"name":"additional_info_link","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"viewCount","type":"int","nullable":false,"primary_key":false},{"name":"published","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created","type":"timestamp","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/"}}