programs_info/无锡市生命线项目/数据库备份/删除前备份/政务网同步到外网/jcss_pscz.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:04
*/


-- ----------------------------
-- Table structure for jcss_pscz
-- ----------------------------
DROP TABLE IF EXISTS "public"."jcss_pscz";
CREATE TABLE "public"."jcss_pscz" (
  "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "jcss_id" varchar(64) COLLATE "pg_catalog"."default",
  "czlx" varchar(64) COLLATE "pg_catalog"."default",
  "jgrq" timestamp(6),
  "wscljb" varchar(64) COLLATE "pg_catalog"."default",
  "nhdl" numeric(10,2),
  "wsclsjgm" numeric(10,2),
  "wsyxfhl" numeric(10,2),
  "ysclsjgm" numeric(10,2),
  "wnclsjgm" numeric(10,2),
  "wnyxfhl" numeric(10,2),
  "wnczfs" varchar(64) COLLATE "pg_catalog"."default",
  "wnczdw" varchar(100) COLLATE "pg_catalog"."default",
  "bzsbts" int4,
  "bzzgl" numeric(10,2),
  "bzzll" numeric(10,2),
  "bzzp" varchar(500) COLLATE "pg_catalog"."default",
  "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_pscz"."jcss_id" IS '基础设施id';
COMMENT ON COLUMN "public"."jcss_pscz"."czlx" IS '厂站类型 0污水处理厂、1雨水泵站、2污水泵站';
COMMENT ON COLUMN "public"."jcss_pscz"."jgrq" IS '竣工日期';
COMMENT ON COLUMN "public"."jcss_pscz"."wscljb" IS '污水处理级别 0一级、1二级、2三级';
COMMENT ON COLUMN "public"."jcss_pscz"."nhdl" IS '年耗电量';
COMMENT ON COLUMN "public"."jcss_pscz"."wsclsjgm" IS '污水处理设计规模';
COMMENT ON COLUMN "public"."jcss_pscz"."wsyxfhl" IS '污水运行负荷率';
COMMENT ON COLUMN "public"."jcss_pscz"."ysclsjgm" IS '雨水处理设计规模';
COMMENT ON COLUMN "public"."jcss_pscz"."wnclsjgm" IS '污泥处理设计规模';
COMMENT ON COLUMN "public"."jcss_pscz"."wnyxfhl" IS '污泥运行负荷率';
COMMENT ON COLUMN "public"."jcss_pscz"."wnczfs" IS '污泥处置方式 0填埋、1焚烧、2土地利用、3建材利用、4堆肥、5其它';
COMMENT ON COLUMN "public"."jcss_pscz"."wnczdw" IS '污泥处置单位';
COMMENT ON COLUMN "public"."jcss_pscz"."bzsbts" IS '泵站水泵台数';
COMMENT ON COLUMN "public"."jcss_pscz"."bzzgl" IS '泵站总功率';
COMMENT ON COLUMN "public"."jcss_pscz"."bzzll" IS '泵站总流量';
COMMENT ON COLUMN "public"."jcss_pscz"."bzzp" IS '泵站照片';
COMMENT ON COLUMN "public"."jcss_pscz"."remark" IS '备注';
COMMENT ON TABLE "public"."jcss_pscz" IS '排水场站';

-- ----------------------------
-- Records of jcss_pscz
-- ----------------------------
INSERT INTO "public"."jcss_pscz" VALUES ('1', 'pscz_1', '1', NULL, NULL, NULL, 2.00, 68.64, NULL, 16.65, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.004', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('10', 'pscz_10', '1', NULL, NULL, NULL, 1.00, 70.62, NULL, 15.14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.012', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('11', 'pscz_11', '1', NULL, NULL, NULL, 2.00, 68.90, NULL, 52.13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.017', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('12', 'pscz_12', '1', NULL, NULL, NULL, 10.00, 84.97, NULL, 3.87, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.021', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('13', 'pscz_13', '1', NULL, NULL, NULL, 4.00, 83.80, NULL, 47.66, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.027', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('14', 'pscz_14', '1', NULL, NULL, NULL, 3.00, 71.93, NULL, 15.97, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.032', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('15', 'pscz_15', '1', NULL, NULL, NULL, 3.00, 76.33, NULL, 11.32, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.041', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('16', 'pscz_16', '1', NULL, NULL, NULL, 30.00, 90.82, NULL, 187.36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.048', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('17', 'pscz_17', '1', NULL, NULL, NULL, 15.00, 0.00, NULL, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.054', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('18', 'pscz_18', '1', NULL, NULL, NULL, 25.00, 0.00, NULL, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.061', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('19', 'pscz_19', '1', NULL, NULL, NULL, 17.00, 0.00, NULL, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.066', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('2', 'pscz_2', '1', NULL, NULL, NULL, 2.00, 96.88, NULL, 26.59, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.073', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('20', 'pscz_20', '1', NULL, NULL, NULL, 21.00, 0.00, NULL, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.079', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('21', 'pscz_21', '1', NULL, NULL, NULL, 6.50, 0.00, NULL, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.085', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('22', 'pscz_22', '3', NULL, NULL, NULL, 4.50, 0.00, NULL, 0.00, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.091', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('23', 'pscz_23', '3', NULL, NULL, NULL, 0.00, 0.00, NULL, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.098', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('24', 'pscz_24', '3', NULL, NULL, NULL, 6.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.105', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('25', 'pscz_25', '3', NULL, NULL, NULL, 1.68, 0.00, NULL, 0.00, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.111', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('26', 'pscz_26', '3', NULL, NULL, NULL, 2.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.117', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('27', 'pscz_27', '3', NULL, NULL, NULL, 4.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.123', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('28', 'pscz_28', '3', NULL, NULL, NULL, 4.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.131', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('29', 'pscz_29', '3', NULL, NULL, NULL, 3.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.137', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('3', 'pscz_3', '1', NULL, NULL, NULL, 5.00, 76.91, NULL, 34.02, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.143', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('30', 'pscz_30', '3', NULL, NULL, NULL, 1.50, 0.00, NULL, 0.00, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.149', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('31', 'pscz_31', '3', NULL, NULL, NULL, 0.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.156', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('32', 'pscz_32', '3', NULL, NULL, NULL, 0.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.162', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('33', 'pscz_33', '3', NULL, NULL, NULL, 1.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.17', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('34', 'pscz_34', '3', NULL, NULL, NULL, 2.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.176', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('35', 'pscz_35', '3', NULL, NULL, NULL, 0.72, 0.00, NULL, 0.00, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.182', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('36', 'pscz_36', '3', NULL, NULL, NULL, 0.80, 0.00, NULL, 0.00, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.188', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('37', 'pscz_37', '3', NULL, NULL, NULL, 5.20, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.195', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('38', 'pscz_38', '3', NULL, NULL, NULL, 4.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.201', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('39', 'pscz_39', '3', NULL, NULL, NULL, 3.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.207', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('4', 'pscz_4', '1', NULL, NULL, NULL, 6.00, 65.15, NULL, 29.23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.215', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('40', 'pscz_40', '3', NULL, NULL, NULL, 3.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.222', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('41', 'pscz_41', '3', NULL, NULL, NULL, 7.92, 0.00, NULL, 0.00, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.228', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('42', 'pscz_42', '3', NULL, NULL, NULL, 1.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.234', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('43', 'pscz_43', '3', NULL, NULL, NULL, 11.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.241', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('44', 'pscz_44', '3', NULL, NULL, NULL, 9.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.247', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('45', 'pscz_45', '3', NULL, NULL, NULL, 6.80, 0.00, NULL, 0.00, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.253', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('46', 'pscz_46', '3', NULL, NULL, NULL, 7.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.259', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('47', 'pscz_47', '3', NULL, NULL, NULL, 6.70, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.266', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('48', 'pscz_48', '3', NULL, NULL, NULL, 9.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.271', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('49', 'pscz_49', '3', NULL, NULL, NULL, 2.50, 0.00, NULL, 0.00, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.278', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('5', 'pscz_5', '1', NULL, NULL, NULL, 2.25, 93.32, NULL, 16.31, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.284', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('50', 'pscz_50', '3', NULL, NULL, NULL, 5.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.29', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('51', 'pscz_51', '3', NULL, NULL, NULL, 6.94, 0.00, NULL, 0.00, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.296', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('52', 'pscz_52', '3', NULL, NULL, NULL, 3.72, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.303', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('53', 'pscz_53', '3', NULL, NULL, NULL, 1.50, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.309', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('54', 'pscz_54', '3', NULL, NULL, NULL, 2.00, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.315', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('55', 'pscz_55', '3', NULL, NULL, NULL, 4.50, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.321', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('56', 'pscz_56', '3', NULL, NULL, NULL, 3.50, 0.00, NULL, 0.00, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.328', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('6', 'pscz_6', '1', NULL, NULL, NULL, 12.00, 94.87, NULL, 42.56, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.335', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('7', 'pscz_7', '1', NULL, NULL, NULL, 5.00, 99.83, NULL, 33.45, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.341', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('8', 'pscz_8', '1', NULL, NULL, NULL, 3.00, 83.40, NULL, 20.11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.347', '-1');
INSERT INTO "public"."jcss_pscz" VALUES ('9', 'pscz_9', '1', NULL, NULL, NULL, 0.50, 66.21, NULL, 4.28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:01.357', '-1');

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