{"table_name":"jbusinessdirectory_attributes","full_table_name":"wp_jbusinessdirectory_attributes","description":"Stores jbusinessdirectory attributes data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_jbusinessdirectory_attributes` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `code` varchar(100) DEFAULT NULL, `type` int DEFAULT NULL, `status` int DEFAULT NULL, `is_mandatory` int NOT NULL DEFAULT '0', `show_in_filter` tinyint(1) NOT NULL DEFAULT '1', `only_for_admin` tinyint(1) NOT NULL DEFAULT '0', `show_in_front` tinyint(1) NOT NULL DEFAULT '0', `show_on_search` tinyint(1) NOT NULL DEFAULT '0', `show_icon` tinyint(1) NOT NULL DEFAULT '0', `show_name` tinyint(1) NOT NULL DEFAULT '1', `color` varchar(10) DEFAULT NULL, `group` varchar(255) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', `attribute_type` tinyint(1) NOT NULL DEFAULT '1', `show_in_list_view` tinyint(1) NOT NULL DEFAULT '0', `use_attribute_for_selling` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_status` (`status`), KEY `idx_type` (`type`), KEY `idx_attribute_type` (`attribute_type`) ) ENGINE","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"code","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"type","type":"int","nullable":true,"primary_key":false},{"name":"status","type":"int","nullable":true,"primary_key":false},{"name":"is_mandatory","type":"int","nullable":false,"primary_key":false},{"name":"show_in_filter","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"only_for_admin","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_in_front","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_on_search","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_icon","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_name","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"color","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"group","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"attribute_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_in_list_view","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"use_attribute_for_selling","type":"tinyint(1)","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/"}}