buff2.0/backend-client/migrations/20260228_buff_selection_request_log.sql

-- BUFF 选品日志表：记录第二步对每个饰品的判断过程，用于前端展示「正在逐个判断」的感知
-- 逻辑说明见 docs/buff_selection_step2_logic.md

SET NAMES utf8mb4;

-- ----------------------------
-- 选品请求单-选品日志表：每条记录为对某一个饰品的判断结果
-- ----------------------------
DROP TABLE IF EXISTS `buff_selection_request_log`;
CREATE TABLE `buff_selection_request_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `request_id` bigint(20) unsigned NOT NULL COMMENT '选品请求单ID，关联 buff_selection_request.id',
  `user_id` int(10) unsigned NOT NULL COMMENT '用户ID，与请求单一致，便于按用户隔离查询',
  `goods_id` varchar(64) NOT NULL COMMENT 'BUFF饰品ID',
  `goods_name` varchar(256) DEFAULT NULL COMMENT '饰品名称，便于日志展示',
  `sequence_no` int(11) NOT NULL DEFAULT '0' COMMENT '判断序号：本次选品中第几个被判断的饰品（从 1 递增）',
  `result` varchar(20) NOT NULL COMMENT '判断结果：selected-已入选, not_selected-未入选',
  `message` varchar(256) DEFAULT NULL COMMENT '简短说明，如：无满足利润的磨损区间、已入选 等，可为空',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '判断时间',
  PRIMARY KEY (`id`),
  KEY `idx_request_id` (`request_id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_request_sequence` (`request_id`,`sequence_no`),
  KEY `idx_request_created` (`request_id`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='BUFF选品请求单-选品日志表（第二步逐条判断记录）';