{"table_name":"aieo_sales_predictor","full_table_name":"wp_aieo_sales_predictor","description":"Stores aieo sales predictor data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_aieo_sales_predictor` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `grain` varchar(12) NOT NULL DEFAULT 'variation', `product_id` bigint DEFAULT NULL, `parent_product_id` bigint DEFAULT NULL, `prediction_date` date NOT NULL, `current_stock` bigint DEFAULT NULL, `out_of_stock_days` bigint DEFAULT NULL, `out_of_stock_repetitions` bigint DEFAULT 0, `reorder_date` datetime DEFAULT NULL, `reorder_quantity` decimal(20,7) DEFAULT NULL, `price` decimal(20,2) DEFAULT NULL, `price_before_adjustment` decimal(20,2) DEFAULT NULL, `price_adjustment_percentage` decimal(20,7) DEFAULT NULL, `latest_price_adjustment_date` datetime DEFAULT NULL, `price_update_repetitions` bigint DEFAULT 0, `total_product_sales` decimal(20,7) DEFAULT NULL, `total_product_turnover` decimal(20,7) DEFAULT NULL, `quantity_sold_yesterday` decimal(20,7) DEFAULT NULL, `turnover_yesterday` decimal(20,7) DEFAULT NULL, `quantity_last_7_days` decimal(20,7) DEFAULT NULL, `quantity_last_14_days` decimal(20,7) DEFAULT NULL, `quantity_last_28_days` decimal(20,7) DEFAULT NULL, `quantity_last_56_days` decimal(20,7) DEFAULT NULL, `quantity_last_175_days` decimal(20,7) DEFAULT NULL, `quantity_next_7_days` decimal(20,7) DEFAULT NULL, `quantity_next_14_days` decimal(20,7) DEFAULT NULL, `quantity_next_28_days` decimal(20,7) DEFAULT NULL, `quantity_next_56_days` decimal(20,7) DEFAULT NULL, `quantity_next_175_days` decimal(20,7) DEFAULT NULL, `turnover_last_7_days` decimal(20,7) DEFAULT NULL, `turnover_last_14_days` decimal(20,7) DEFAULT NULL, `turnover_last_28_days` decimal(20,7) DEFAULT NULL, `turnover_last_56_days` decimal(20,7) DEFAULT NULL, `turnover_last_175_days` decimal(20,7) DEFAULT NULL, `turnover_next_7_days` decimal(20,7) DEFAULT NULL, `turnover_next_14_days` decimal(20,7) DEFAULT NULL, `turnover_next_28_days` decimal(20,7) DEFAULT NULL, `turnover_next_56_days` decimal(20,7) DEFAULT NULL, `turnover_next_175_days` decimal(20,7) DEFAULT NULL, `items_per_day_last_7_days` decimal(20,7) DEFAULT NULL, `items_per_day_last_14_days` decimal(20,7) DEFAULT NULL, `items_per_day_last_28_days` decimal(20,7) DEFAULT NULL, `items_per_day_last_56_days` decimal(20,7) DEFAULT NULL, `items_per_day_last_175_days` decimal(20,7) DEFAULT NULL, `items_per_day_next_7_days` decimal(20,7) DEFAULT NULL, `items_per_day_next_14_days` decimal(20,7) DEFAULT NULL, `items_per_day_next_28_days` decimal(20,7) DEFAULT NULL, `items_per_day_next_56_days` decimal(20,7) DEFAULT NULL, `items_per_day_next_175_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_last_7_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_last_14_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_last_28_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_last_56_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_last_175_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_next_7_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_next_14_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_next_28_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_next_56_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_next_175_days` decimal(20,7) DEFAULT NULL, `product_availability_last_year_7` tinyint DEFAULT NULL, `product_availability_last_year_14` tinyint DEFAULT NULL, `product_availability_last_year_28` tinyint DEFAULT NULL, `product_availability_last_year_56` tinyint DEFAULT NULL, `product_availability_last_year_175` tinyint DEFAULT NULL, `linear_items_per_day` decimal(20,7) DEFAULT NULL, `ewma_items_per_day` decimal(20,7) DEFAULT NULL, `optimistic_estimator_value` decimal(20,7) DEFAULT NULL, `optimistic_estimator_name` varchar(40) DEFAULT NULL, `pessimistic_estimator_value` decimal(20,7) DEFAULT NULL, `pessimistic_estimator_name` varchar(40) DEFAULT NULL, `average_estimator_value` decimal(20,7) DEFAULT NULL, `linear_estimator_value` decimal(20,7) DEFAULT NULL, `ewma_estimator_value` decimal(20,7) DEFAULT NULL, `days_until_stock_run_out_linear` decimal(20,7) DEFAULT NULL, `days_until_stock_run_out_ewma` decimal(20,7) DEFAULT NULL, `estimated_zero_stock_date` datetime DEFAULT NULL, `days_to_sell_10_units_linear` decimal(20,7) DEFAULT NULL, `days_to_sell_10_units_ewma` decimal(20,7) DEFAULT NULL, `estimated_date_to_sell_10_units` datetime DEFAULT NULL, `optimistic_cost` decimal(20,7) DEFAULT NULL, `pessimistic_cost` decimal(20,7) DEFAULT NULL, `average_cost` decimal(20,7) DEFAULT NULL, `chosen_method` varchar(40) DEFAULT NULL, `chosen_items_per_day` decimal(20,7) DEFAULT NULL, `chosen_days_until_runout` decimal(20,7) DEFAULT NULL, `chosen_zero_stock_date` datetime DEFAULT NULL, `chosen_estimator_value` decimal(20,7) DEFAULT NULL, `prediction_confidence` decimal(6,4) DEFAULT NULL, `reliability_score` decimal(6,4) DEFAULT NULL, `transactions_total` bigint DEFAULT 0, `variation_share_of_parent` decimal(6,4) DEFAULT NULL, `uses_parent_signal` tinyint DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `uq_grain_product_date` (`grain`,`product_id`,`prediction_date`), KEY `idx_grain_date` (`grain`,`prediction_date`), KEY `idx_current_stock` (`current_stock`), KEY `idx_parent` (`parent_product_id`), KEY `idx_reorder_date` (`reorder_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":"parent_product_id","type":"bigint","nullable":true,"primary_key":false},{"name":"prediction_date","type":"date","nullable":false,"primary_key":false},{"name":"current_stock","type":"bigint","nullable":true,"primary_key":false},{"name":"out_of_stock_days","type":"bigint","nullable":true,"primary_key":false},{"name":"out_of_stock_repetitions","type":"bigint","nullable":true,"primary_key":false},{"name":"reorder_date","type":"datetime","nullable":true,"primary_key":false},{"name":"reorder_quantity","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"price_before_adjustment","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"price_adjustment_percentage","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"latest_price_adjustment_date","type":"datetime","nullable":true,"primary_key":false},{"name":"price_update_repetitions","type":"bigint","nullable":true,"primary_key":false},{"name":"total_product_sales","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"total_product_turnover","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"quantity_sold_yesterday","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_yesterday","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"quantity_last_7_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"quantity_last_14_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"quantity_last_28_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"quantity_last_56_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"quantity_last_175_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"quantity_next_7_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"quantity_next_14_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"quantity_next_28_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"quantity_next_56_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"quantity_next_175_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_last_7_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_last_14_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_last_28_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_last_56_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_last_175_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_next_7_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_next_14_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_next_28_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_next_56_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_next_175_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"items_per_day_last_7_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"items_per_day_last_14_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"items_per_day_last_28_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"items_per_day_last_56_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"items_per_day_last_175_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"items_per_day_next_7_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"items_per_day_next_14_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"items_per_day_next_28_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"items_per_day_next_56_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"items_per_day_next_175_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_per_day_last_7_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_per_day_last_14_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_per_day_last_28_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_per_day_last_56_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_per_day_last_175_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_per_day_next_7_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_per_day_next_14_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_per_day_next_28_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_per_day_next_56_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"turnover_per_day_next_175_days","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"product_availability_last_year_7","type":"tinyint","nullable":true,"primary_key":false},{"name":"product_availability_last_year_14","type":"tinyint","nullable":true,"primary_key":false},{"name":"product_availability_last_year_28","type":"tinyint","nullable":true,"primary_key":false},{"name":"product_availability_last_year_56","type":"tinyint","nullable":true,"primary_key":false},{"name":"product_availability_last_year_175","type":"tinyint","nullable":true,"primary_key":false},{"name":"linear_items_per_day","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"ewma_items_per_day","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"optimistic_estimator_value","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"optimistic_estimator_name","type":"varchar(40)","nullable":true,"primary_key":false},{"name":"pessimistic_estimator_value","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"pessimistic_estimator_name","type":"varchar(40)","nullable":true,"primary_key":false},{"name":"average_estimator_value","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"linear_estimator_value","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"ewma_estimator_value","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"days_until_stock_run_out_linear","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"days_until_stock_run_out_ewma","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"estimated_zero_stock_date","type":"datetime","nullable":true,"primary_key":false},{"name":"days_to_sell_10_units_linear","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"days_to_sell_10_units_ewma","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"estimated_date_to_sell_10_units","type":"datetime","nullable":true,"primary_key":false},{"name":"optimistic_cost","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"pessimistic_cost","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"average_cost","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"chosen_method","type":"varchar(40)","nullable":true,"primary_key":false},{"name":"chosen_items_per_day","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"chosen_days_until_runout","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"chosen_zero_stock_date","type":"datetime","nullable":true,"primary_key":false},{"name":"chosen_estimator_value","type":"decimal(20,7)","nullable":true,"primary_key":false},{"name":"prediction_confidence","type":"decimal(6,4)","nullable":true,"primary_key":false},{"name":"reliability_score","type":"decimal(6,4)","nullable":true,"primary_key":false},{"name":"transactions_total","type":"bigint","nullable":true,"primary_key":false},{"name":"variation_share_of_parent","type":"decimal(6,4)","nullable":true,"primary_key":false},{"name":"uses_parent_signal","type":"tinyint","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/"}}