-- Existing bound native forms are not auto-altered by VisualdevController.publish.
-- Apply only after separately approving the schema and configuration package.
BEGIN;
ALTER TABLE dms_wenjian_xiuding_shenqing_zixiang ADD COLUMN kanwu_tixing text;
COMMENT ON COLUMN dms_wenjian_xiuding_shenqing_zixiang.kanwu_tixing IS '已批准勘误提醒';
CREATE TABLE dms_wenjian_xiuding_shenhe_kanwu (
  f_id varchar(50) NOT NULL,
  f_foreign_id varchar(50),
  f_tenant_id varchar(50) NOT NULL,
  f_delete_mark int4,
  f_delete_time timestamp,
  f_delete_user_id varchar(50),
  kanwu_zixiang_id varchar(50),
  kanwu_shenqing_id varchar(50),
  wenjian_id varchar(50),
  banben_id varchar(50),
  wenjian_bianhao text,
  wenjian_mingcheng text,
  banbenhao text,
  kanwu_weizhi text,
  kanwu_neirong text,
  xiugai_jianyi text,
  kanwu_yuanyin text,
  fujian text,
  shifou_yichuli varchar(50),
  chuli_jielun varchar(50),
  chuli_yuanyin text,
  chuli_ren_id varchar(50),
  chuli_shijian timestamp,
  PRIMARY KEY (f_id, f_tenant_id)
);
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.f_id IS '主键';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.f_foreign_id IS '外键';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.f_tenant_id IS '租户id';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.f_delete_mark IS '删除标志';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.f_delete_time IS '删除时间';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.f_delete_user_id IS '删除用户';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.kanwu_zixiang_id IS '勘误子项IDH';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.kanwu_shenqing_id IS '勘误申请IDH';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.wenjian_id IS '文件IDH';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.banben_id IS '来源版本IDH';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.wenjian_bianhao IS '文件编号';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.wenjian_mingcheng IS '文件名称';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.banbenhao IS '勘误版本';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.kanwu_weizhi IS '勘误位置';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.kanwu_neirong IS '勘误内容';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.xiugai_jianyi IS '修改建议';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.kanwu_yuanyin IS '勘误原因';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.fujian IS '勘误附件';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.shifou_yichuli IS '台账是否已处理';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.chuli_jielun IS '处理结论';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.chuli_yuanyin IS '处理原因';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.chuli_ren_id IS '处理人';
COMMENT ON COLUMN dms_wenjian_xiuding_shenhe_kanwu.chuli_shijian IS '处理时间';
CREATE INDEX idx_dms_xiuding_kanwu_parent ON dms_wenjian_xiuding_shenhe_kanwu (f_tenant_id, f_foreign_id);
COMMIT;