{"table_name":"amazon_product_types","full_table_name":"wp_amazon_product_types","description":"Stores product records and related data.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_product_types` ( `id` bigint(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `marketplace_id` varchar(25) NOT NULL, `product_type` varchar(100) NOT NULL, `display_name` varchar(150) NOT NULL, `version` varchar(100) NOT NULL, `property_groups` longtext NOT NULL, `schema` longtext NOT NULL );","columns":[{"name":"id","type":"bigint(11)","nullable":false,"primary_key":true},{"name":"marketplace_id","type":"varchar(25)","nullable":false,"primary_key":false},{"name":"product_type","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"display_name","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"version","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"property_groups","type":"longtext","nullable":false,"primary_key":false},{"name":"schema","type":"longtext","nullable":false,"primary_key":false}],"plugin":{"slug":"wp-lister-for-amazon","name":"WP-Lister Lite for Amazon","active_installs":800,"version":"2.9.1","wp_org_url":"https://wordpress.org/plugins/wp-lister-for-amazon/"}}