{"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","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","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}],"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/"}}