{"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, 6 = Advertisement Product Order, 7 = Advertisement Refund Order, 8 = Vendor Subscription Order, 9 = Vendor Subscription Refund 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', `vendor_shipping_tax` double NOT NULL DEFAULT '0', `vendor_order_tax` double NOT NULL DEFAULT '0', `admin_earning` 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_shipping_tax` double NOT NULL DEFAULT '0', `admin_order_tax` 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":"vendor_shipping_tax","type":"double","nullable":false,"primary_key":false},{"name":"vendor_order_tax","type":"double","nullable":false,"primary_key":false},{"name":"admin_earning","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_shipping_tax","type":"double","nullable":false,"primary_key":false},{"name":"admin_order_tax","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":"5.0.3","wp_org_url":"https://wordpress.org/plugins/dokan-lite/"}}