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

--work_order_admin
alter table public.work_order_admin add column order_urgent varchar(64);

--zhjg_rcwhwx
DROP TABLE IF EXISTS public.zhjg_rcwhwx;
CREATE TABLE public.zhjg_rcwhwx (
  id varchar(32) NOT NULL,
  bsm varchar(32) NOT NULL,
  scene varchar(64) NOT NULL,
  xzqhdm varchar(6) NOT NULL,
  whwxnr varchar(255) NOT NULL,
  sbsslx varchar(500),
  sbssid varchar(500),
  sbssname varchar(500),
  sbss varchar(500) NOT NULL,
  cljg varchar(255),
  clrq timestamp(6),
  clry varchar(32),
  lxdh varchar(16),
  yhdw varchar(255),
  ssqsdw varchar(100),
  jcff varchar(255) NOT NULL,
  jcjl varchar(255) NOT NULL,
  fj varchar(1000),
  bz varchar(255),
  yskzjbz varchar(64),
  sjtbzt varchar(16),
  tbsj timestamp(6),
  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.zhjg_rcwhwx.bsm IS '标识码';
COMMENT ON COLUMN public.zhjg_rcwhwx.scene IS '专项场景';
COMMENT ON COLUMN public.zhjg_rcwhwx.xzqhdm IS '行政区划代码';
COMMENT ON COLUMN public.zhjg_rcwhwx.whwxnr IS '维护维修内容';
COMMENT ON COLUMN public.zhjg_rcwhwx.sbsslx IS '设备设施类型';
COMMENT ON COLUMN public.zhjg_rcwhwx.sbss IS '设备设施';
COMMENT ON COLUMN public.zhjg_rcwhwx.cljg IS '处理结果';
COMMENT ON COLUMN public.zhjg_rcwhwx.clrq IS '处理日期';
COMMENT ON COLUMN public.zhjg_rcwhwx.clry IS '处理人员';
COMMENT ON COLUMN public.zhjg_rcwhwx.lxdh IS '联系电话';
COMMENT ON COLUMN public.zhjg_rcwhwx.yhdw IS '养护单位';
COMMENT ON COLUMN public.zhjg_rcwhwx.ssqsdw IS '设施权属单位';
COMMENT ON COLUMN public.zhjg_rcwhwx.jcff IS '检测方法';
COMMENT ON COLUMN public.zhjg_rcwhwx.jcjl IS '检测结论';
COMMENT ON COLUMN public.zhjg_rcwhwx.fj IS '附件';
COMMENT ON COLUMN public.zhjg_rcwhwx.bz IS '备注';
COMMENT ON COLUMN public.zhjg_rcwhwx.yskzjbz IS '原始库主键标志';
COMMENT ON COLUMN public.zhjg_rcwhwx.sjtbzt IS '数据同步状态';
COMMENT ON COLUMN public.zhjg_rcwhwx.tbsj IS '同步时间';
COMMENT ON TABLE public.zhjg_rcwhwx IS '综合监管日常维护维修属性结构表';

--zhjg_analysis_facility
ALTER TABLE public.zhjg_analysis_facility ALTER COLUMN facility_quantity TYPE numeric(10,2);