--sg_jg_dsfsgxmxx ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN xmmc DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN jsdwfzr DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN jsdwfzrlxdh DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN sgdwfzr DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN sgdwfzrlxdh DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN tbsj DROP NOT NULL; --ql_js_ql ALTER TABLE public.ql_js_ql ALTER COLUMN qlmc DROP NOT NULL; ALTER TABLE public.ql_js_ql ALTER COLUMN jcbg DROP NOT NULL; ALTER TABLE public.ql_js_ql ALTER COLUMN yskzjbz DROP NOT NULL; -- ALTER TABLE public.ql_js_ql ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.ql_js_ql ALTER COLUMN tbsj DROP NOT NULL; --dl_js_csdl ALTER TABLE public.dl_js_csdl ALTER COLUMN xzqhdm DROP NOT NULL; ALTER TABLE public.dl_js_csdl ALTER COLUMN dlmc DROP NOT NULL; -- ALTER TABLE public.dl_js_csdl ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.dl_js_csdl ALTER COLUMN tbsj DROP NOT NULL; ALTER TABLE public.dl_js_csdl ALTER COLUMN yskzjbz DROP NOT NULL; ALTER TABLE public.dl_js_csdl ALTER COLUMN kjxx DROP NOT NULL; --ps_js_xxtd ALTER TABLE public.ps_js_xxtd ALTER COLUMN xzqhdm DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN xxtdbm DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN tbdw DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN tbrq DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN yskzjbz DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN tbsj DROP NOT NULL; --ps_js_psh ALTER TABLE public.ps_js_psh ALTER COLUMN xzqhdm DROP NOT NULL; ALTER TABLE public.ps_js_psh ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.ps_js_psh ALTER COLUMN tbsj DROP NOT NULL; --ps_js_zyhd ALTER TABLE public.ps_js_zyhd ALTER COLUMN hlmc DROP NOT NULL; ALTER TABLE public.ps_js_zyhd ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.ps_js_zyhd ALTER COLUMN tbsj DROP NOT NULL; --gs_jg_ljgwgzlsqk ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN xzqhdm DROP NOT NULL; ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN dnjhgzljgwzc DROP NOT NULL; ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN ljgwygzcd DROP NOT NULL; ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN ljgwgzzcd DROP NOT NULL; ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN ljgwwgzcd DROP NOT NULL; -- ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN yskzjbz DROP NOT NULL; -- ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN sjtbzt DROP NOT NULL; -- ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN tbsj DROP NOT NULL; --rq_js_rqyh ALTER TABLE public.rq_js_rqyh ALTER COLUMN xzqhdm DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN yhlx DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN yhxx DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN xxdz DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN sfzdyqcs DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN bjq DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN sfyqdzz DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN yskzjbz DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN tbsj DROP NOT NULL; --industry_supervision_scheme -- alter table public.industry_supervision_scheme add column yabzdw varchar(500); -- alter table public.industry_supervision_scheme add column type varchar(500); -- alter table public.industry_supervision_scheme add column keyword varchar(255); -- alter table public.industry_supervision_scheme add column syfw text; -- alter table public.industry_supervision_scheme add column yazlc varchar(500); -- alter table public.industry_supervision_scheme add column yanr text; --linkage_coordinate -- alter table public.linkage_coordinate add column remark varchar(500); -- alter table public.linkage_coordinate add column event_id varchar(64); --work_order_admin -- alter table public.work_order_admin add column send_scene varchar(64); -- alter table public.work_order_admin add column complete_attachments varchar(600); -- alter table public.work_order_admin add column disposal_dept varchar(255); -- alter table public.work_order_admin add column disposal_dept_id varchar(64); -- alter table public.work_order_admin add column yjyabh varchar(255); --zhjg_analysis_emergency -- alter table public.zhjg_analysis_emergency add column emergency_code varchar(100); --zhjg_analysis_facility -- alter table public.zhjg_analysis_facility add column big_category varchar(64); -- alter table public.zhjg_analysis_facility add column small_category varchar(64); -- --联动协调下发表 DROP TABLE IF EXISTS public.linkage_coordinate_send; CREATE TABLE public.linkage_coordinate_send ( id varchar(64) NOT NULL, scene varchar(16), coordinate_id varchar(64), event_number varchar(64), event_sub_number varchar(64), handler varchar(64), complete_attachments varchar(600), disposal_dept varchar(255), feedback varchar(500), process_time timestamp(6), state varchar(16), yjyabh varchar(255), bz varchar(500), deleted int4, created_at timestamp(6), created_by varchar(100), updated_at timestamp(6), updated_by varchar(100), PRIMARY KEY (id) ); COMMENT ON COLUMN public.linkage_coordinate_send.scene IS '所属专项'; COMMENT ON COLUMN public.linkage_coordinate_send.coordinate_id IS '联动协调id'; COMMENT ON COLUMN public.linkage_coordinate_send.event_number IS '事件编号'; COMMENT ON COLUMN public.linkage_coordinate_send.event_sub_number IS '关联子事件编号'; COMMENT ON COLUMN public.linkage_coordinate_send.handler IS '处理人'; COMMENT ON COLUMN public.linkage_coordinate_send.complete_attachments IS '处理后的图片'; COMMENT ON COLUMN public.linkage_coordinate_send.disposal_dept IS '处理部门'; COMMENT ON COLUMN public.linkage_coordinate_send.feedback IS '处理结果说明'; COMMENT ON COLUMN public.linkage_coordinate_send.process_time IS '处理时间'; COMMENT ON COLUMN public.linkage_coordinate_send.state IS '当前处理状态'; COMMENT ON COLUMN public.linkage_coordinate_send.yjyabh IS '关联应急预案编号'; COMMENT ON COLUMN public.linkage_coordinate_send.bz IS '备注'; COMMENT ON TABLE public.linkage_coordinate_send IS '联动协调下发表'; --基础设施大类小类字典表 -- CREATE TABLE public.local_dict_jcss ( -- id varchar(64) NOT NULL, -- scene varchar(64), -- big_category varchar(64), -- small_category varchar(64), -- code varchar(64), -- type varchar(64), -- description varchar(64), -- sort int4, -- bz varchar(500), -- deleted int4, -- created_at timestamp(6), -- created_by varchar(100), -- updated_at timestamp(6), -- updated_by varchar(100), -- PRIMARY KEY (id) -- ); -- COMMENT ON TABLE public.local_dict_jcss IS '业务字典-基础设施'; -- INSERT INTO "public"."local_dict_jcss" VALUES ('4e8882e7-7aee-42af-8668-b3e987b27b19', '0', '管道气', '', '0', '1', '', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('e004f26e-27eb-41fd-af08-00f1058cf255', '0', '瓶装液化气', '', '1', '1', '', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('5414043d-3fa4-4642-a1b0-59adc36c33ce', '2', '供水厂站', '', '0', '1', '', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('ac3f96e5-9496-4ee7-99aa-14028e6cc734', '2', '供水管网', '', '1', '1', '', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('d4451e0e-1077-4e60-9ed9-f6c4f583b41c', '0', '管道气', '天然气场站', '0', '2', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('e84c2a02-423a-4497-a677-967578f7392a', '0', '管道气', '天然气管道', '1', '2', '长度,单位公里', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('f47fe844-c029-4945-b853-cdf11e77e57d', '0', '管道气', '管道阀门井', '2', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('ce00c0a4-5bd0-4420-8860-f331ce58b48b', '0', '瓶装液化气', '储配站充装台', '0', '2', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('734fc4c0-da8c-40dc-8fe7-9e713dca9d6b', '0', '瓶装液化气', '液化气站点', '2', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('a514fcfe-c568-434e-addd-7520c5c9fd00', '1', '雨水', '雨水管网', '0', '2', '长度,单位公里', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('3997a993-4d48-4e3f-898b-937e54890d04', '1', '雨水', '主要河道', '1', '2', '长度,单位公里', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('53697bce-962d-43ac-9f69-a3246fd651f9', '1', '雨水', '行泄通道', '2', '2', '长度,单位公里', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('20738491-5879-4893-bfe2-1c2f452bee5d', '1', '雨水', '调蓄设施', '3', '2', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('334f0110-4ba9-4309-a46b-09dfbfe15f5d', '1', '雨水', '雨水泵站', '4', '2', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('333ca80a-dbff-45c1-b4d2-0990c617f3b3', '1', '雨水', '管点', '5', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('8abc730a-c56a-403b-b826-345ebc31fcb7', '1', '雨水', '排口', '6', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('80588ffb-9df0-42e7-b962-aeaeadaee76f', '1', '污水', '污水管网', '0', '2', '长度,单位公里', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('14b509d1-be97-4fec-b4ee-e9db7bbd3318', '1', '污水', '污水泵站', '1', '2', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('effb95a8-2c24-49a6-ade6-48b568c34487', '1', '污水', '污水处理厂', '2', '2', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('8c576682-62d7-4e4e-8a1e-254e4a06fd78', '1', '污水', '重点排水户', '3', '2', '数量,单位家', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('c8d13b51-5738-4e7e-8f7e-845596dce774', '1', '污水', '管点', '4', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('df54fb60-8cc0-4dd2-bb82-c39aa91f0bec', '1', '污水', '排口', '5', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('56ff9fa4-95c6-4a71-86ef-d7dd7e9697e3', '1', '合流', '排口', '0', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('347cc817-f4b5-448f-ab2e-a9392b31f361', '1', '合流', '截流设施', '1', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('4f8d65b0-3281-4e4b-8c25-a5e755de6581', '2', '供水管网', '核心管网', '0', '2', '数量,单位公里', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('383f9f4e-07ff-4471-8851-ff021db48ccd', '2', '供水管网', '老旧管网', '1', '2', '数量,单位公里', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('c6d5ffc1-0988-4381-bf73-80f86c3d4519', '2', '供水管网', '管点', '2', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('36a83351-24d9-4519-bc91-118b6e23c5d1', '3', '施工项目', '房屋建筑工程', '1', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('7f6d13a3-fc3b-4a07-822a-1bd0973afb4f', '6', '市管道路', '', '1', '1', '数量,单位公里', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('b4bc3122-b140-4c38-880b-e97e14e49190', '6', '区管道路', '', '2', '1', '数量,单位公里', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('6a650022-079f-4a12-84ef-8cba9ad6106d', '6', '次干路', '', '2', '1', '数量,单位公里', NULL, NULL, 0, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('df017cd5-1cc0-4697-85fb-6ed8e99b167a', '6', '支路', '', '3', '1', '数量,单位公里', NULL, NULL, 0, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('36a83351-21d9-4519-bc91-118b6e23c5d1', '3', '施工项目', '城市基础设施工程-供水', '4', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('36a83351-24d9-4519-bc91-118b6e11c5d1', '3', '施工项目', '城市基础设施工程-排水', '5', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('36a84651-24d9-4519-bc91-118b6e95c5d4', '3', '施工项目', '', '0', '1', '', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('494eacf6-7f0e-42e7-bcf4-2b655a9a8254', '2', '供水厂站', '原水厂', '1', '2', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('e34a063a-c874-4e00-bf6f-2286e4497d31', '2', '供水厂站', '自来水厂', '2', '2', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('36a83351-2111-4519-bc91-118b6e23c5d1', '3', '施工项目', '城市园林绿化工程', '6', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('cd1a3775-3306-4d5b-91c8-67d3b9913f4a', '2', '供水厂站', '增压站', '3', '2', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('be69bed4-bee8-4b7c-a7a1-522f9cc723f9', '2', '供水厂站', '二次供水泵房', '4', '2', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('36a83351-24d9-4519-bc91-118b6e23c5d2', '3', '施工项目', '城市基础设施工程-道路桥梁', '2', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('36a84451-24d9-4519-bc91-118b6e23c5d1', '3', '施工项目', '城市基础设施工程-燃气', '3', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('36a83351-24d9-4519-bc22-118b6e23c5d1', '3', '施工项目', '交通基础设施工程', '7', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('36a83351-24d9-4519-bc1s-118b6e23c5d1', '3', '施工项目', '其它工程', '8', '2', '数量,单位个', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('a3017d37-129c-43a4-9938-b616a1db5dce', '1', '雨水', '', '1', '1', '', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('4b1a460c-28d1-4820-ad8b-9306f00a9ce8', '5', '特大桥', '', '1', '1', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('147dc6e0-8416-4cf6-9141-ac9b06d142b6', '5', '大桥', '', '2', '1', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('a213e66c-36d6-4f14-b22b-e86d127a8de2', '5', '中桥', '', '3', '1', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('32917cc0-53eb-4332-a8c0-9e1e4c106813', '5', '小桥', '', '4', '1', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('c371b53e-5b93-40fd-8d44-853cf9e09845', '5', '涵洞', '', '5', '1', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('35741cac-e60b-4dcc-aac5-75eae46d6477', '5', '其他', '', '99', '1', '数量,单位座', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('f3b04caa-8b2c-41ad-b65d-854a100bbecb', '1', '污水', '', '2', '1', '', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('bfae81c3-26d5-43d2-a5af-3e4e5201a171', '1', '合流', '', '3', '1', '', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('1caf5cea-124b-47c9-a2ff-a40fbb181613', '0', '瓶装液化气', '液化气用户', '1', '2', '数量，单位家', NULL, NULL, 1, NULL, NULL, NULL, NULL); -- INSERT INTO "public"."local_dict_jcss" VALUES ('f47fe844-c029-2w45-b853-cdf11e77e57d', '0', '管道气', '管道气用户', '3', '2', '数量，单位家', NULL, NULL, 1, NULL, NULL, NULL, NULL); --应急预案资源保障 DROP TABLE IF EXISTS public.industry_supervision_scheme_resource; CREATE TABLE public.industry_supervision_scheme_resource ( id varchar(64) NOT NULL, supervision_scheme_id varchar(64), resource_type varchar(64), resource_id varchar(500), resource_name varchar(500), bz varchar(500), deleted int4, created_at timestamp(6), created_by varchar(100), updated_at timestamp(6), updated_by varchar(100), PRIMARY KEY (id) ); COMMENT ON COLUMN public.industry_supervision_scheme_resource.supervision_scheme_id IS '应急预案id'; COMMENT ON COLUMN public.industry_supervision_scheme_resource.resource_type IS '资源类型'; COMMENT ON COLUMN public.industry_supervision_scheme_resource.resource_id IS '资源id'; COMMENT ON COLUMN public.industry_supervision_scheme_resource.resource_name IS '资源名称'; COMMENT ON COLUMN public.industry_supervision_scheme_resource.bz IS '备注'; COMMENT ON TABLE public.industry_supervision_scheme_resource IS '应急预案资源保障'; --应急预案节点 DROP TABLE IF EXISTS public.industry_supervision_scheme_node; CREATE TABLE public.industry_supervision_scheme_node ( id varchar(64) NOT NULL, supervision_scheme_id varchar(64), dept_name varchar(500), dept_id varchar(500), node_name varchar(64), disposal_time timestamp(6), bz varchar(500), deleted int4, created_at timestamp(6), created_by varchar(100), updated_at timestamp(6), updated_by varchar(100), PRIMARY KEY (id) ); COMMENT ON COLUMN public.industry_supervision_scheme_node.supervision_scheme_id IS '应急预案id'; COMMENT ON COLUMN public.industry_supervision_scheme_node.dept_name IS '部门名称'; COMMENT ON COLUMN public.industry_supervision_scheme_node.dept_id IS '部门id'; COMMENT ON COLUMN public.industry_supervision_scheme_node.node_name IS '预案节点'; COMMENT ON COLUMN public.industry_supervision_scheme_node.disposal_time IS '处置时间'; COMMENT ON COLUMN public.industry_supervision_scheme_node.bz IS '备注'; COMMENT ON TABLE public.industry_supervision_scheme_node IS '应急预案节点'; --sg_jg_dsfsgxmxx ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN xmmc DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN jsdwfzr DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN jsdwfzrlxdh DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN sgdwfzr DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN sgdwfzrlxdh DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.sg_jg_dsfsgxmxx ALTER COLUMN tbsj DROP NOT NULL; --ql_js_ql ALTER TABLE public.ql_js_ql ALTER COLUMN qlmc DROP NOT NULL; ALTER TABLE public.ql_js_ql ALTER COLUMN jcbg DROP NOT NULL; ALTER TABLE public.ql_js_ql ALTER COLUMN yskzjbz DROP NOT NULL; -- ALTER TABLE public.ql_js_ql ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.ql_js_ql ALTER COLUMN tbsj DROP NOT NULL; --dl_js_csdl ALTER TABLE public.dl_js_csdl ALTER COLUMN xzqhdm DROP NOT NULL; ALTER TABLE public.dl_js_csdl ALTER COLUMN dlmc DROP NOT NULL; -- ALTER TABLE public.dl_js_csdl ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.dl_js_csdl ALTER COLUMN tbsj DROP NOT NULL; ALTER TABLE public.dl_js_csdl ALTER COLUMN yskzjbz DROP NOT NULL; ALTER TABLE public.dl_js_csdl ALTER COLUMN kjxx DROP NOT NULL; --ps_js_xxtd ALTER TABLE public.ps_js_xxtd ALTER COLUMN xzqhdm DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN xxtdbm DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN tbdw DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN tbrq DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN yskzjbz DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.ps_js_xxtd ALTER COLUMN tbsj DROP NOT NULL; --ps_js_psh ALTER TABLE public.ps_js_psh ALTER COLUMN xzqhdm DROP NOT NULL; ALTER TABLE public.ps_js_psh ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.ps_js_psh ALTER COLUMN tbsj DROP NOT NULL; --ps_js_zyhd ALTER TABLE public.ps_js_zyhd ALTER COLUMN hlmc DROP NOT NULL; ALTER TABLE public.ps_js_zyhd ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.ps_js_zyhd ALTER COLUMN tbsj DROP NOT NULL; --gs_jg_ljgwgzlsqk ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN xzqhdm DROP NOT NULL; ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN dnjhgzljgwzc DROP NOT NULL; ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN ljgwygzcd DROP NOT NULL; ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN ljgwgzzcd DROP NOT NULL; ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN ljgwwgzcd DROP NOT NULL; -- ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN yskzjbz DROP NOT NULL; -- ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN sjtbzt DROP NOT NULL; -- ALTER TABLE public.gs_jg_ljgwgzlsqk ALTER COLUMN tbsj DROP NOT NULL; --rq_js_rqyh ALTER TABLE public.rq_js_rqyh ALTER COLUMN xzqhdm DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN yhlx DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN yhxx DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN xxdz DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN sfzdyqcs DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN bjq DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN sfyqdzz DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN yskzjbz DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN sjtbzt DROP NOT NULL; ALTER TABLE public.rq_js_rqyh ALTER COLUMN tbsj DROP NOT NULL; --industry_supervision_scheme -- alter table public.industry_supervision_scheme add column yabzdw varchar(500); -- alter table public.industry_supervision_scheme add column type varchar(500); -- alter table public.industry_supervision_scheme add column keyword varchar(255); -- alter table public.industry_supervision_scheme add column syfw text; -- alter table public.industry_supervision_scheme add column yazlc varchar(500); -- alter table public.industry_supervision_scheme add column yanr text; -- alter table public.industry_supervision_scheme add column area varchar(64); --linkage_coordinate -- alter table public.linkage_coordinate add column remark varchar(500); -- alter table public.linkage_coordinate add column event_id varchar(64); -- alter table public.linkage_coordinate add column coordinate_source varchar(64); --work_order_admin -- alter table public.work_order_admin add column send_scene varchar(64); -- alter table public.work_order_admin add column complete_attachments varchar(600); -- alter table public.work_order_admin add column disposal_dept varchar(255); -- alter table public.work_order_admin add column disposal_dept_id varchar(64); -- alter table public.work_order_admin add column yjyabh varchar(255); -- alter table public.work_order_admin add column order_source varchar(64); --zhjg_analysis_emergency -- alter table public.zhjg_analysis_emergency add column emergency_code varchar(100); --zhjg_analysis_facility -- alter table public.zhjg_analysis_facility add column big_category varchar(64); -- alter table public.zhjg_analysis_facility add column small_category varchar(64); --联动协调下发表 DROP TABLE IF EXISTS public.linkage_coordinate_send; CREATE TABLE public.linkage_coordinate_send ( id varchar(64) NOT NULL, scene varchar(16), coordinate_id varchar(64), event_number varchar(64), event_sub_number varchar(64), handler varchar(64), complete_attachments varchar(600), disposal_dept varchar(255), feedback varchar(500), process_time timestamp(6), state varchar(16), yjyabh varchar(255), bz varchar(500), deleted int4, created_at timestamp(6), created_by varchar(100), updated_at timestamp(6), updated_by varchar(100), PRIMARY KEY (id) ); COMMENT ON COLUMN public.linkage_coordinate_send.scene IS '所属专项'; COMMENT ON COLUMN public.linkage_coordinate_send.coordinate_id IS '联动协调id'; COMMENT ON COLUMN public.linkage_coordinate_send.event_number IS '事件编号'; COMMENT ON COLUMN public.linkage_coordinate_send.event_sub_number IS '关联子事件编号'; COMMENT ON COLUMN public.linkage_coordinate_send.handler IS '处理人'; COMMENT ON COLUMN public.linkage_coordinate_send.complete_attachments IS '处理后的图片'; COMMENT ON COLUMN public.linkage_coordinate_send.disposal_dept IS '处理部门'; COMMENT ON COLUMN public.linkage_coordinate_send.feedback IS '处理结果说明'; COMMENT ON COLUMN public.linkage_coordinate_send.process_time IS '处理时间'; COMMENT ON COLUMN public.linkage_coordinate_send.state IS '当前处理状态'; COMMENT ON COLUMN public.linkage_coordinate_send.yjyabh IS '关联应急预案编号'; COMMENT ON COLUMN public.linkage_coordinate_send.bz IS '备注'; COMMENT ON TABLE public.linkage_coordinate_send IS '联动协调下发表'; --基础设施大类小类字典表 -- CREATE TABLE public.local_dict_jcss ( -- id varchar(64) NOT NULL, -- scene varchar(64), -- big_category varchar(64), -- small_category varchar(64), -- code varchar(64), -- type varchar(64), -- description varchar(64), -- sort int4, -- bz varchar(500), -- deleted int4, -- created_at timestamp(6), -- created_by varchar(100), -- updated_at timestamp(6), -- updated_by varchar(100), -- PRIMARY KEY (id) -- ); -- COMMENT ON TABLE public.local_dict_jcss IS '业务字典-基础设施'; -- INSERT INTO "public"."local_dict_jcss" VALUES ('4e8882e7-7aee-42af-8668-b3e987b27b19', '0', '管道气', '', '0', '1', '', NULL, NULL, 1, NULL, NULL, NULL, NULL); --应急预案资源保障 DROP TABLE IF EXISTS public.industry_supervision_scheme_resource; CREATE TABLE public.industry_supervision_scheme_resource ( id varchar(64) NOT NULL, supervision_scheme_id varchar(64), resource_type varchar(64), resource_id varchar(500), resource_name varchar(500), bz varchar(500), deleted int4, created_at timestamp(6), created_by varchar(100), updated_at timestamp(6), updated_by varchar(100), PRIMARY KEY (id) ); COMMENT ON COLUMN public.industry_supervision_scheme_resource.supervision_scheme_id IS '应急预案id'; COMMENT ON COLUMN public.industry_supervision_scheme_resource.resource_type IS '资源类型'; COMMENT ON COLUMN public.industry_supervision_scheme_resource.resource_id IS '资源id'; COMMENT ON COLUMN public.industry_supervision_scheme_resource.resource_name IS '资源名称'; COMMENT ON COLUMN public.industry_supervision_scheme_resource.bz IS '备注'; COMMENT ON TABLE public.industry_supervision_scheme_resource IS '应急预案资源保障'; --应急预案节点 DROP TABLE IF EXISTS public.industry_supervision_scheme_node; CREATE TABLE public.industry_supervision_scheme_node ( id varchar(64) NOT NULL, supervision_scheme_id varchar(64), dept_name varchar(500), dept_id varchar(500), node_name varchar(64), disposal_time timestamp(6), bz varchar(500), deleted int4, created_at timestamp(6), created_by varchar(100), updated_at timestamp(6), updated_by varchar(100), PRIMARY KEY (id) ); COMMENT ON COLUMN public.industry_supervision_scheme_node.supervision_scheme_id IS '应急预案id'; COMMENT ON COLUMN public.industry_supervision_scheme_node.dept_name IS '部门名称'; COMMENT ON COLUMN public.industry_supervision_scheme_node.dept_id IS '部门id'; COMMENT ON COLUMN public.industry_supervision_scheme_node.node_name IS '预案节点'; COMMENT ON COLUMN public.industry_supervision_scheme_node.disposal_time IS '处置时间'; COMMENT ON COLUMN public.industry_supervision_scheme_node.bz IS '备注'; COMMENT ON TABLE public.industry_supervision_scheme_node IS '应急预案节点';