programs_info/无锡市生命线项目/其他文件/新增表/dl_js_csdl.sql

/*
 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:32:14
*/


-- ----------------------------
-- Table structure for dl_js_csdl
-- ----------------------------
DROP TABLE IF EXISTS "public"."dl_js_csdl";
CREATE TABLE "public"."dl_js_csdl" (
  "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "xzqhdm" varchar(6) COLLATE "pg_catalog"."default" NOT NULL,
  "dlmc" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "dlqd" varchar(100) COLLATE "pg_catalog"."default",
  "dlzd" varchar(100) COLLATE "pg_catalog"."default",
  "dlzx" int4,
  "dldj" int4 NOT NULL,
  "glfl" int4 NOT NULL,
  "yhdj" int4 NOT NULL,
  "dlcd" numeric(12,2) NOT NULL,
  "dlkd" numeric(8,2) NOT NULL,
  "dlmj" numeric(12,2) NOT NULL,
  "jsdw" varchar(100) COLLATE "pg_catalog"."default",
  "sjdw" varchar(100) COLLATE "pg_catalog"."default",
  "sgdw" varchar(100) COLLATE "pg_catalog"."default",
  "jldw" varchar(100) COLLATE "pg_catalog"."default",
  "gldw" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "yhdw" varchar(100) COLLATE "pg_catalog"."default",
  "jgny" date,
  "dglx" varchar(100) COLLATE "pg_catalog"."default",
  "gylx" varchar(100) COLLATE "pg_catalog"."default",
  "bz" varchar(255) COLLATE "pg_catalog"."default",
  "sjtbzt" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "tbsj" timestamp(6) NOT NULL,
  "yskzjbz" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "kjxx" "public"."geometry"
)
;
COMMENT ON COLUMN "public"."dl_js_csdl"."bsm" IS '标识码';
COMMENT ON COLUMN "public"."dl_js_csdl"."xzqhdm" IS '行政区划代码';
COMMENT ON COLUMN "public"."dl_js_csdl"."dlmc" IS '道路名称';
COMMENT ON COLUMN "public"."dl_js_csdl"."dlqd" IS '道路起点';
COMMENT ON COLUMN "public"."dl_js_csdl"."dlzd" IS '道路终点';
COMMENT ON COLUMN "public"."dl_js_csdl"."dlzx" IS '道路走向';
COMMENT ON COLUMN "public"."dl_js_csdl"."dldj" IS '道路等级';
COMMENT ON COLUMN "public"."dl_js_csdl"."glfl" IS '管理分类';
COMMENT ON COLUMN "public"."dl_js_csdl"."yhdj" IS '养护等级';
COMMENT ON COLUMN "public"."dl_js_csdl"."dlcd" IS '道路长度';
COMMENT ON COLUMN "public"."dl_js_csdl"."dlkd" IS '道路宽度';
COMMENT ON COLUMN "public"."dl_js_csdl"."dlmj" IS '道路面积';
COMMENT ON COLUMN "public"."dl_js_csdl"."jsdw" IS '建设单位';
COMMENT ON COLUMN "public"."dl_js_csdl"."sjdw" IS '设计单位';
COMMENT ON COLUMN "public"."dl_js_csdl"."sgdw" IS '施工单位';
COMMENT ON COLUMN "public"."dl_js_csdl"."jldw" IS '监理单位';
COMMENT ON COLUMN "public"."dl_js_csdl"."gldw" IS '管理单位';
COMMENT ON COLUMN "public"."dl_js_csdl"."yhdw" IS '养护单位';
COMMENT ON COLUMN "public"."dl_js_csdl"."jgny" IS '竣工年月';
COMMENT ON COLUMN "public"."dl_js_csdl"."dglx" IS '灯杆类型';
COMMENT ON COLUMN "public"."dl_js_csdl"."gylx" IS '光源类型';
COMMENT ON COLUMN "public"."dl_js_csdl"."bz" IS '备注';
COMMENT ON COLUMN "public"."dl_js_csdl"."sjtbzt" IS '数据同步状态';
COMMENT ON COLUMN "public"."dl_js_csdl"."tbsj" IS '同步时间';
COMMENT ON COLUMN "public"."dl_js_csdl"."yskzjbz" IS '原始库主键标志';
COMMENT ON COLUMN "public"."dl_js_csdl"."kjxx" IS '空间信息';
COMMENT ON TABLE "public"."dl_js_csdl" IS '城市道路属性结构表';

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