-- 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;
|
