{"slug":"ai-eshop-optimizer","name":"Rooster One","description":"SEO, recommendations, pricing, pixels, couriers, feeds, wishlist, AI chat: 581 tools replacing dozens of plugins. One to load, and they agree.","author":"Oxford Metadata Ltd","active_installs":10,"version":"11.2.2","wp_org_url":"https://wordpress.org/plugins/ai-eshop-optimizer/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_","full_table_name":"wp_aieo_","description":"Stores aieo  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_ab_impressions","full_table_name":"wp_aieo_ab_impressions","description":"Stores aieo ab impressions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_addcart_events","full_table_name":"wp_aieo_addcart_events","description":"Stores aieo addcart events data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_addcart_events_archive","full_table_name":"wp_aieo_addcart_events_archive","description":"Stores aieo addcart events archive data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_adv_stats_orders_rn","full_table_name":"wp_aieo_adv_stats_orders_rn","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"EponymousId","type":"INT","nullable":true,"primary_key":false},{"name":"OrderId","type":"BIGINT","nullable":true,"primary_key":false},{"name":"OrderDate","type":"DATETIME","nullable":true,"primary_key":false},{"name":"OrderItemsTotal","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"rn","type":"INT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_aieo_adv_stats_orders_rn ( EponymousId INT, OrderId BIGINT, OrderDate DATETIME, OrderItemsTotal DECIMAL(10,2), rn INT, INDEX idx_eponymous (EponymousId), INDEX idx_eponymous_rn (EponymousId, rn) ) ENGINE"},{"table_name":"aieo_adv_stats_orders_rn_copy","full_table_name":"wp_aieo_adv_stats_orders_rn_copy","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"EponymousId","type":"INT","nullable":true,"primary_key":false},{"name":"OrderId","type":"BIGINT","nullable":true,"primary_key":false},{"name":"OrderDate","type":"DATETIME","nullable":true,"primary_key":false},{"name":"OrderItemsTotal","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"rn","type":"INT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_aieo_adv_stats_orders_rn_copy ( EponymousId INT, OrderId BIGINT, OrderDate DATETIME, OrderItemsTotal DECIMAL(10,2), rn INT, INDEX idx_eponymous (EponymousId), INDEX idx_eponymous_rn (EponymousId, rn) ) ENGINE"},{"table_name":"aieo_ai_models","full_table_name":"wp_aieo_ai_models","description":"Stores aieo ai models data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_attribution_cost","full_table_name":"wp_aieo_attribution_cost","description":"Stores aieo attribution cost data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_audiences","full_table_name":"wp_aieo_audiences","description":"Stores aieo audiences data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_aw_migrate","full_table_name":"wp_aieo_aw_migrate","description":"Stores aieo aw migrate data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_bandit_run","full_table_name":"wp_aieo_bandit_run","description":"Stores aieo bandit run data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_base_order_stats","full_table_name":"wp_aieo_base_order_stats","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_boost_candidates","full_table_name":"wp_aieo_boost_candidates","description":"Stores aieo boost candidates data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_boost_rebuild","full_table_name":"wp_aieo_boost_rebuild","description":"Stores aieo boost rebuild data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_boost_weights","full_table_name":"wp_aieo_boost_weights","description":"Stores aieo boost weights data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_campaign_forecasts","full_table_name":"wp_aieo_campaign_forecasts","description":"Stores aieo campaign forecasts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_cart_items","full_table_name":"wp_aieo_cart_items","description":"Stores aieo cart items data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_carts","full_table_name":"wp_aieo_carts","description":"Stores aieo carts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_chat_business_info","full_table_name":"wp_aieo_chat_business_info","description":"Stores aieo chat business info data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_chat_content_gaps","full_table_name":"wp_aieo_chat_content_gaps","description":"Stores aieo chat content gaps data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_chat_embeddings","full_table_name":"wp_aieo_chat_embeddings","description":"Stores aieo chat embeddings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_chat_history","full_table_name":"wp_aieo_chat_history","description":"Stores aieo chat history data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_checkout_timing","full_table_name":"wp_aieo_checkout_timing","description":"Stores aieo checkout timing data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_competition_participants","full_table_name":"wp_aieo_competition_participants","description":"Stores aieo competition participants data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"aieo_consent_cookies","full_table_name":"wp_aieo_consent_cookies","description":"Stores aieo consent cookies data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_consent_log","full_table_name":"wp_aieo_consent_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_content_consumption_facts","full_table_name":"wp_aieo_content_consumption_facts","description":"Stores aieo content consumption facts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_content_text","full_table_name":"wp_aieo_content_text","description":"Stores aieo content text data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_conversions","full_table_name":"wp_aieo_conversions","description":"Stores aieo conversions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_brand_vitals","full_table_name":"wp_aieo_core_brand_vitals","description":"Stores aieo core brand vitals data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_category_brand_popularity","full_table_name":"wp_aieo_core_category_brand_popularity","description":"Stores aieo core category brand popularity data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_content_vitals","full_table_name":"wp_aieo_core_content_vitals","description":"Stores aieo core content vitals data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_product_attributes","full_table_name":"wp_aieo_core_product_attributes","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_product_category_hierarchy","full_table_name":"wp_aieo_core_product_category_hierarchy","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_product_vitals","full_table_name":"wp_aieo_core_product_vitals","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_reciprocal_products","full_table_name":"wp_aieo_core_reciprocal_products","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_variation_vitals","full_table_name":"wp_aieo_core_variation_vitals","description":"Stores aieo core variation vitals data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_coupon_grants","full_table_name":"wp_aieo_coupon_grants","description":"Stores aieo coupon grants data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_cumulative_customer_stats","full_table_name":"wp_aieo_cumulative_customer_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_cumulative_order_stats","full_table_name":"wp_aieo_cumulative_order_stats","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":"create table IF NOT EXISTS wp_aieo_cumulative_order_stats (INDEX order_id_idx (OrderID, CustomerEmail)) SELECT ws1.orderid as OrderID, ws1.customeremail as CustomerEmail, ws1.statsclientid as StatsClientID, ws1.postcode as Postcode, ws1.orderspend as OrderSpend, ws1.numberofitemsperorder as NumberOfItemsPerOrder, Round(a.avg_spend,2) as TotalAverageOrder, Round(ws1.orderspend/(ws1.numberofitemsperorder),2) as AveSpendOfUserPerItemPerOrder, ws1.numberoforders as TotalNumberofOrders, Round(a.avg_items,2) as AveItemsOfUserPerOrder, Round(a.std_items,2) as STDItemsOfUser, Round( a.std_items /a.min_items ,2) as STDPerMinItemsOfUser, Round( a.std_items /a.avg_items ,2) as STDPerAverageItemsOfUser, Round( a.std_items /a.max_items ,2) as STDPerMaxItemsOfUser, Round(a.avg_spend,2) as AveSpendOfUserPerOrder, Round(a.std_spend,2) as STDSpendOfUser, Round( a.std_spend /a.min_spend ,2) as STDPerMinSpendOfUser, Round( a.std_spend /a.avg_spend ,2) as STDPerAverageSpendOfUser, Round( a.std_spend /a.max_spend ,2) as STDPerMaxSpendOfUser, ws1.buyerspayrol as BuyersPayrol, ws1.buyersday as BuyersDay, ws1.buyerstime as BuyersTime, ws1.link_to_order_details as link_to_order_details FROM wp_aieo_order_stats ws1 JOIN _cum_cust a on a.customeremail = ws1.customeremail Order by ws1.customeremail; DROP TEMPORARY TABLE IF EXISTS _cum_cust; ALTER TABLE wp_aieo_cumulative_order_stats ADD COLUMN `id` BIGINT(45) UNSIGNED NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`);"},{"table_name":"aieo_cumulative_order_stats_new","full_table_name":"wp_aieo_cumulative_order_stats_new","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":"create table wp_aieo_cumulative_order_stats_new (INDEX order_id_idx (OrderID, CustomerEmail)) SELECT ws1.orderid as OrderID, ws1.customeremail as CustomerEmail, ws1.statsclientid as StatsClientID, ws1.postcode as Postcode, ws1.orderspend as OrderSpend, ws1.numberofitemsperorder as NumberOfItemsPerOrder, Round(a.avg_spend,2) as TotalAverageOrder, Round(ws1.orderspend/(ws1.numberofitemsperorder),2) as AveSpendOfUserPerItemPerOrder, ws1.numberoforders as TotalNumberofOrders, Round(a.avg_items,2) as AveItemsOfUserPerOrder, Round(a.std_items,2) as STDItemsOfUser, Round( a.std_items /a.min_items ,2) as STDPerMinItemsOfUser, Round( a.std_items /a.avg_items ,2) as STDPerAverageItemsOfUser, Round( a.std_items /a.max_items ,2) as STDPerMaxItemsOfUser, Round(a.avg_spend,2) as AveSpendOfUserPerOrder, Round(a.std_spend,2) as STDSpendOfUser, Round( a.std_spend /a.min_spend ,2) as STDPerMinSpendOfUser, Round( a.std_spend /a.avg_spend ,2) as STDPerAverageSpendOfUser, Round( a.std_spend /a.max_spend ,2) as STDPerMaxSpendOfUser, ws1.buyerspayrol as BuyersPayrol, ws1.buyersday as BuyersDay, ws1.buyerstime as BuyersTime, ws1.link_to_order_details as link_to_order_details FROM wp_aieo_order_stats ws1 JOIN _cum_cust a on a.customeremail = ws1.customeremail Order by ws1.customeremail; DROP TEMPORARY TABLE IF EXISTS _cum_cust; ALTER TABLE wp_aieo_cumulative_order_stats_new ADD COLUMN `id` BIGINT(45) UNSIGNED NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`);"},{"table_name":"aieo_customer_intelligence","full_table_name":"wp_aieo_customer_intelligence","description":"Stores aieo customer intelligence data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_customer_purchases","full_table_name":"wp_aieo_customer_purchases","description":"Stores aieo customer purchases data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_customer_stats_progress","full_table_name":"wp_aieo_customer_stats_progress","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_display_origins","full_table_name":"wp_aieo_display_origins","description":"Stores aieo display origins data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_branch_matchers","full_table_name":"wp_aieo_dmm_branch_matchers","description":"Stores aieo dmm branch matchers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_branch_scan_log","full_table_name":"wp_aieo_dmm_branch_scan_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_branches","full_table_name":"wp_aieo_dmm_branches","description":"Stores aieo dmm branches data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_brand_discounts","full_table_name":"wp_aieo_dmm_brand_discounts","description":"Stores aieo dmm brand discounts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_brand_extras","full_table_name":"wp_aieo_dmm_brand_extras","description":"Stores aieo dmm brand extras data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_brand_gift_offers","full_table_name":"wp_aieo_dmm_brand_gift_offers","description":"Stores aieo dmm brand gift offers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_campaigns","full_table_name":"wp_aieo_dmm_campaigns","description":"Stores aieo dmm campaigns data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_cancellation_reasons","full_table_name":"wp_aieo_dmm_cancellation_reasons","description":"Stores aieo dmm cancellation reasons data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_cat_match_register","full_table_name":"wp_aieo_dmm_cat_match_register","description":"Stores aieo dmm cat match register data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_category_extras","full_table_name":"wp_aieo_dmm_category_extras","description":"Stores aieo dmm category extras data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_color_attributes","full_table_name":"wp_aieo_dmm_color_attributes","description":"Stores aieo dmm color attributes data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_complementary","full_table_name":"wp_aieo_dmm_complementary","description":"Stores aieo dmm complementary data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_contributor_rules","full_table_name":"wp_aieo_dmm_contributor_rules","description":"Stores aieo dmm contributor rules data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_custom_tabs","full_table_name":"wp_aieo_dmm_custom_tabs","description":"Stores aieo dmm custom tabs data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_discount_schedules","full_table_name":"wp_aieo_dmm_discount_schedules","description":"Stores aieo dmm discount schedules data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_exchanger_feeds","full_table_name":"wp_aieo_dmm_exchanger_feeds","description":"Stores aieo dmm exchanger feeds data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_exchanger_imports","full_table_name":"wp_aieo_dmm_exchanger_imports","description":"Stores aieo dmm exchanger imports data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_exchanger_run_log","full_table_name":"wp_aieo_dmm_exchanger_run_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_export_jobs","full_table_name":"wp_aieo_dmm_export_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_feed_cat_map","full_table_name":"wp_aieo_dmm_feed_cat_map","description":"Stores aieo dmm feed cat map data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_feed_configs","full_table_name":"wp_aieo_dmm_feed_configs","description":"Stores aieo dmm feed configs data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_feed_image_queue","full_table_name":"wp_aieo_dmm_feed_image_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_feed_row_terms","full_table_name":"wp_aieo_dmm_feed_row_terms","description":"Stores aieo dmm feed row terms data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_feed_rows","full_table_name":"wp_aieo_dmm_feed_rows","description":"Stores aieo dmm feed rows data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_feed_run_log","full_table_name":"wp_aieo_dmm_feed_run_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_feed_terms","full_table_name":"wp_aieo_dmm_feed_terms","description":"Stores aieo dmm feed terms data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_fulfillment_checkpoints","full_table_name":"wp_aieo_dmm_fulfillment_checkpoints","description":"Stores aieo dmm fulfillment checkpoints data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_fulfillment_closings","full_table_name":"wp_aieo_dmm_fulfillment_closings","description":"Stores aieo dmm fulfillment closings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_fulfillment_documents","full_table_name":"wp_aieo_dmm_fulfillment_documents","description":"Stores aieo dmm fulfillment documents data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_fulfillment_sequences","full_table_name":"wp_aieo_dmm_fulfillment_sequences","description":"Stores aieo dmm fulfillment sequences data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_fulfillment_settings","full_table_name":"wp_aieo_dmm_fulfillment_settings","description":"Stores aieo dmm fulfillment settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_fulfillment_vouchers","full_table_name":"wp_aieo_dmm_fulfillment_vouchers","description":"Stores aieo dmm fulfillment vouchers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_loyalty_assignments","full_table_name":"wp_aieo_dmm_loyalty_assignments","description":"Stores aieo dmm loyalty assignments data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_loyalty_classes","full_table_name":"wp_aieo_dmm_loyalty_classes","description":"Stores aieo dmm loyalty classes data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_loyalty_points","full_table_name":"wp_aieo_dmm_loyalty_points","description":"Stores aieo dmm loyalty points data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_need_extras","full_table_name":"wp_aieo_dmm_need_extras","description":"Stores aieo dmm need extras data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_no_free_shipping","full_table_name":"wp_aieo_dmm_no_free_shipping","description":"Stores aieo dmm no free shipping data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_offer_attributions","full_table_name":"wp_aieo_dmm_offer_attributions","description":"Stores aieo dmm offer attributions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_offers","full_table_name":"wp_aieo_dmm_offers","description":"Stores aieo dmm offers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_order_cancellations","full_table_name":"wp_aieo_dmm_order_cancellations","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_order_line_refunds","full_table_name":"wp_aieo_dmm_order_line_refunds","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_preorder_log","full_table_name":"wp_aieo_dmm_preorder_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_preorder_worksheet","full_table_name":"wp_aieo_dmm_preorder_worksheet","description":"Stores aieo dmm preorder worksheet data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_product_behavior_metrics","full_table_name":"wp_aieo_dmm_product_behavior_metrics","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_product_fp","full_table_name":"wp_aieo_dmm_product_fp","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_product_merge_order_lines","full_table_name":"wp_aieo_dmm_product_merge_order_lines","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_product_merges","full_table_name":"wp_aieo_dmm_product_merges","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_product_needs","full_table_name":"wp_aieo_dmm_product_needs","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_promo_slots","full_table_name":"wp_aieo_dmm_promo_slots","description":"Stores aieo dmm promo slots data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_promo_surfaces","full_table_name":"wp_aieo_dmm_promo_surfaces","description":"Stores aieo dmm promo surfaces data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_role_prices","full_table_name":"wp_aieo_dmm_role_prices","description":"Stores aieo dmm role prices data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_shipping_rates","full_table_name":"wp_aieo_dmm_shipping_rates","description":"Stores aieo dmm shipping rates data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_stock_recovery_events","full_table_name":"wp_aieo_dmm_stock_recovery_events","description":"Stores aieo dmm stock recovery events data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_stock_word_register","full_table_name":"wp_aieo_dmm_stock_word_register","description":"Stores aieo dmm stock word register data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_store_order_log","full_table_name":"wp_aieo_dmm_store_order_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_supplier_extras","full_table_name":"wp_aieo_dmm_supplier_extras","description":"Stores aieo dmm supplier extras data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_supplier_preorders","full_table_name":"wp_aieo_dmm_supplier_preorders","description":"Stores aieo dmm supplier preorders data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_swatches_cache","full_table_name":"wp_aieo_dmm_swatches_cache","description":"A cache table that stores temporary computed or fetched data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_swatches_variation_map","full_table_name":"wp_aieo_dmm_swatches_variation_map","description":"Stores aieo dmm swatches variation map data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_term_relations","full_table_name":"wp_aieo_dmm_term_relations","description":"Stores aieo dmm term relations data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_user_behavior_metrics","full_table_name":"wp_aieo_dmm_user_behavior_metrics","description":"Stores aieo dmm user behavior metrics data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_user_fp","full_table_name":"wp_aieo_dmm_user_fp","description":"Stores aieo dmm user fp data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_dmm_withdrawal_declarations","full_table_name":"wp_aieo_dmm_withdrawal_declarations","description":"Stores aieo dmm withdrawal declarations data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_email_suppression","full_table_name":"wp_aieo_email_suppression","description":"Stores aieo email suppression data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_entry_credit_daily","full_table_name":"wp_aieo_entry_credit_daily","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_erp_store_customers","full_table_name":"wp_aieo_erp_store_customers","description":"Stores aieo erp store customers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_erp_store_orders","full_table_name":"wp_aieo_erp_store_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_erp_store_products","full_table_name":"wp_aieo_erp_store_products","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_event_participants","full_table_name":"wp_aieo_event_participants","description":"Stores aieo event participants data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_exit_daily","full_table_name":"wp_aieo_exit_daily","description":"Stores aieo exit daily data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_exit_facts","full_table_name":"wp_aieo_exit_facts","description":"Stores aieo exit facts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_form_entries","full_table_name":"wp_aieo_form_entries","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_form_entry_values","full_table_name":"wp_aieo_form_entry_values","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_google_locations","full_table_name":"wp_aieo_google_locations","description":"Stores aieo google locations data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_google_reviews","full_table_name":"wp_aieo_google_reviews","description":"Stores aieo google reviews data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_google_user_journey","full_table_name":"wp_aieo_google_user_journey","description":"Stores aieo google user journey data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_gsc_daily","full_table_name":"wp_aieo_gsc_daily","description":"Stores aieo gsc daily data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_interaction_summary","full_table_name":"wp_aieo_interaction_summary","description":"Stores aieo interaction summary data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_landing_campaign_daily","full_table_name":"wp_aieo_landing_campaign_daily","description":"Stores aieo landing campaign daily data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_landing_facts","full_table_name":"wp_aieo_landing_facts","description":"Stores aieo landing facts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_marketing_stats","full_table_name":"wp_aieo_marketing_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_moi_inbound_log","full_table_name":"wp_aieo_moi_inbound_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_moi_order_links","full_table_name":"wp_aieo_moi_order_links","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_moi_vendors","full_table_name":"wp_aieo_moi_vendors","description":"Stores aieo moi vendors data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_msg_stats","full_table_name":"wp_aieo_msg_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_newsletter_sync_log","full_table_name":"wp_aieo_newsletter_sync_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_option_groups","full_table_name":"wp_aieo_option_groups","description":"Stores aieo option groups data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_option_prices","full_table_name":"wp_aieo_option_prices","description":"Stores aieo option prices data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_options","full_table_name":"wp_aieo_options","description":"Stores aieo options data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_order_attribution","full_table_name":"wp_aieo_order_attribution","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"channel","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"channel_group","type":"varchar(32)","nullable":true,"primary_key":false},{"name":"utm_source","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"utm_medium","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"utm_campaign","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"utm_term","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"utm_content","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"origin","type":"varchar(12)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_aieo_order_attribution` ( `order_id` bigint(20) unsigned NOT NULL, `channel` varchar(255) DEFAULT NULL, `channel_group` varchar(32) DEFAULT NULL, `utm_source` varchar(255) DEFAULT NULL, `utm_medium` varchar(255) DEFAULT NULL, `utm_campaign` varchar(255) DEFAULT NULL, `utm_term` varchar(255) DEFAULT NULL, `utm_content` varchar(255) DEFAULT NULL, `origin` varchar(12) DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`order_id`), KEY `idx_channel` (`channel`), KEY `idx_channel_group` (`channel_group`), KEY `idx_origin` (`origin`) ) ENGINE"},{"table_name":"aieo_order_invoice_match_report","full_table_name":"wp_aieo_order_invoice_match_report","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"report_month","type":"CHAR(7)","nullable":true,"primary_key":false},{"name":"customer_email","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"order_datetime","type":"DATETIME","nullable":true,"primary_key":false},{"name":"woo_total","type":"DECIMAL(12,2)","nullable":true,"primary_key":false},{"name":"woo_qty_sum","type":"DECIMAL(12,3)","nullable":true,"primary_key":false},{"name":"shippingtype","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"order_status","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"invoice_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"invoice_code","type":"VARCHAR(40)","nullable":true,"primary_key":false},{"name":"invoice_branch","type":"VARCHAR(150)","nullable":true,"primary_key":false},{"name":"invoice_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"invoice_total","type":"DECIMAL(12,2)","nullable":true,"primary_key":false},{"name":"invoice_qty_sum","type":"DECIMAL(12,3)","nullable":true,"primary_key":false},{"name":"overlap_sku_count","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"overlap_pct_vs_order","type":"DECIMAL(5,1)","nullable":true,"primary_key":false},{"name":"overlap_pct_vs_invoice","type":"DECIMAL(5,1)","nullable":true,"primary_key":false},{"name":"price_diff_pct","type":"DECIMAL(6,2)","nullable":true,"primary_key":false},{"name":"date_diff_days","type":"INT","nullable":true,"primary_key":false},{"name":"match_status","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"notes","type":"VARCHAR(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aieo_order_invoice_match_report ( report_month CHAR(7) NULL, -- 'YYYY-MM' order_id BIGINT UNSIGNED NULL, customer_email VARCHAR(255) NULL, order_datetime DATETIME NULL, woo_total DECIMAL(12,2) NULL, -- full Woo total woo_net_total DECIMAL(12,2) NULL, -- products-only total (for comparisons) woo_line_items INT UNSIGNED NULL, woo_qty_sum DECIMAL(12,3) NULL, shippingtype VARCHAR(255) NULL, order_status VARCHAR(50) NULL, invoice_id BIGINT UNSIGNED NULL, invoice_code VARCHAR(40) NULL, invoice_branch VARCHAR(150) NULL, invoice_date DATETIME NULL, invoice_total DECIMAL(12,2) NULL, -- ERP line totals (no VAT uplift) invoice_line_items INT UNSIGNED NULL, invoice_qty_sum DECIMAL(12,3) NULL, overlap_sku_count INT UNSIGNED NULL, overlap_pct_vs_order DECIMAL(5,1) NULL, overlap_pct_vs_invoice DECIMAL(5,1) NULL, price_diff_pct DECIMAL(6,2) NULL, date_diff_days INT NULL, match_status VARCHAR(20) NULL, notes VARCHAR(255) NULL, PRIMARY KEY (report_month, order_id), KEY idx_oimr_match_status (match_status), KEY idx_oimr_order_datetime (order_datetime), KEY idx_oimr_customer_email (customer_email), KEY idx_oimr_invoice_id (invoice_id), KEY idx_oimr_invoice_branch (invoice_branch), KEY idx_oimr_order_status (order_status), KEY idx_oimr_report_month_stat (report_month, match_status) ) ENGINE"},{"table_name":"aieo_order_invoice_match_report_current_month","full_table_name":"wp_aieo_order_invoice_match_report_current_month","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"report_month","type":"CHAR(7)","nullable":true,"primary_key":false},{"name":"customer_email","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"order_datetime","type":"DATETIME","nullable":true,"primary_key":false},{"name":"woo_total","type":"DECIMAL(12,2)","nullable":true,"primary_key":false},{"name":"woo_qty_sum","type":"DECIMAL(12,3)","nullable":true,"primary_key":false},{"name":"shippingtype","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"order_status","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"invoice_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"invoice_code","type":"VARCHAR(40)","nullable":true,"primary_key":false},{"name":"invoice_branch","type":"VARCHAR(150)","nullable":true,"primary_key":false},{"name":"invoice_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"invoice_total","type":"DECIMAL(12,2)","nullable":true,"primary_key":false},{"name":"invoice_qty_sum","type":"DECIMAL(12,3)","nullable":true,"primary_key":false},{"name":"overlap_sku_count","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"overlap_pct_vs_order","type":"DECIMAL(5,1)","nullable":true,"primary_key":false},{"name":"overlap_pct_vs_invoice","type":"DECIMAL(5,1)","nullable":true,"primary_key":false},{"name":"price_diff_pct","type":"DECIMAL(6,2)","nullable":true,"primary_key":false},{"name":"date_diff_days","type":"INT","nullable":true,"primary_key":false},{"name":"match_status","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"notes","type":"VARCHAR(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aieo_order_invoice_match_report_current_month ( report_month CHAR(7) NULL, -- 'YYYY-MM' order_id BIGINT UNSIGNED NULL, customer_email VARCHAR(255) NULL, order_datetime DATETIME NULL, woo_total DECIMAL(12,2) NULL, -- full Woo total woo_net_total DECIMAL(12,2) NULL, -- products-only total (for comparisons) woo_line_items INT UNSIGNED NULL, woo_qty_sum DECIMAL(12,3) NULL, shippingtype VARCHAR(255) NULL, order_status VARCHAR(50) NULL, invoice_id BIGINT UNSIGNED NULL, invoice_code VARCHAR(40) NULL, invoice_branch VARCHAR(150) NULL, invoice_date DATETIME NULL, invoice_total DECIMAL(12,2) NULL, -- ERP product line totals invoice_line_items INT UNSIGNED NULL, invoice_qty_sum DECIMAL(12,3) NULL, overlap_sku_count INT UNSIGNED NULL, overlap_pct_vs_order DECIMAL(5,1) NULL, overlap_pct_vs_invoice DECIMAL(5,1) NULL, price_diff_pct DECIMAL(6,2) NULL, date_diff_days INT NULL, match_status VARCHAR(20) NULL, notes VARCHAR(255) NULL, PRIMARY KEY (report_month, order_id), KEY idx_oimr_match_status (match_status), KEY idx_oimr_order_datetime (order_datetime), KEY idx_oimr_customer_email (customer_email), KEY idx_oimr_invoice_id (invoice_id), KEY idx_oimr_invoice_branch (invoice_branch), KEY idx_oimr_order_status (order_status), KEY idx_oimr_report_month_stat (report_month, match_status) ) ENGINE"},{"table_name":"aieo_order_products_analytics","full_table_name":"wp_aieo_order_products_analytics","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"order_id","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"product_id","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"sku","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"quantity","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"unit_price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"order_item_id","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"order_sequence","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"order_items","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"order_item_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"order_item_parent_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"order_total","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"customer_id","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"customer_email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date_created_gmt","type":"datetime","nullable":true,"primary_key":false},{"name":"payment_method","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"user_agent","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"brand","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"category_id","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"menu_category","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"head_category","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"sub_category","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"prof_discount","type":"varchar(3)","nullable":true,"primary_key":false},{"name":"list_price","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"soft1_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"parent_product_id","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"order_item_parent_product_id","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"stock","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"variation_id","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"effective_pid","type":"decimal(12,0)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_aieo_order_products_analytics` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `order_id` decimal(12,0) DEFAULT NULL, `product_id` decimal(12,0) DEFAULT NULL, `sku` varchar(100) DEFAULT NULL, `quantity` decimal(12,0) DEFAULT NULL, `price` decimal(12,2) DEFAULT NULL, `unit_price` decimal(12,2) DEFAULT NULL, `order_item_id` decimal(12,0) DEFAULT NULL, `order_sequence` decimal(12,0) DEFAULT NULL, `order_items` decimal(12,0) DEFAULT NULL, `order_item_name` varchar(255) DEFAULT NULL, `order_item_parent_name` varchar(255) DEFAULT NULL, `order_total` decimal(12,2) DEFAULT NULL, `customer_id` decimal(12,0) DEFAULT NULL, `customer_email` varchar(255) DEFAULT NULL, `date_created_gmt` datetime DEFAULT NULL, `payment_method` varchar(255) DEFAULT NULL, `user_agent` varchar(255) DEFAULT NULL, `brand` varchar(100) DEFAULT NULL, `category_id` decimal(12,0) DEFAULT NULL, `menu_category` varchar(200) DEFAULT NULL, `head_category` varchar(200) DEFAULT NULL, `sub_category` varchar(200) DEFAULT NULL, `prof_discount` varchar(3) DEFAULT NULL, `list_price` varchar(255) DEFAULT NULL, `soft1_id` varchar(255) DEFAULT NULL, `parent_product_id` decimal(12,0) DEFAULT NULL, `order_item_parent_product_id` decimal(12,0) DEFAULT NULL, `stock` decimal(12,0) DEFAULT NULL, `variation_id` decimal(12,0) DEFAULT NULL, `effective_pid` decimal(12,0) AS (COALESCE(NULLIF(`variation_id`,0),`product_id`)) STORED, PRIMARY KEY (`id`), KEY `order_analytics_idx` (`order_id`,`product_id`,`customer_email`), KEY `idx_poda_date_created_gmt` (`date_created_gmt`), KEY `idx_opa_product_date` (`product_id`,`date_created_gmt`), KEY `idx_variation_date_created_gmt` (`variation_id`,`date_created_gmt`), KEY `idx_variation_id` (`variation_id`), KEY `idx_order_id_sequence` (`order_id`,`order_sequence`), KEY `idx_order_products_email_order` (`customer_email`,`order_id`), KEY `idx_opa_effective_pid` (`effective_pid`,`date_created_gmt`) ) ENGINE"},{"table_name":"aieo_order_stats","full_table_name":"wp_aieo_order_stats","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderid","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"customeremail","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"customerid","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"birthyear","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"birthday","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"firstname","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"lastname","type":"varchar(90)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"postcode","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"numberofitemsperorder","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"numberoforders","type":"decimal(12,0)","nullable":true,"primary_key":false},{"name":"orderspend","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"shippingcharged","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"shippingtype","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"freeshipping","type":"varchar(5)","nullable":true,"primary_key":false},{"name":"totalshipping","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"netspendonproducts","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"orderdate","type":"date","nullable":false,"primary_key":false},{"name":"orderdatetime","type":"datetime","nullable":false,"primary_key":false},{"name":"orderday","type":"decimal(2,0)","nullable":true,"primary_key":false},{"name":"orderdaymonth","type":"decimal(2,0)","nullable":true,"primary_key":false},{"name":"buyerspayrol","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"buyersday","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"buyerstime","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"buyersdevice","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"link_to_order_details","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"paymenttype","type":"varchar(80)","nullable":true,"primary_key":false},{"name":"pickuplocation","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"phoneorder","type":"varchar(5)","nullable":true,"primary_key":false},{"name":"orderstatus","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ordersource","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderutmsource","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderutmmedium","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderutmcampaign","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderutmterm","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"orderutmcontent","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"statsclientid","type":"int(10) unsigned","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_aieo_order_stats` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `orderid` decimal(12,0) DEFAULT NULL, `customeremail` varchar(255) DEFAULT NULL, `customerid` decimal(12,0) DEFAULT NULL, `birthyear` decimal(12,0) DEFAULT NULL, `birthday` varchar(50) DEFAULT NULL, `firstname` varchar(60) DEFAULT NULL, `lastname` varchar(90) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `postcode` varchar(50) DEFAULT NULL, `numberofitemsperorder` decimal(12,0) DEFAULT NULL, `numberoforders` decimal(12,0) DEFAULT NULL, `orderspend` decimal(12,2) DEFAULT NULL, `shippingcharged` decimal(12,2) DEFAULT NULL, `shippingtype` varchar(255) DEFAULT NULL, `freeshipping` varchar(5) DEFAULT NULL, `totalshipping` decimal(12,2) DEFAULT NULL, `netspendonproducts` decimal(12,2) DEFAULT NULL, `orderdate` date NOT NULL DEFAULT '0000-00-00', `orderdatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `orderday` decimal(2,0) DEFAULT NULL, `orderdaymonth` decimal(2,0) DEFAULT NULL, `buyerspayrol` varchar(20) DEFAULT NULL, `buyersday` varchar(20) DEFAULT NULL, `buyerstime` varchar(20) DEFAULT NULL, `buyersdevice` varchar(100) DEFAULT NULL, `link_to_order_details` varchar(200) DEFAULT NULL, `paymenttype` varchar(80) DEFAULT NULL, `pickuplocation` varchar(150) DEFAULT NULL, `phoneorder` varchar(5) DEFAULT NULL, `orderstatus` varchar(50) DEFAULT NULL, `ordersource` varchar(255) DEFAULT NULL, `orderutmsource` varchar(255) DEFAULT NULL, `orderutmmedium` varchar(255) DEFAULT NULL, `orderutmcampaign` varchar(255) DEFAULT NULL, `orderutmterm` varchar(255) DEFAULT NULL, `orderutmcontent` varchar(255) DEFAULT NULL, `statsclientid` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_id_idx` (`orderid`,`customeremail`), KEY `idx_customeremail` (`customeremail`) ) ENGINE"},{"table_name":"aieo_performance_tuning","full_table_name":"wp_aieo_performance_tuning","description":"Stores aieo performance tuning data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"batch_size","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"processing_time","type":"FLOAT","nullable":false,"primary_key":false},{"name":"total_processing_time","type":"FLOAT","nullable":false,"primary_key":false},{"name":"date_recorded","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_aieo_performance_tuning ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, batch_size INT(11) UNSIGNED NOT NULL, processing_time FLOAT NOT NULL, total_processing_time FLOAT NOT NULL, date_recorded TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) )\");"},{"table_name":"aieo_price_history","full_table_name":"wp_aieo_price_history","description":"Stores aieo price history data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_product_need_suggestions","full_table_name":"wp_aieo_product_need_suggestions","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_product_option_groups","full_table_name":"wp_aieo_product_option_groups","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_product_recommendations","full_table_name":"wp_aieo_product_recommendations","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_product_request_items","full_table_name":"wp_aieo_product_request_items","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_product_request_views","full_table_name":"wp_aieo_product_request_views","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_product_requests","full_table_name":"wp_aieo_product_requests","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_product_session_metrics","full_table_name":"wp_aieo_product_session_metrics","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_product_stats_temp","full_table_name":"wp_aieo_product_stats_temp","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_proposals","full_table_name":"wp_aieo_proposals","description":"Stores aieo proposals data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_push_campaigns","full_table_name":"wp_aieo_push_campaigns","description":"Stores aieo push campaigns data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_push_caps","full_table_name":"wp_aieo_push_caps","description":"Stores aieo push caps data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_push_dispatch","full_table_name":"wp_aieo_push_dispatch","description":"Stores aieo push dispatch data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_push_subscriptions","full_table_name":"wp_aieo_push_subscriptions","description":"Stores aieo push subscriptions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_push_templates","full_table_name":"wp_aieo_push_templates","description":"Stores aieo push templates data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_rating_stats","full_table_name":"wp_aieo_rating_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_ratings","full_table_name":"wp_aieo_ratings","description":"Stores aieo ratings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_reciprocal_ids","full_table_name":"wp_aieo_reciprocal_ids","description":"Stores aieo reciprocal ids data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"Id","type":"int(11)","nullable":false,"primary_key":true},{"name":"SKU","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"Soft1Ids","type":"varchar(120)","nullable":true,"primary_key":false},{"name":"EshopId","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"EshopParentId","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"ExcludeFromUpdate","type":"int(11)","nullable":true,"primary_key":false},{"name":"ContentCreated","type":"datetime","nullable":true,"primary_key":false},{"name":"ContentLastUpdated","type":"datetime","nullable":true,"primary_key":false},{"name":"update_on_next_run","type":"int(11)","nullable":true,"primary_key":false},{"name":"Soft1Id","type":"bigint(20) unsigned","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_aieo_reciprocal_ids` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `SKU` varchar(100) DEFAULT NULL, `Soft1Ids` varchar(120) DEFAULT NULL, `EshopId` bigint(20) unsigned DEFAULT NULL, `EshopParentId` bigint(20) unsigned DEFAULT NULL, `ExcludeFromUpdate` int(11) DEFAULT NULL, `ContentCreated` datetime DEFAULT current_timestamp(), `ContentLastUpdated` datetime DEFAULT current_timestamp(), `update_on_next_run` int(11) DEFAULT 0, `Soft1Id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`Id`), KEY `idx_sku` (`SKU`), KEY `idx_eshopid` (`EshopId`), KEY `idx_eshopparentid` (`EshopParentId`), KEY `idx_soft1ids` (`Soft1Ids`) ) ENGINE"},{"table_name":"aieo_reco_events","full_table_name":"wp_aieo_reco_events","description":"Stores aieo reco events data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_reco_events_archive","full_table_name":"wp_aieo_reco_events_archive","description":"Stores aieo reco events archive data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_reco_reverse_refs","full_table_name":"wp_aieo_reco_reverse_refs","description":"Stores aieo reco reverse refs data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_recommendations_cache","full_table_name":"wp_aieo_recommendations_cache","description":"A cache table that stores temporary computed or fetched data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_remote_export_state","full_table_name":"wp_aieo_remote_export_state","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"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","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}],"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"},{"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","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}],"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"},{"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","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}],"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"},{"table_name":"aieo_search_demand_daily","full_table_name":"wp_aieo_search_demand_daily","description":"Stores aieo search demand daily data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_sem_pairs","full_table_name":"wp_aieo_sem_pairs","description":"Stores aieo sem pairs data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_seo_404_log","full_table_name":"wp_aieo_seo_404_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_seo_head_cache","full_table_name":"wp_aieo_seo_head_cache","description":"A cache table that stores temporary computed or fetched data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_seo_opportunities","full_table_name":"wp_aieo_seo_opportunities","description":"Stores aieo seo opportunities data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_seo_posts","full_table_name":"wp_aieo_seo_posts","description":"Stores aieo seo posts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_seo_redirects","full_table_name":"wp_aieo_seo_redirects","description":"Stores aieo seo redirects data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_seo_scores","full_table_name":"wp_aieo_seo_scores","description":"Stores aieo seo scores data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_server_events_log","full_table_name":"wp_aieo_server_events_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_session_identity","full_table_name":"wp_aieo_session_identity","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_session_journeys","full_table_name":"wp_aieo_session_journeys","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_sessions","full_table_name":"wp_aieo_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_sessions_archive","full_table_name":"wp_aieo_sessions_archive","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_sessions_statics","full_table_name":"wp_aieo_sessions_statics","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_sessions_statics_archive","full_table_name":"wp_aieo_sessions_statics_archive","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_social_accounts","full_table_name":"wp_aieo_social_accounts","description":"Stores aieo social accounts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_social_boosts","full_table_name":"wp_aieo_social_boosts","description":"Stores aieo social boosts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_social_post_metrics","full_table_name":"wp_aieo_social_post_metrics","description":"Stores aieo social post metrics data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_social_posts","full_table_name":"wp_aieo_social_posts","description":"Stores aieo social posts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_sp_queue","full_table_name":"wp_aieo_sp_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[{"name":"product_id","type":"bigint","nullable":false,"primary_key":true},{"name":"batch_no","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_aieo_sp_queue ( product_id bigint NOT NULL PRIMARY KEY, batch_no int NOT NULL, KEY k_batch (batch_no) ) ENGINE"},{"table_name":"aieo_sp_run","full_table_name":"wp_aieo_sp_run","description":"Stores aieo sp run data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"tinyint unsigned","nullable":false,"primary_key":true},{"name":"asof","type":"date","nullable":true,"primary_key":false},{"name":"grain","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"next_batch","type":"int","nullable":true,"primary_key":false},{"name":"total_batches","type":"int","nullable":true,"primary_key":false},{"name":"total_products","type":"int","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aieo_sp_run ( id tinyint unsigned NOT NULL PRIMARY KEY, asof date DEFAULT NULL, grain varchar(16) DEFAULT 'both', next_batch int DEFAULT 0, total_batches int DEFAULT 0, total_products int DEFAULT 0, status varchar(20) DEFAULT NULL, updated_at datetime DEFAULT NULL ) ENGINE"},{"table_name":"aieo_store_only_products","full_table_name":"wp_aieo_store_only_products","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[{"name":"Id","type":"int(11)","nullable":false,"primary_key":true},{"name":"Soft1Id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"CompanyIds","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"Soft1Ids","type":"varchar(120)","nullable":true,"primary_key":false},{"name":"Soft1ProductName","type":"varchar(930)","nullable":true,"primary_key":false},{"name":"EshopParentId","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"EshopId","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"SKU","type":"varchar(230)","nullable":true,"primary_key":false},{"name":"SKU_norm","type":"varchar(120)","nullable":true,"primary_key":false},{"name":"Barcode","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"SupplierId","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"regular_price","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"sale_price","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"stock","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"customer_hairdresser_price","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"customer_makigiaz_price","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"customer_manicure_price","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"customer_beautician_price","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"ContentCreated","type":"datetime","nullable":true,"primary_key":false},{"name":"ContentLastUpdated","type":"datetime","nullable":true,"primary_key":false},{"name":"ExcludeFromUpdate","type":"int(11)","nullable":true,"primary_key":false},{"name":"ProductStatus","type":"int(11)","nullable":true,"primary_key":false},{"name":"VAT","type":"varchar(10)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_aieo_store_only_products` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Soft1Id` bigint(20) unsigned DEFAULT NULL, `CompanyIds` bigint(20) unsigned DEFAULT NULL, `Soft1Ids` varchar(120) DEFAULT NULL, `Soft1ProductName` varchar(930) DEFAULT NULL, `EshopParentId` bigint(20) unsigned DEFAULT NULL, `EshopId` bigint(20) unsigned DEFAULT NULL, `SKU` varchar(230) DEFAULT NULL, `SKU_norm` varchar(120) DEFAULT NULL, `Barcode` varchar(60) DEFAULT NULL, `SupplierId` bigint(20) unsigned DEFAULT NULL, `regular_price` varchar(10) DEFAULT NULL, `sale_price` varchar(10) DEFAULT NULL, `stock` varchar(10) DEFAULT NULL, `customer_hairdresser_price` varchar(10) DEFAULT NULL, `customer_makigiaz_price` varchar(10) DEFAULT NULL, `customer_manicure_price` varchar(10) DEFAULT NULL, `customer_beautician_price` varchar(10) DEFAULT NULL, `ContentCreated` datetime DEFAULT current_timestamp(), `ContentLastUpdated` datetime DEFAULT current_timestamp(), `ExcludeFromUpdate` int(11) DEFAULT NULL, `ProductStatus` int(11) DEFAULT NULL, `VAT` varchar(10) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `idx_soft1id` (`Soft1Id`), KEY `idx_eshopid` (`EshopId`), KEY `idx_eshopparentid` (`EshopParentId`), KEY `idx_sku` (`SKU`), KEY `idx_barcode` (`Barcode`), KEY `idx_supplierid` (`SupplierId`), KEY `idx_sku_norm` (`SKU_norm`) ) ENGINE"},{"table_name":"aieo_subject_recos","full_table_name":"wp_aieo_subject_recos","description":"Stores aieo subject recos data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_subjects","full_table_name":"wp_aieo_subjects","description":"Stores aieo subjects data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_survey_intelligence","full_table_name":"wp_aieo_survey_intelligence","description":"Stores aieo survey intelligence data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_survey_responses","full_table_name":"wp_aieo_survey_responses","description":"Stores aieo survey responses data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_temp_orders","full_table_name":"wp_aieo_temp_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_temp_product_catalogue","full_table_name":"wp_aieo_temp_product_catalogue","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_temp_store_orders","full_table_name":"wp_aieo_temp_store_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_user_vitals","full_table_name":"wp_aieo_user_vitals","description":"Stores aieo user vitals data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"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","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}],"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"},{"table_name":"aieo_vector_priors","full_table_name":"wp_aieo_vector_priors","description":"Stores aieo vector priors data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_waitlist","full_table_name":"wp_aieo_waitlist","description":"Stores aieo waitlist data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_wishlist","full_table_name":"wp_aieo_wishlist","description":"Stores aieo wishlist data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_workflow_runs","full_table_name":"wp_aieo_workflow_runs","description":"Stores aieo workflow runs data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_workflow_stats","full_table_name":"wp_aieo_workflow_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_workflows","full_table_name":"wp_aieo_workflows","description":"Stores aieo workflows data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"automatewoo_customers","full_table_name":"wp_automatewoo_customers","description":"Stores automatewoo customers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"automatewoo_guests","full_table_name":"wp_automatewoo_guests","description":"Stores automatewoo guests data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"dgwt_wcas_stats","full_table_name":"wp_dgwt_wcas_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"om_no_free_shipping","full_table_name":"wp_om_no_free_shipping","description":"Stores om no free shipping data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"om_ppe_waitlist","full_table_name":"wp_om_ppe_waitlist","description":"Stores om ppe waitlist data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"om_ppe_wishlist","full_table_name":"wp_om_ppe_wishlist","description":"Stores om ppe wishlist data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"om_role_based_pricing","full_table_name":"wp_om_role_based_pricing","description":"Stores om role based pricing data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"pods_product_need","full_table_name":"wp_pods_product_need","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"store_board_","full_table_name":"wp_store_board_","description":"Stores store board  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"store_order_status_lookup","full_table_name":"wp_store_order_status_lookup","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_order_coupon_lookup","full_table_name":"wp_wc_order_coupon_lookup","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_order_operational_data","full_table_name":"wp_wc_order_operational_data","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_order_product_lookup","full_table_name":"wp_wc_order_product_lookup","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_order_stats","full_table_name":"wp_wc_order_stats","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_orders","full_table_name":"wp_wc_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_orders_meta","full_table_name":"wp_wc_orders_meta","description":"Stores additional metadata (key-value pairs) for wc orders records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_product_meta_lookup","full_table_name":"wp_wc_product_meta_lookup","description":"Stores additional metadata (key-value pairs) for wc product meta lookup records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"woocommerce_order_itemmeta","full_table_name":"wp_woocommerce_order_itemmeta","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"woocommerce_order_items","full_table_name":"wp_woocommerce_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"woocommerce_shipping_table_rates","full_table_name":"wp_woocommerce_shipping_table_rates","description":"Stores woocommerce shipping table rates data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":224}