| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970 |
- /*
- 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");
|
