{"table_name":"dokan_order_stats","full_table_name":"wp_dokan_order_stats","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS `wp_dokan_order_stats` ( `order_id` bigint UNSIGNED NOT NULL, `vendor_id` bigint UNSIGNED NOT NULL DEFAULT '0', `order_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 = Dokan Parent Order, 1 = Dokan Single Vendor Order, 2 = Dokan Suborder, 3 = Refund of Dokan Parent Order, 4 = Refund of Dokan Suborder, 5 = Refund of Dokan Single Order', `vendor_earning` double NOT NULL DEFAULT '0', `vendor_gateway_fee` double NOT NULL DEFAULT '0', `vendor_shipping_fee` double NOT NULL DEFAULT '0', `vendor_discount` double NOT NULL DEFAULT '0', `admin_commission` double NOT NULL DEFAULT '0', `admin_gateway_fee` double NOT NULL DEFAULT '0', `admin_shipping_fee` double NOT NULL DEFAULT '0', `admin_discount` double NOT NULL DEFAULT '0', `admin_subsidy` double NOT NULL DEFAULT '0', PRIMARY KEY (order_id), KEY vendor_id (vendor_id), KEY order_type (order_type) ) ENGINE","columns":[{"name":"order_id","type":"bigint UNSIGNED","nullable":false,"primary_key":false},{"name":"vendor_id","type":"bigint UNSIGNED","nullable":false,"primary_key":false},{"name":"order_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"vendor_earning","type":"double","nullable":false,"primary_key":false},{"name":"vendor_gateway_fee","type":"double","nullable":false,"primary_key":false},{"name":"vendor_shipping_fee","type":"double","nullable":false,"primary_key":false},{"name":"vendor_discount","type":"double","nullable":false,"primary_key":false},{"name":"admin_commission","type":"double","nullable":false,"primary_key":false},{"name":"admin_gateway_fee","type":"double","nullable":false,"primary_key":false},{"name":"admin_shipping_fee","type":"double","nullable":false,"primary_key":false},{"name":"admin_discount","type":"double","nullable":false,"primary_key":false},{"name":"admin_subsidy","type":"double","nullable":false,"primary_key":false}],"plugin":{"slug":"dokan-lite","name":"Dokan: AI Powered WooCommerce Multivendor Marketplace Solution – Build Your Own Amazon, eBay, Etsy","active_installs":40000,"version":"4.3.3","wp_org_url":"https://wordpress.org/plugins/dokan-lite/"}}