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

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

CREATE TABLE `kku_mex_match_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '撮合日志ID，主键',
  `match_type` enum('USER_BUY','USER_SELL') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '撮合类型：USER_BUY用户买入撮合，USER_SELL用户卖出撮合',
  `item_id` int(11) NOT NULL COMMENT '商品ID，关联物品表',
  `batch_size` int(11) NOT NULL DEFAULT '100' COMMENT '批处理大小',
  `matched_orders` int(11) NOT NULL DEFAULT '0' COMMENT '成功撮合的订单数',
  `total_amount` decimal(20,5) NOT NULL DEFAULT '0.00000' COMMENT '撮合总金额',
  `success` tinyint(1) NOT NULL DEFAULT '0' COMMENT '撮合是否成功：0失败，1成功',
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '撮合结果消息',
  `execution_time_ms` int(11) DEFAULT NULL COMMENT '执行时间（毫秒）',
  `error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '错误消息（失败时记录）',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '撮合时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_match_type` (`match_type`) USING BTREE,
  KEY `idx_item_id` (`item_id`) USING BTREE,
  KEY `idx_created_at` (`created_at`) USING BTREE,
  KEY `idx_success` (`success`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='农贸市场撮合日志表';