{"table_name":"analytics_conversion","full_table_name":"wp_analytics_conversion","description":"Stores analytics conversion data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_analytics_conversion` ( `id` int(10) UNSIGNED AUTO_INCREMENT UNIQUE KEY NOT NULL, `uuid` char(36) NOT NULL, `flow_uuid` char(36) NOT NULL, `order_id` varchar(255) DEFAULT NULL, `extension` varchar(255) NOT NULL, `revenue_total` INT(10) UNSIGNED NOT NULL, `revenue_subtotal` INT(10) UNSIGNED NOT NULL, `revenue_tax` INT(10) UNSIGNED NOT NULL, `revenue_discount` INT(10) UNSIGNED NOT NULL, `revenue_shipping` INT(10) UNSIGNED NOT NULL, `conversion_type` varchar(255) NOT NULL, UNIQUE KEY `idx_unique` (`extension`, `conversion_type`, `uuid`, `order_id`), UNIQUE KEY `uuid` (`uuid`) ) ENGINE","columns":[{"name":"id","type":"int(10) UNSIGNED","nullable":false,"primary_key":true},{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"flow_uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"order_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"extension","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"revenue_total","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"revenue_subtotal","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"revenue_tax","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"revenue_discount","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"revenue_shipping","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"conversion_type","type":"varchar(255)","nullable":false,"primary_key":false}],"plugin":{"slug":"aesirx-analytics","name":"AesirX Analytics","active_installs":100,"version":"5.0.1","wp_org_url":"https://wordpress.org/plugins/aesirx-analytics/"}}