-- 已发布原生表单新增持久字段须显式迁移；不创建原生业务主子表、不插入业务记录。
ALTER TABLE dms_wenjian_bupingheng_dengji ADD COLUMN IF NOT EXISTS chongda_fasong_id varchar(64);
ALTER TABLE dms_wenjian_bupingheng_dengji ADD COLUMN IF NOT EXISTS zhixing_ren_id varchar(64);
COMMENT ON COLUMN dms_wenjian_bupingheng_dengji.chongda_fasong_id IS '重打发送关联H';
COMMENT ON COLUMN dms_wenjian_bupingheng_dengji.zhixing_ren_id IS '措施执行人';
-- 包括软删除记录：同一成功事件不得再次生成原生登记。
CREATE UNIQUE INDEX IF NOT EXISTS uq_dms_bupingheng_chongda ON dms_wenjian_bupingheng_dengji(f_tenant_id,chongda_fasong_id)
WHERE chongda_fasong_id IS NOT NULL AND chongda_fasong_id <> '';

CREATE TABLE IF NOT EXISTS dms_wenjian_chongda_fasong (
 f_id varchar(64) NOT NULL,
 f_tenant_id varchar(64) NOT NULL,
 dayin_jilu_id varchar(64) NOT NULL,
 dayin_renwu_id varchar(64) NOT NULL,
 wenjian_banben_id varchar(64) NOT NULL,
 fasong_ren_id varchar(64) NOT NULL,
 dayin_fenshu integer NOT NULL CHECK (dayin_fenshu=1),
 fasong_zhuangtai varchar(16) NOT NULL CHECK (fasong_zhuangtai IN ('OPEN','CONFIRMED','CLOSED','CANCELLED')),
 pici_neirong text NOT NULL DEFAULT '[]',
 haoma_neirong text NOT NULL,
 yuanyin varchar(255) NOT NULL CHECK (length(btrim(yuanyin))>0),
 biz_sign varchar(64) NOT NULL,
 chuangjian_shijian timestamp NOT NULL,
 fasong_chenggong_shijian timestamp,
 dengji_id varchar(64),
 zong_yeshu integer CHECK (zong_yeshu BETWEEN 1 AND 10000),
 quxiao_shijian timestamp,
 PRIMARY KEY (f_tenant_id,f_id),
 UNIQUE (f_tenant_id,biz_sign),
 CHECK (fasong_zhuangtai IN ('OPEN','CANCELLED') OR fasong_chenggong_shijian IS NOT NULL),
 CHECK ((fasong_zhuangtai='CANCELLED') = (quxiao_shijian IS NOT NULL)),
 CHECK (fasong_zhuangtai<>'CLOSED' OR dengji_id IS NOT NULL)
);
COMMENT ON TABLE dms_wenjian_chongda_fasong IS '原流水重打发送状态；仅技术凭据，原生表单负责不平衡主子表';
CREATE UNIQUE INDEX IF NOT EXISTS uq_dms_chongda_active ON dms_wenjian_chongda_fasong(f_tenant_id,dayin_jilu_id)
WHERE fasong_zhuangtai IN ('OPEN','CONFIRMED');
CREATE INDEX IF NOT EXISTS ix_dms_chongda_record ON dms_wenjian_chongda_fasong(f_tenant_id,dayin_jilu_id,fasong_zhuangtai);