/*
 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:35:51
*/


-- ----------------------------
-- Table structure for jcss_pspk
-- ----------------------------
DROP TABLE IF EXISTS "public"."jcss_pspk";
CREATE TABLE "public"."jcss_pspk" (
  "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "jcss_id" varchar(64) COLLATE "pg_catalog"."default",
  "lb" varchar(64) COLLATE "pg_catalog"."default",
  "dbgc" numeric(10,2),
  "dbugc" numeric(10,2),
  "pkcc" varchar(64) COLLATE "pg_catalog"."default",
  "sfypm" varchar(64) COLLATE "pg_catalog"."default",
  "clxs" varchar(64) COLLATE "pg_catalog"."default",
  "hdcsw" numeric(10,2),
  "pkzp" 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_pspk"."jcss_id" IS '基础设施id';
COMMENT ON COLUMN "public"."jcss_pspk"."lb" IS '类别 0雨水、1污水、2合流';
COMMENT ON COLUMN "public"."jcss_pspk"."dbgc" IS '地表高程';
COMMENT ON COLUMN "public"."jcss_pspk"."dbugc" IS '顶部高程';
COMMENT ON COLUMN "public"."jcss_pspk"."pkcc" IS '排口尺寸';
COMMENT ON COLUMN "public"."jcss_pspk"."sfypm" IS '是否有拍门 0是、2否';
COMMENT ON COLUMN "public"."jcss_pspk"."clxs" IS '出流形式 0自由出流、1常水位淹没、2潮汐影响';
COMMENT ON COLUMN "public"."jcss_pspk"."hdcsw" IS '河道常水位';
COMMENT ON COLUMN "public"."jcss_pspk"."pkzp" IS '排口照片';
COMMENT ON COLUMN "public"."jcss_pspk"."remark" IS '备注';
COMMENT ON TABLE "public"."jcss_pspk" IS '排水排口';

-- ----------------------------
-- Records of jcss_pspk
-- ----------------------------
INSERT INTO "public"."jcss_pspk" VALUES ('15', 'pspk_15', '1', 0.52, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.53', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('16', 'pspk_16', '1', 0.55, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.536', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('18', 'pspk_18', '1', 0.58, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.541', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('20', 'pspk_20', '1', 0.58, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.547', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('21', 'pspk_21', '1', 0.58, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.553', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('22', 'pspk_22', '1', 0.51, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.561', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('24', 'pspk_24', '1', 0.60, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.568', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('25', 'pspk_25', '1', 0.32, NULL, 'd1000', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.574', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('26', 'pspk_26', '1', 0.28, NULL, 'd1000', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.58', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('27', 'pspk_27', '1', 0.52, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.587', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('28', 'pspk_28', '1', 0.51, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.593', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('29', 'pspk_29', '1', 0.53, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.599', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('30', 'pspk_30', '1', 0.31, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.605', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('31', 'pspk_31', '1', 0.76, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.611', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('32', 'pspk_32', '1', 0.56, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.621', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('33', 'pspk_33', '1', 0.80, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.629', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('34', 'pspk_34', '1', 0.60, NULL, 'd1000', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.636', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('35', 'pspk_35', '1', 0.78, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.642', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('36', 'pspk_36', '1', 1.95, NULL, 'd1000', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.648', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('37', 'pspk_37', '1', 2.03, NULL, 'd1000', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.653', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('38', 'pspk_38', '1', 2.40, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.659', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('1', 'pspk_1', '1', 0.51, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.667', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('2', 'pspk_2', '1', 0.50, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.673', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('3', 'pspk_3', '1', 0.50, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.679', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('4', 'pspk_4', '1', 0.50, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.685', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('5', 'pspk_5', '1', 0.52, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.69', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('6', 'pspk_6', '1', 0.50, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.696', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('7', 'pspk_7', '1', 0.61, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.703', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('8', 'pspk_8', '1', 0.61, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.709', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('9', 'pspk_9', '1', 0.57, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.715', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('10', 'pspk_10', '1', 0.58, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.721', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('11', 'pspk_11', '1', 0.44, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.726', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('17', 'pspk_17', '1', 0.58, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.733', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('23', 'pspk_23', '1', 0.50, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.739', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('12', 'pspk_12', '1', 0.46, NULL, 'd600', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.745', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('13', 'pspk_13', '1', 0.61, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.751', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('14', 'pspk_14', '1', 0.61, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.757', '-1');
INSERT INTO "public"."jcss_pspk" VALUES ('19', 'pspk_19', '1', 0.55, NULL, 'd800', '无', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.762', '-1');

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