zkxw/docs/sql/migrations/2026-10-22-sample-code-correction-log.sql

-- 样本编码全链路纠错审计日志（2026-10-22）
-- 对齐 docs/superpowers/specs/2026-10-22-sample-code-correction-design.md

CREATE TABLE IF NOT EXISTS biz_sample_code_correction_log (
  id VARCHAR(64) NOT NULL COMMENT '主键ID',
  reception_source VARCHAR(32) NOT NULL COMMENT '来源 cell_storage/research_donation',
  old_sample_code VARCHAR(32) NOT NULL COMMENT '旧样本编码',
  new_sample_code VARCHAR(32) NOT NULL COMMENT '新样本编码',
  impact_json TEXT COMMENT '各表影响行数 JSON',
  reason VARCHAR(512) DEFAULT NULL COMMENT '更正原因',
  tenant_no VARCHAR(64) NOT NULL DEFAULT 'zkxw' COMMENT '租户编号',
  order_num INT DEFAULT NULL COMMENT '排序号',
  remark VARCHAR(512) DEFAULT NULL COMMENT '备注',
  create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人id',
  create_dept_id VARCHAR(64) NOT NULL DEFAULT '' COMMENT '创建人部门ID',
  create_time DATETIME NOT NULL COMMENT '创建时间',
  update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人id',
  update_time DATETIME NOT NULL COMMENT '更新时间',
  del_flag SMALLINT NOT NULL DEFAULT 0 COMMENT '删除标记',
  PRIMARY KEY (id),
  KEY idx_scc_tenant_time (tenant_no, create_time),
  KEY idx_scc_tenant_old (tenant_no, old_sample_code, del_flag),
  KEY idx_scc_tenant_new (tenant_no, new_sample_code, del_flag)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='样本编码纠错审计日志';