programs_info/无锡市生命线项目/其他文件/新增表/ps_js_psh.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 生命线前置数据库47.113.226.116
 Source Server Type    : PostgreSQL
 Source Server Version : 140009
 Source Host           : 47.113.226.116:5333
 Source Catalog        : citylifeline_db
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 140009
 File Encoding         : 65001

 Date: 27/11/2023 11:31:35
*/


-- ----------------------------
-- Table structure for ps_js_psh
-- ----------------------------
DROP TABLE IF EXISTS "public"."ps_js_psh";
CREATE TABLE "public"."ps_js_psh" (
  "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "xzqhdm" varchar(6) COLLATE "pg_catalog"."default" NOT NULL,
  "sspsxt" varchar(32) COLLATE "pg_catalog"."default",
  "pshmc" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "pshdz" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "jrjcjbm" varchar(32) COLLATE "pg_catalog"."default",
  "zzjgdm" varchar(32) COLLATE "pg_catalog"."default",
  "frdb" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "lxdh" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "zgdw" varchar(32) COLLATE "pg_catalog"."default",
  "pshlx" varchar(200) COLLATE "pg_catalog"."default",
  "sfwzdpsh" bool NOT NULL,
  "zyscgy" varchar(200) COLLATE "pg_catalog"."default",
  "psxkzbh" varchar(16) COLLATE "pg_catalog"."default",
  "xkzbfrq" date,
  "yhzl" numeric(12,2),
  "zbsl" numeric(12,2),
  "zpsl" numeric(12,2),
  "scwsl" numeric(12,2),
  "shwsl" numeric(12,2),
  "dylwrwmc" varchar(50) COLLATE "pg_catalog"."default",
  "delwrwmc" varchar(50) COLLATE "pg_catalog"."default",
  "wsclfs" int4,
  "wsclgm" numeric(14,2),
  "jszlwj" varchar COLLATE "pg_catalog"."default",
  "sjly" varchar(64) COLLATE "pg_catalog"."default",
  "sjhqrq" date,
  "tbdw" varchar(100) COLLATE "pg_catalog"."default",
  "tbrq" date,
  "bz" varchar(255) COLLATE "pg_catalog"."default",
  "yskzjbz" varchar(64) COLLATE "pg_catalog"."default",
  "sjtbzt" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "tbsj" timestamp(6) NOT NULL,
  "kjxx" "public"."geometry"
)
;
COMMENT ON COLUMN "public"."ps_js_psh"."bsm" IS '标识码';
COMMENT ON COLUMN "public"."ps_js_psh"."xzqhdm" IS '行政区划代码';
COMMENT ON COLUMN "public"."ps_js_psh"."sspsxt" IS '所属排水系统';
COMMENT ON COLUMN "public"."ps_js_psh"."pshmc" IS '排水户名称';
COMMENT ON COLUMN "public"."ps_js_psh"."pshdz" IS '排水户地址';
COMMENT ON COLUMN "public"."ps_js_psh"."jrjcjbm" IS '接入检查井编码';
COMMENT ON COLUMN "public"."ps_js_psh"."zzjgdm" IS '组织机构代码';
COMMENT ON COLUMN "public"."ps_js_psh"."frdb" IS '法人代表';
COMMENT ON COLUMN "public"."ps_js_psh"."lxdh" IS '联系电话';
COMMENT ON COLUMN "public"."ps_js_psh"."zgdw" IS '主管单位';
COMMENT ON COLUMN "public"."ps_js_psh"."pshlx" IS '排水户类型';
COMMENT ON COLUMN "public"."ps_js_psh"."sfwzdpsh" IS '是否为重点排水户';
COMMENT ON COLUMN "public"."ps_js_psh"."zyscgy" IS '主要生产工艺';
COMMENT ON COLUMN "public"."ps_js_psh"."psxkzbh" IS '排水许可证编号';
COMMENT ON COLUMN "public"."ps_js_psh"."xkzbfrq" IS '许可证颁发日期';
COMMENT ON COLUMN "public"."ps_js_psh"."yhzl" IS '用户总量';
COMMENT ON COLUMN "public"."ps_js_psh"."zbsl" IS '自备水量';
COMMENT ON COLUMN "public"."ps_js_psh"."zpsl" IS '总排水量';
COMMENT ON COLUMN "public"."ps_js_psh"."scwsl" IS '生产污水量';
COMMENT ON COLUMN "public"."ps_js_psh"."shwsl" IS '生活污水量';
COMMENT ON COLUMN "public"."ps_js_psh"."dylwrwmc" IS '第一类污染物名称';
COMMENT ON COLUMN "public"."ps_js_psh"."delwrwmc" IS '第二类污染物名称';
COMMENT ON COLUMN "public"."ps_js_psh"."wsclfs" IS '污水处理方式';
COMMENT ON COLUMN "public"."ps_js_psh"."wsclgm" IS '污水处理规模';
COMMENT ON COLUMN "public"."ps_js_psh"."jszlwj" IS '技术资料文件';
COMMENT ON COLUMN "public"."ps_js_psh"."sjly" IS '数据来源';
COMMENT ON COLUMN "public"."ps_js_psh"."sjhqrq" IS '数据获取日期';
COMMENT ON COLUMN "public"."ps_js_psh"."tbdw" IS '填报单位';
COMMENT ON COLUMN "public"."ps_js_psh"."tbrq" IS '填报日期';
COMMENT ON COLUMN "public"."ps_js_psh"."bz" IS '备注';
COMMENT ON COLUMN "public"."ps_js_psh"."yskzjbz" IS '原始库主键标志';
COMMENT ON COLUMN "public"."ps_js_psh"."sjtbzt" IS '数据同步状态';
COMMENT ON COLUMN "public"."ps_js_psh"."tbsj" IS '同步时间';
COMMENT ON COLUMN "public"."ps_js_psh"."kjxx" IS '空间信息';
COMMENT ON TABLE "public"."ps_js_psh" IS '重点排水户属性结构表';

-- ----------------------------
-- Primary Key structure for table ps_js_psh
-- ----------------------------
ALTER TABLE "public"."ps_js_psh" ADD CONSTRAINT "ps_js_psh_pkey" PRIMARY KEY ("bsm");