{"table_name":"jbusinessdirectory_company_events","full_table_name":"wp_jbusinessdirectory_company_events","description":"Stores jbusinessdirectory company events data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_events` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int DEFAULT NULL, `name` varchar(110) DEFAULT NULL, `alias` varchar(100) DEFAULT NULL, `short_description` varchar(245) DEFAULT NULL, `description` text, `meta_title` varchar(100) DEFAULT NULL, `meta_description` text, `meta_keywords` text, `price` varchar(100) DEFAULT NULL, `type` int DEFAULT NULL, `start_date` date DEFAULT NULL, `start_time` time DEFAULT NULL, `end_date` date DEFAULT NULL, `end_time` time DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `street_number` varchar(100) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `county` varchar(45) DEFAULT NULL, `province` varchar(60) DEFAULT NULL, `area` varchar(60) DEFAULT NULL, `location` varchar(45) 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, `view_count` int NOT NULL DEFAULT '0', `approved` tinyint(1) NOT NULL DEFAULT '0', `state` tinyint(1) DEFAULT NULL, `recurring_id` int DEFAULT NULL, `contact_phone` varchar(20) DEFAULT NULL, `contact_email` varchar(60) DEFAULT NULL, `doors_open_time` time DEFAULT NULL, `booking_open_date` date DEFAULT NULL, `booking_close_date` date DEFAULT NULL, `booking_open_time` time DEFAULT NULL, `booking_close_time` time DEFAULT NULL, `show_start_time` tinyint(1) NOT NULL DEFAULT '0', `show_end_time` tinyint(1) NOT NULL DEFAULT '0', `show_end_date` tinyint(1) NOT NULL DEFAULT '0', `show_doors_open_time` tinyint(1) NOT NULL DEFAULT '0', `currency_id` int NOT NULL DEFAULT '0', `total_tickets` int DEFAULT NULL, `expiration_email_date` datetime DEFAULT NULL, `main_subcategory` int DEFAULT NULL, `user_id` int DEFAULT NULL, `enable_subscription` tinyint(1) NOT NULL DEFAULT '0', `postalCode` varchar(55) DEFAULT NULL, `countryId` int DEFAULT NULL, `time_zone` varchar(15) DEFAULT NULL, `recurring_info` varchar(255) DEFAULT NULL, `attendance_mode` tinyint DEFAULT NULL, `attendance_url` varchar(245) DEFAULT NULL, `min_age` tinyint DEFAULT NULL, `max_age` tinyint DEFAULT NULL, `ticket_url` varchar(255) DEFAULT NULL, `cover_image` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_company` (`company_id`), KEY `idx_name` (`name`), KEY `idx_alias` (`alias`), KEY `idx_countryId` (`countryId`), KEY `idx_created` (`created`), KEY `idx_recurring_id` (`recurring_id`), KEY `idx_expiration_email_date` (`expiration_email_date`), KEY `idx_user_id` (`user_id`), KEY `idx_search` (`start_date`,`end_time`,`end_date`,`state`,`approved`,`start_time`), KEY `idx_type` (`type`), KEY `idx_featured` (`featured`), KEY `idx_currency` (`currency_id`) ) ENGINE","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":true,"primary_key":false},{"name":"name","type":"varchar(110)","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"short_description","type":"varchar(245)","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":"varchar(100)","nullable":true,"primary_key":false},{"name":"type","type":"int","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"start_time","type":"time","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"end_time","type":"time","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":"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":"location","type":"varchar(45)","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":"view_count","type":"int","nullable":false,"primary_key":false},{"name":"approved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"state","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"recurring_id","type":"int","nullable":true,"primary_key":false},{"name":"contact_phone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"contact_email","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"doors_open_time","type":"time","nullable":true,"primary_key":false},{"name":"booking_open_date","type":"date","nullable":true,"primary_key":false},{"name":"booking_close_date","type":"date","nullable":true,"primary_key":false},{"name":"booking_open_time","type":"time","nullable":true,"primary_key":false},{"name":"booking_close_time","type":"time","nullable":true,"primary_key":false},{"name":"show_start_time","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_end_time","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_end_date","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_doors_open_time","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"currency_id","type":"int","nullable":false,"primary_key":false},{"name":"total_tickets","type":"int","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":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"enable_subscription","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"postalCode","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"countryId","type":"int","nullable":true,"primary_key":false},{"name":"time_zone","type":"varchar(15)","nullable":true,"primary_key":false},{"name":"recurring_info","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attendance_mode","type":"tinyint","nullable":true,"primary_key":false},{"name":"attendance_url","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"min_age","type":"tinyint","nullable":true,"primary_key":false},{"name":"max_age","type":"tinyint","nullable":true,"primary_key":false},{"name":"ticket_url","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"cover_image","type":"varchar(255)","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/"}}