/*
 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:13
*/


-- ----------------------------
-- Table structure for ps_js_zyhd
-- ----------------------------
DROP TABLE IF EXISTS "public"."ps_js_zyhd";
CREATE TABLE "public"."ps_js_zyhd" (
  "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "xzqhdm" varchar(6) COLLATE "pg_catalog"."default",
  "hdbm" varchar(32) COLLATE "pg_catalog"."default",
  "hlmc" varchar(20) COLLATE "pg_catalog"."default" NOT NULL,
  "hdcd" numeric(11,3) NOT NULL,
  "qdzhbm" varchar(17) COLLATE "pg_catalog"."default" NOT NULL,
  "zdzhbm" varchar(17) COLLATE "pg_catalog"."default" NOT NULL,
  "qdhdbg" numeric(10,3),
  "zdhdbg" numeric(10,3),
  "csw" numeric(8,2),
  "jjsw" numeric(8,2),
  "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_zyhd"."bsm" IS '标识码';
COMMENT ON COLUMN "public"."ps_js_zyhd"."xzqhdm" IS '行政区划代码';
COMMENT ON COLUMN "public"."ps_js_zyhd"."hdbm" IS '河道编码';
COMMENT ON COLUMN "public"."ps_js_zyhd"."hlmc" IS '河流名称';
COMMENT ON COLUMN "public"."ps_js_zyhd"."hdcd" IS '河段长度';
COMMENT ON COLUMN "public"."ps_js_zyhd"."qdzhbm" IS '起点桩号编码';
COMMENT ON COLUMN "public"."ps_js_zyhd"."zdzhbm" IS '终点桩号编码';
COMMENT ON COLUMN "public"."ps_js_zyhd"."qdhdbg" IS '起点河底标高';
COMMENT ON COLUMN "public"."ps_js_zyhd"."zdhdbg" IS '终点河底标高';
COMMENT ON COLUMN "public"."ps_js_zyhd"."csw" IS '常水位';
COMMENT ON COLUMN "public"."ps_js_zyhd"."jjsw" IS '警戒水位';
COMMENT ON COLUMN "public"."ps_js_zyhd"."bz" IS '备注';
COMMENT ON COLUMN "public"."ps_js_zyhd"."yskzjbz" IS '原始库主键标志';
COMMENT ON COLUMN "public"."ps_js_zyhd"."sjtbzt" IS '数据同步状态';
COMMENT ON COLUMN "public"."ps_js_zyhd"."tbsj" IS '同步时间';
COMMENT ON COLUMN "public"."ps_js_zyhd"."kjxx" IS '空间信息';
COMMENT ON TABLE "public"."ps_js_zyhd" IS '主要河道属性结构表';

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