wp_aieo_order_products_analytics
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| name | varchar(255) | YES |
| order_id | decimal(12,0) | YES |
| product_id | decimal(12,0) | YES |
| sku | varchar(100) | YES |
| quantity | decimal(12,0) | YES |
| price | decimal(12,2) | YES |
| unit_price | decimal(12,2) | YES |
| order_item_id | decimal(12,0) | YES |
| order_sequence | decimal(12,0) | YES |
| order_items | decimal(12,0) | YES |
| order_item_name | varchar(255) | YES |
| order_item_parent_name | varchar(255) | YES |
| order_total | decimal(12,2) | YES |
| customer_id | decimal(12,0) | YES |
| customer_email | varchar(255) | YES |
| date_created_gmt | datetime | YES |
| payment_method | varchar(255) | YES |
| user_agent | varchar(255) | YES |
| brand | varchar(100) | YES |
| category_id | decimal(12,0) | YES |
| menu_category | varchar(200) | YES |
| head_category | varchar(200) | YES |
| sub_category | varchar(200) | YES |
| prof_discount | varchar(3) | YES |
| list_price | varchar(255) | YES |
| soft1_id | varchar(255) | YES |
| parent_product_id | decimal(12,0) | YES |
| order_item_parent_product_id | decimal(12,0) | YES |
| stock | decimal(12,0) | YES |
| variation_id | decimal(12,0) | YES |
CREATE TABLE Statement
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
Safe to delete?
If you have uninstalled AI eShop Optimizer, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_aieo_order_products_analytics`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AI eShop Optimizer