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


-- ----------------------------
-- Table structure for gs_jg_ljgwgzlsqk
-- ----------------------------
DROP TABLE IF EXISTS "public"."gs_jg_ljgwgzlsqk";
CREATE TABLE "public"."gs_jg_ljgwgzlsqk" (
  "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "xzqhdm" varchar(6) COLLATE "pg_catalog"."default" NOT NULL,
  "dnjhgzljgwzc" int4 NOT NULL,
  "ljgwygzcd" int4 NOT NULL,
  "ljgwgzzcd" int4 NOT NULL,
  "ljgwwgzcd" int4 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,
  "ljgwzc" int4 NOT NULL,
  "nf" int4 NOT NULL
)
;
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."bsm" IS '标识码';
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."xzqhdm" IS '行政区划代码';
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."dnjhgzljgwzc" IS '当年计划改造老旧管网总长';
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."ljgwygzcd" IS '老旧管网已改造长度';
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."ljgwgzzcd" IS '老旧管网改造中长度';
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."ljgwwgzcd" IS '老旧管网未改造长度';
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."bz" IS '备注';
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."yskzjbz" IS '原始库主键标志';
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."sjtbzt" IS '数据同步状态';
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."tbsj" IS '同步时间';
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."ljgwzc" IS '老旧管网总长';
COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."nf" IS '年份';
COMMENT ON TABLE "public"."gs_jg_ljgwgzlsqk" IS '老旧管网改造落实情况属性结构表';

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