{"table_name":"aieo_sales_predictor_accuracy","full_table_name":"wp_aieo_sales_predictor_accuracy","description":"Stores aieo sales predictor accuracy data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_aieo_sales_predictor_accuracy` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `grain` varchar(12) NOT NULL DEFAULT 'variation', `segment_type` varchar(20) NOT NULL DEFAULT 'global', `segment_key` varchar(64) NOT NULL DEFAULT '', `method` varchar(40) NOT NULL, `n_samples` int DEFAULT 0, `mape` decimal(10,4) DEFAULT NULL, `bias` decimal(20,7) DEFAULT NULL, `ewma_abs_err` decimal(20,7) DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uq_grain_segment_method` (`grain`,`segment_type`,`segment_key`,`method`) ) ENGINE","columns":[{"name":"id","type":"bigint unsigned","nullable":false,"primary_key":true},{"name":"grain","type":"varchar(12)","nullable":false,"primary_key":false},{"name":"segment_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"segment_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"method","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"n_samples","type":"int","nullable":true,"primary_key":false},{"name":"mape","type":"decimal(10,4)","nullable":true,"primary_key":false},{"name":"bias","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"ewma_abs_err","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"updated_at","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/"}}