programs_info/无锡市生命线项目/数据库备份/删除前备份/政务网同步到外网/jcss_gscz.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 政务网生命线(内网)2.21.138.148
 Source Server Type    : PostgreSQL
 Source Server Version : 140009
 Source Host           : 2.21.138.148:5333
 Source Catalog        : citylifeline_db
 Source Schema         : public

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

 Date: 06/03/2024 10:36:16
*/


-- ----------------------------
-- Table structure for jcss_gscz
-- ----------------------------
DROP TABLE IF EXISTS "public"."jcss_gscz";
CREATE TABLE "public"."jcss_gscz" (
  "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "jcss_id" varchar(64) COLLATE "pg_catalog"."default",
  "czlx" varchar(64) COLLATE "pg_catalog"."default",
  "symc" varchar(64) COLLATE "pg_catalog"."default",
  "sylx" varchar(64) COLLATE "pg_catalog"."default",
  "qsgm" numeric(10,2),
  "yjsymc" varchar(64) COLLATE "pg_catalog"."default",
  "yjsylx" varchar(64) COLLATE "pg_catalog"."default",
  "yjqsgm" numeric(10,2),
  "yjqsts" numeric(10,2),
  "gsgm" numeric(10,2),
  "gsrk" numeric(10,2),
  "gsqy" varchar(250) COLLATE "pg_catalog"."default",
  "clgy" varchar(64) COLLATE "pg_catalog"."default",
  "tcrq" timestamp(6),
  "zyzlx" varchar(500) COLLATE "pg_catalog"."default",
  "jgrq" timestamp(6),
  "remark" varchar(500) COLLATE "pg_catalog"."default",
  "defined" int4,
  "deleted" int4,
  "created_at" timestamp(6),
  "created_by" varchar(100) COLLATE "pg_catalog"."default",
  "updated_at" timestamp(6),
  "updated_by" varchar(100) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."jcss_gscz"."jcss_id" IS '基础设施id';
COMMENT ON COLUMN "public"."jcss_gscz"."czlx" IS '厂站类型 0原水厂、1自来水厂、2增压站、3二次供水泵房';
COMMENT ON COLUMN "public"."jcss_gscz"."symc" IS '水源名称';
COMMENT ON COLUMN "public"."jcss_gscz"."sylx" IS '水源类型 0地表水、1地下水';
COMMENT ON COLUMN "public"."jcss_gscz"."qsgm" IS '取水规模';
COMMENT ON COLUMN "public"."jcss_gscz"."yjsymc" IS '应急水源名称';
COMMENT ON COLUMN "public"."jcss_gscz"."yjsylx" IS '应急水源类型 0地表水、1地下水';
COMMENT ON COLUMN "public"."jcss_gscz"."yjqsgm" IS '应急取水规模';
COMMENT ON COLUMN "public"."jcss_gscz"."yjqsts" IS '应急取水天数';
COMMENT ON COLUMN "public"."jcss_gscz"."gsgm" IS '供水规模';
COMMENT ON COLUMN "public"."jcss_gscz"."gsrk" IS '供水人口';
COMMENT ON COLUMN "public"."jcss_gscz"."gsqy" IS '供水区域';
COMMENT ON COLUMN "public"."jcss_gscz"."clgy" IS '处理工艺';
COMMENT ON COLUMN "public"."jcss_gscz"."tcrq" IS '投产日期';
COMMENT ON COLUMN "public"."jcss_gscz"."zyzlx" IS '增压站类型';
COMMENT ON COLUMN "public"."jcss_gscz"."jgrq" IS '竣工日期';
COMMENT ON COLUMN "public"."jcss_gscz"."remark" IS '备注';
COMMENT ON TABLE "public"."jcss_gscz" IS '供水厂站';

-- ----------------------------
-- Records of jcss_gscz
-- ----------------------------
INSERT INTO "public"."jcss_gscz" VALUES ('4A5E913B87CA43D9A61755C8A9A20308', 'gscz_4A5E913B87CA43D9A61755C8A9A20308', '1', '长江', '1', -1.00, '互为应急', '太湖', -1.00, 365.00, -1.00, -1.00, '1622 平方公里', '预处理-常规', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:02.159', '-1');
INSERT INTO "public"."jcss_gscz" VALUES ('32CE3133AD5A4296869D08050DB00F38', 'gscz_32CE3133AD5A4296869D08050DB00F38', '2', '长江', '1', -1.00, '互为应急', '太湖', -1.00, 365.00, -1.00, -1.00, '1622 平方公里', '常规-深度', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:02.165', '-1');
INSERT INTO "public"."jcss_gscz" VALUES ('96E58EFE391149D4A45E7365D6FF6BF3', 'gscz_96E58EFE391149D4A45E7365D6FF6BF3', '2', '太湖', '2', -1.00, '互为应急', '长江', -1.00, 365.00, -1.00, -1.00, '1622 平方公里', '预处理-常规-深度', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:02.17', '-1');
INSERT INTO "public"."jcss_gscz" VALUES ('9C505CBB780844739E4F7A728CA1105B', 'gscz_9C505CBB780844739E4F7A728CA1105B', '1', '太湖', '2', -1.00, '互为应急', '长江', -1.00, 365.00, -1.00, -1.00, '1622 平方公里', '预处理', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:02.175', '-1');
INSERT INTO "public"."jcss_gscz" VALUES ('B274A37FA4DC48A48D9E7E27B748A3CE', 'gscz_B274A37FA4DC48A48D9E7E27B748A3CE', '2', '太湖', '2', -1.00, '互为应急', '长江', -1.00, 365.00, -1.00, -1.00, '1622 平方公里', '常规-深度', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:02.179', '-1');
INSERT INTO "public"."jcss_gscz" VALUES ('5F278E16211540A2B5F156C51A76FB5B', 'gscz_5F278E16211540A2B5F156C51A76FB5B', '2', '太湖', '2', -1.00, '互为应急', '长江', -1.00, 365.00, -1.00, -1.00, '1622 平方公里', '常规-深度', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:02.184', '-1');
INSERT INTO "public"."jcss_gscz" VALUES ('9D8EF23718B44C4A8D3168588BCB3AEC', 'gscz_9D8EF23718B44C4A8D3168588BCB3AEC', '1', '太湖', '2', -1.00, '互为应急', '长江', -1.00, 365.00, -1.00, -1.00, '1622 平方公里', '预处理-常规-深度', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:02.192', '-1');

-- ----------------------------
-- Primary Key structure for table jcss_gscz
-- ----------------------------
ALTER TABLE "public"."jcss_gscz" ADD CONSTRAINT "jcss_gscz_pkey" PRIMARY KEY ("id");