zkxw/docs/sql/sample_reception_add_lab_storage_code.sql

-- 样本接收 — 实验室入库编码
ALTER TABLE biz_sample_reception
  ADD COLUMN lab_storage_code VARCHAR(32) NULL
    COMMENT '实验室入库编码 RK+接收日期YYYYMMDD+3位序号'
    AFTER sample_code;

CREATE UNIQUE INDEX uk_sr_tenant_lab_code
  ON biz_sample_reception (tenant_no, lab_storage_code, del_flag);