programs_info/无锡市生命线项目/数据库备份/删除前备份/三批次修改sql(1).txt

--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 '应急预案节点';