{"slug":"ai-eshop-optimizer","name":"AI eShop Optimizer","description":"AI suite for WooCommerce & WordPress: chat, recommendations, SEO, attribution, merchandising, fulfilment. Anthropic & Voyage AI.","author":"Oxford Metadata Ltd","active_installs":10,"version":"8.3","wp_org_url":"https://wordpress.org/plugins/ai-eshop-optimizer/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"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":"medium","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_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_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_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_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_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_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(AVG(ws2.orderspend),2) as TotalAverageOrder, Round(AVG(ws1.orderspend)/(ws1.numberofitemsperorder),2) as AveSpendOfUserPerItemPerOrder, ws1.numberoforders as TotalNumberofOrders, Round(AVG(ws2.numberofitemsperorder),2) as AveItemsOfUserPerOrder, Round(STD(ws2.numberofitemsperorder),2) as STDItemsOfUser, Round( STD(ws2.numberofitemsperorder) /MIN(ws2.numberofitemsperorder) ,2) as STDPerMinItemsOfUser, Round( STD(ws2.numberofitemsperorder) /AVG(ws2.numberofitemsperorder) ,2) as STDPerAverageItemsOfUser, Round( STD(ws2.numberofitemsperorder) /MAX(ws2.numberofitemsperorder) ,2) as STDPerMaxItemsOfUser, Round(AVG(ws2.orderspend),2) as AveSpendOfUserPerOrder, Round(STD(ws2.orderspend),2) as STDSpendOfUser, Round( STD(ws2.orderspend) /MIN(ws2.orderspend) ,2) as STDPerMinSpendOfUser, Round( STD(ws2.orderspend) /AVG(ws2.orderspend) ,2) as STDPerAverageSpendOfUser, Round( STD(ws2.orderspend) /MAX(ws2.orderspend) ,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 wp_aieo_order_stats ws2 on ws1.customeremail = ws2.customeremail Group by ws1.customeremail, ws1.orderid, ws1.numberofitemsperorder, ws1.numberoforders, ws1.orderspend,ws1.buyerspayrol, ws1.buyersday, ws1.buyerstime, ws1.link_to_order_details Order by ws1.customeremail; 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_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_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_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_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_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_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_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_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_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_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_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_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_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_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":"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, `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_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}],"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, 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`) ) 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_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_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_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":"medium","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_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_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_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_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_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":"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_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_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":"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":147}