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


-- ----------------------------
-- Table structure for ps_js_xxtd
-- ----------------------------
DROP TABLE IF EXISTS "public"."ps_js_xxtd";
CREATE TABLE "public"."ps_js_xxtd" (
  "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "xzqhdm" varchar(6) COLLATE "pg_catalog"."default" NOT NULL,
  "xxtdbm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "dbysxxtdlx" int4 NOT NULL,
  "lmdjymclx" int4,
  "dbysxxtdcl" numeric(9,4) NOT NULL,
  "sjly" varchar(50) COLLATE "pg_catalog"."default",
  "sjhqrq" date,
  "tbdw" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
  "tbrq" date NOT NULL,
  "dlmc" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "dz" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "cd" numeric(10,3) NOT NULL,
  "mj" numeric(12,2) NOT NULL,
  "bz" varchar(255) COLLATE "pg_catalog"."default",
  "yskzjbz" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "sjtbzt" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "tbsj" timestamp(6) NOT NULL,
  "kjxx" "public"."geometry"
)
;
COMMENT ON COLUMN "public"."ps_js_xxtd"."bsm" IS '标识码';
COMMENT ON COLUMN "public"."ps_js_xxtd"."xzqhdm" IS '行政区划代码';
COMMENT ON COLUMN "public"."ps_js_xxtd"."xxtdbm" IS '行泄通道编码';
COMMENT ON COLUMN "public"."ps_js_xxtd"."dbysxxtdlx" IS '地表雨水行泄通道类型';
COMMENT ON COLUMN "public"."ps_js_xxtd"."lmdjymclx" IS '路面等级与面层类型';
COMMENT ON COLUMN "public"."ps_js_xxtd"."dbysxxtdcl" IS '地表雨水行泄通道糙率';
COMMENT ON COLUMN "public"."ps_js_xxtd"."sjly" IS '数据来源';
COMMENT ON COLUMN "public"."ps_js_xxtd"."sjhqrq" IS '数据获取日期';
COMMENT ON COLUMN "public"."ps_js_xxtd"."tbdw" IS '填报单位';
COMMENT ON COLUMN "public"."ps_js_xxtd"."tbrq" IS '填报日期';
COMMENT ON COLUMN "public"."ps_js_xxtd"."dlmc" IS '道路名称';
COMMENT ON COLUMN "public"."ps_js_xxtd"."dz" IS '地址';
COMMENT ON COLUMN "public"."ps_js_xxtd"."cd" IS '长度';
COMMENT ON COLUMN "public"."ps_js_xxtd"."mj" IS '面积';
COMMENT ON COLUMN "public"."ps_js_xxtd"."bz" IS '备注';
COMMENT ON COLUMN "public"."ps_js_xxtd"."yskzjbz" IS '原始库主键标志';
COMMENT ON COLUMN "public"."ps_js_xxtd"."sjtbzt" IS '数据同步状态';
COMMENT ON COLUMN "public"."ps_js_xxtd"."tbsj" IS '同步时间';
COMMENT ON COLUMN "public"."ps_js_xxtd"."kjxx" IS '空间信息';
COMMENT ON TABLE "public"."ps_js_xxtd" IS '行泄通道属性结构表';

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