{"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","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","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}],"plugin":{"slug":"ai-eshop-optimizer","name":"AI eShop Optimizer","active_installs":10,"version":"8.3","wp_org_url":"https://wordpress.org/plugins/ai-eshop-optimizer/"}}