Inicio Explorar Axuda
Iniciar sesión
zhangtao
/
programs_info
Seguir 1
Destacar 0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Rama: master
Ramas Etiquetas
programs_info
/
无锡市生命线项目
/
其他文件
/
新增表
/
gs_jg_ljgwgzlsqk.sql

gs_jg_ljgwgzlsqk.sql 2.4 KB
Permalink Histórico Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 生命线前置数据库47.113.226.116
    5. 

  5.  Source Server Type    : PostgreSQL
    6. 

  6.  Source Server Version : 140009
    7. 

  7.  Source Host           : 47.113.226.116:5333
    8. 

  8.  Source Catalog        : citylifeline_db
    9. 

  9.  Source Schema         : public
    10. 

  10. 

  11.  Target Server Type    : PostgreSQL
    12. 

  12.  Target Server Version : 140009
    13. 

  13.  File Encoding         : 65001
    14. 

  14. 

  15.  Date: 27/11/2023 11:31:46
    16. 

  16. */
    17. 

  17. 

  18. 

  19. -- ----------------------------
    20. 

  20. -- Table structure for gs_jg_ljgwgzlsqk
    21. 

  21. -- ----------------------------
    22. 

  22. DROP TABLE IF EXISTS "public"."gs_jg_ljgwgzlsqk";
    23. 

  23. CREATE TABLE "public"."gs_jg_ljgwgzlsqk" (
    24. 

  24.   "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
    25. 

  25.   "xzqhdm" varchar(6) COLLATE "pg_catalog"."default" NOT NULL,
    26. 

  26.   "dnjhgzljgwzc" int4 NOT NULL,
    27. 

  27.   "ljgwygzcd" int4 NOT NULL,
    28. 

  28.   "ljgwgzzcd" int4 NOT NULL,
    29. 

  29.   "ljgwwgzcd" int4 NOT NULL,
    30. 

  30.   "bz" varchar(255) COLLATE "pg_catalog"."default",
    31. 

  31.   "yskzjbz" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
    32. 

  32.   "sjtbzt" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
    33. 

  33.   "tbsj" timestamp(6) NOT NULL,
    34. 

  34.   "ljgwzc" int4 NOT NULL,
    35. 

  35.   "nf" int4 NOT NULL
    36. 

  36. )
    37. 

  37. ;
    38. 

  38. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."bsm" IS '标识码';
    39. 

  39. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."xzqhdm" IS '行政区划代码';
    40. 

  40. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."dnjhgzljgwzc" IS '当年计划改造老旧管网总长';
    41. 

  41. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."ljgwygzcd" IS '老旧管网已改造长度';
    42. 

  42. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."ljgwgzzcd" IS '老旧管网改造中长度';
    43. 

  43. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."ljgwwgzcd" IS '老旧管网未改造长度';
    44. 

  44. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."bz" IS '备注';
    45. 

  45. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."yskzjbz" IS '原始库主键标志';
    46. 

  46. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."sjtbzt" IS '数据同步状态';
    47. 

  47. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."tbsj" IS '同步时间';
    48. 

  48. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."ljgwzc" IS '老旧管网总长';
    49. 

  49. COMMENT ON COLUMN "public"."gs_jg_ljgwgzlsqk"."nf" IS '年份';
    50. 

  50. COMMENT ON TABLE "public"."gs_jg_ljgwgzlsqk" IS '老旧管网改造落实情况属性结构表';
    51. 

  51. 

  52. -- ----------------------------
    53. 

  53. -- Primary Key structure for table gs_jg_ljgwgzlsqk
    54. 

  54. -- ----------------------------
    55. 

  55. ALTER TABLE "public"."gs_jg_ljgwgzlsqk" ADD CONSTRAINT "gs_jg_ljgwgzlsqk_pkey" PRIMARY KEY ("bsm");
    56. 

  56.