{"table_name":"aieo_sales_predictor_history","full_table_name":"wp_aieo_sales_predictor_history","description":"Stores aieo sales predictor history data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_aieo_sales_predictor_history` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `grain` varchar(12) NOT NULL DEFAULT 'variation', `product_id` bigint DEFAULT NULL, `snapshot_date` date NOT NULL, `current_stock` bigint DEFAULT NULL, `price` decimal(20,2) DEFAULT NULL, `ipd_linear` decimal(20,7) DEFAULT NULL, `ipd_ewma` decimal(20,7) DEFAULT NULL, `ipd_average` decimal(20,7) DEFAULT NULL, `chosen_ipd` decimal(20,7) DEFAULT NULL, `chosen_method` varchar(40) DEFAULT NULL, `est_zero_stock_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uq_grain_product_snap` (`grain`,`product_id`,`snapshot_date`), KEY `idx_snap` (`snapshot_date`) ) ENGINE","columns":[{"name":"id","type":"bigint unsigned","nullable":false,"primary_key":true},{"name":"grain","type":"varchar(12)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint","nullable":true,"primary_key":false},{"name":"snapshot_date","type":"date","nullable":false,"primary_key":false},{"name":"current_stock","type":"bigint","nullable":true,"primary_key":false},{"name":"price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ipd_linear","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"ipd_ewma","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"ipd_average","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"chosen_ipd","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"chosen_method","type":"varchar(40)","nullable":true,"primary_key":false},{"name":"est_zero_stock_date","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"ai-eshop-optimizer","name":"AI eShop Optimizer","active_installs":10,"version":"8.3","wp_org_url":"https://wordpress.org/plugins/ai-eshop-optimizer/"}}