programs_info/无锡市生命线项目/其他文件/新增表/ql_js_ql.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:31:57
*/


-- ----------------------------
-- Table structure for ql_js_ql
-- ----------------------------
DROP TABLE IF EXISTS "public"."ql_js_ql";
CREATE TABLE "public"."ql_js_ql" (
  "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "xzqhdm" varchar(6) COLLATE "pg_catalog"."default",
  "qlmc" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "jgny" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "szdlmc" varchar(32) COLLATE "pg_catalog"."default",
  "dldj" int4 NOT NULL,
  "kjfl" int4 NOT NULL,
  "jglx" int4 NOT NULL,
  "kjzh" varchar(500) COLLATE "pg_catalog"."default",
  "qlzc" numeric(12,2),
  "qlzk" numeric(8,2),
  "kydw" int4 NOT NULL,
  "thdj" int4 NOT NULL,
  "sfdzd" bool NOT NULL,
  "qmmj" numeric(12,2),
  "kzld" int4 NOT NULL,
  "yhlb" int4 NOT NULL,
  "yhdj" int4 NOT NULL,
  "qlwhzk" varchar(8) COLLATE "pg_catalog"."default",
  "qljgzk" varchar(8) COLLATE "pg_catalog"."default",
  "jcrq" date,
  "jcbg" bytea 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" NOT NULL,
  "sfjggz" bool NOT NULL,
  "sfyjjcxt" bool 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"."ql_js_ql"."bsm" IS '标识码';
COMMENT ON COLUMN "public"."ql_js_ql"."xzqhdm" IS '行政区划代码';
COMMENT ON COLUMN "public"."ql_js_ql"."qlmc" IS '桥梁名称';
COMMENT ON COLUMN "public"."ql_js_ql"."jgny" IS '竣工年月';
COMMENT ON COLUMN "public"."ql_js_ql"."szdlmc" IS '所在道路名称';
COMMENT ON COLUMN "public"."ql_js_ql"."dldj" IS '道路等级';
COMMENT ON COLUMN "public"."ql_js_ql"."kjfl" IS '跨径分类';
COMMENT ON COLUMN "public"."ql_js_ql"."jglx" IS '结构类型';
COMMENT ON COLUMN "public"."ql_js_ql"."kjzh" IS '跨径组合';
COMMENT ON COLUMN "public"."ql_js_ql"."qlzc" IS '桥梁总长';
COMMENT ON COLUMN "public"."ql_js_ql"."qlzk" IS '桥梁总宽';
COMMENT ON COLUMN "public"."ql_js_ql"."kydw" IS '跨越地物';
COMMENT ON COLUMN "public"."ql_js_ql"."thdj" IS '通航等级';
COMMENT ON COLUMN "public"."ql_js_ql"."sfdzd" IS '是否独柱墩';
COMMENT ON COLUMN "public"."ql_js_ql"."qmmj" IS '桥面面积';
COMMENT ON COLUMN "public"."ql_js_ql"."kzld" IS '抗震烈度';
COMMENT ON COLUMN "public"."ql_js_ql"."yhlb" IS '养护类别';
COMMENT ON COLUMN "public"."ql_js_ql"."yhdj" IS '养护等级';
COMMENT ON COLUMN "public"."ql_js_ql"."qlwhzk" IS '桥梁完好状况';
COMMENT ON COLUMN "public"."ql_js_ql"."qljgzk" IS '桥梁结构状况';
COMMENT ON COLUMN "public"."ql_js_ql"."jcrq" IS '检测日期';
COMMENT ON COLUMN "public"."ql_js_ql"."jcbg" IS '检测报告';
COMMENT ON COLUMN "public"."ql_js_ql"."jsdw" IS '建设单位';
COMMENT ON COLUMN "public"."ql_js_ql"."sjdw" IS '设计单位';
COMMENT ON COLUMN "public"."ql_js_ql"."sgdw" IS '施工单位';
COMMENT ON COLUMN "public"."ql_js_ql"."jldw" IS '监理单位';
COMMENT ON COLUMN "public"."ql_js_ql"."gldw" IS '管理单位';
COMMENT ON COLUMN "public"."ql_js_ql"."yhdw" IS '养护单位';
COMMENT ON COLUMN "public"."ql_js_ql"."sfjggz" IS '是否加固改造';
COMMENT ON COLUMN "public"."ql_js_ql"."sfyjjcxt" IS '是否已建监测系统';
COMMENT ON COLUMN "public"."ql_js_ql"."bz" IS '备注';
COMMENT ON COLUMN "public"."ql_js_ql"."yskzjbz" IS '原始库主键标志';
COMMENT ON COLUMN "public"."ql_js_ql"."sjtbzt" IS '数据同步状态';
COMMENT ON COLUMN "public"."ql_js_ql"."tbsj" IS '同步时间';
COMMENT ON COLUMN "public"."ql_js_ql"."kjxx" IS '空间信息';
COMMENT ON TABLE "public"."ql_js_ql" IS '桥梁属性结构表';

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