{"table_name":"aieo_variations_stock_condition","full_table_name":"wp_aieo_variations_stock_condition","description":"Stores aieo variations stock condition data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_aieo_variations_stock_condition` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `product_id` bigint NOT NULL, `name` varchar(255) DEFAULT NULL, `brand` varchar(255) DEFAULT NULL, `menu_category` varchar(255) DEFAULT NULL, `sub_category` varchar(255) DEFAULT NULL, `image_url` varchar(500) DEFAULT NULL, `total_variations` int NOT NULL DEFAULT 0, `instock_variations` int NOT NULL DEFAULT 0, `out_of_stock_variations` int NOT NULL DEFAULT 0, `pct_out_of_stock` decimal(7,2) NOT NULL DEFAULT 0.00, `latest_sale_gmt` datetime DEFAULT NULL, `created` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uq_product_id` (`product_id`), KEY `idx_pct_out_of_stock` (`pct_out_of_stock`) ) ENGINE","columns":[{"name":"id","type":"bigint unsigned","nullable":false,"primary_key":true},{"name":"product_id","type":"bigint","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"brand","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"menu_category","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"sub_category","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"image_url","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"total_variations","type":"int","nullable":false,"primary_key":false},{"name":"instock_variations","type":"int","nullable":false,"primary_key":false},{"name":"out_of_stock_variations","type":"int","nullable":false,"primary_key":false},{"name":"pct_out_of_stock","type":"decimal(7,2)","nullable":false,"primary_key":false},{"name":"latest_sale_gmt","type":"datetime","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"ai-eshop-optimizer","name":"Rooster One","active_installs":10,"version":"11.2.2","wp_org_url":"https://wordpress.org/plugins/ai-eshop-optimizer/"}}