AiDOPWarehouse/doc/migrations/2026-04-18_s8_verification_fields.sql

-- 2026-04-18: S8 复检闭环 - 新增检验相关字段
ALTER TABLE ado_s8_exception
    ADD COLUMN IF NOT EXISTS verifier_id             BIGINT       NULL,
    ADD COLUMN IF NOT EXISTS verification_assigned_at TIMESTAMPTZ  NULL,
    ADD COLUMN IF NOT EXISTS verified_at             TIMESTAMPTZ  NULL,
    ADD COLUMN IF NOT EXISTS verification_result     VARCHAR(32)  NULL,
    ADD COLUMN IF NOT EXISTS verification_remark     VARCHAR(2000) NULL;

COMMENT ON COLUMN ado_s8_exception.verifier_id             IS '检验人ID（处理人提交复检时手选）';
COMMENT ON COLUMN ado_s8_exception.verification_assigned_at IS '提交复检时间';
COMMENT ON COLUMN ado_s8_exception.verified_at             IS '检验完成时间';
COMMENT ON COLUMN ado_s8_exception.verification_result     IS 'APPROVED / REJECTED';
COMMENT ON COLUMN ado_s8_exception.verification_remark     IS '检验意见';