kknongchang_2506/app/Module/Mex/Databases/GenerateSql/mex_orders.sql

-- ******************************************************************
-- 表 kku_mex_orders 的创建SQL
-- 对应的Model: App\Module\Mex\Models\MexOrder
-- 警告: 此文件由系统自动生成，禁止修改！
-- ******************************************************************

CREATE TABLE `kku_mex_orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '订单ID，主键',
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `item_id` int NOT NULL COMMENT '商品ID，关联物品表',
  `currency_type` int NOT NULL DEFAULT '2' COMMENT '币种类型，关联FUND_CURRENCY_TYPE枚举，默认2为钻石',
  `order_type` enum('BUY','SELL') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单类型：BUY买入，SELL卖出',
  `quantity` int NOT NULL COMMENT '订单数量',
  `price` decimal(15,5) NOT NULL COMMENT '订单价格，支持5位小数',
  `total_amount` decimal(20,5) NOT NULL COMMENT '订单总金额',
  `status` enum('PENDING','COMPLETED','CANCELLED','FAILED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING' COMMENT '订单状态：PENDING等待，COMPLETED完成，CANCELLED取消，FAILED失败',
  `frozen_amount` decimal(20,5) DEFAULT '0.00000' COMMENT '冻结金额（买单使用）',
  `completed_quantity` int DEFAULT '0' COMMENT '已成交数量',
  `completed_amount` decimal(20,5) DEFAULT '0.00000' COMMENT '已成交金额',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `completed_at` timestamp NULL DEFAULT NULL COMMENT '完成时间',
  `failed_reason` text COLLATE utf8mb4_unicode_ci COMMENT '失败原因',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_user_id` (`user_id`) USING BTREE,
  KEY `idx_item_id` (`item_id`) USING BTREE,
  KEY `idx_order_type` (`order_type`) USING BTREE,
  KEY `idx_status` (`status`) USING BTREE,
  KEY `idx_created_at` (`created_at`) USING BTREE,
  KEY `idx_status_price_created` (`status`,`price`,`created_at`) USING BTREE COMMENT '撮合排序复合索引',
  KEY `idx_currency_type` (`currency_type`) USING BTREE COMMENT '币种类型索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='农贸市场订单表';