Etusivu Tutki Apua
Kirjaudu sisään
zhangtao
/
programs_info
Tarkkaile 1
Äänestä 0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Branch: master
Branchit Tagit
programs_info
/
无锡市生命线项目
/
其他文件
/
新增表
/
ps_js_zyhd.sql

ps_js_zyhd.sql 2.6 KB
Pysyvä linkki Historia Raaka

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364 
  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:13
    16. 

  16. */
    17. 

  17. 

  18. 

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

  20. -- Table structure for ps_js_zyhd
    21. 

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

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

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

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

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

  26.   "hdbm" varchar(32) COLLATE "pg_catalog"."default",
    27. 

  27.   "hlmc" varchar(20) COLLATE "pg_catalog"."default" NOT NULL,
    28. 

  28.   "hdcd" numeric(11,3) NOT NULL,
    29. 

  29.   "qdzhbm" varchar(17) COLLATE "pg_catalog"."default" NOT NULL,
    30. 

  30.   "zdzhbm" varchar(17) COLLATE "pg_catalog"."default" NOT NULL,
    31. 

  31.   "qdhdbg" numeric(10,3),
    32. 

  32.   "zdhdbg" numeric(10,3),
    33. 

  33.   "csw" numeric(8,2),
    34. 

  34.   "jjsw" numeric(8,2),
    35. 

  35.   "bz" varchar(255) COLLATE "pg_catalog"."default",
    36. 

  36.   "yskzjbz" varchar(64) COLLATE "pg_catalog"."default",
    37. 

  37.   "sjtbzt" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
    38. 

  38.   "tbsj" timestamp(6) NOT NULL,
    39. 

  39.   "kjxx" "public"."geometry"
    40. 

  40. )
    41. 

  41. ;
    42. 

  42. COMMENT ON COLUMN "public"."ps_js_zyhd"."bsm" IS '标识码';
    43. 

  43. COMMENT ON COLUMN "public"."ps_js_zyhd"."xzqhdm" IS '行政区划代码';
    44. 

  44. COMMENT ON COLUMN "public"."ps_js_zyhd"."hdbm" IS '河道编码';
    45. 

  45. COMMENT ON COLUMN "public"."ps_js_zyhd"."hlmc" IS '河流名称';
    46. 

  46. COMMENT ON COLUMN "public"."ps_js_zyhd"."hdcd" IS '河段长度';
    47. 

  47. COMMENT ON COLUMN "public"."ps_js_zyhd"."qdzhbm" IS '起点桩号编码';
    48. 

  48. COMMENT ON COLUMN "public"."ps_js_zyhd"."zdzhbm" IS '终点桩号编码';
    49. 

  49. COMMENT ON COLUMN "public"."ps_js_zyhd"."qdhdbg" IS '起点河底标高';
    50. 

  50. COMMENT ON COLUMN "public"."ps_js_zyhd"."zdhdbg" IS '终点河底标高';
    51. 

  51. COMMENT ON COLUMN "public"."ps_js_zyhd"."csw" IS '常水位';
    52. 

  52. COMMENT ON COLUMN "public"."ps_js_zyhd"."jjsw" IS '警戒水位';
    53. 

  53. COMMENT ON COLUMN "public"."ps_js_zyhd"."bz" IS '备注';
    54. 

  54. COMMENT ON COLUMN "public"."ps_js_zyhd"."yskzjbz" IS '原始库主键标志';
    55. 

  55. COMMENT ON COLUMN "public"."ps_js_zyhd"."sjtbzt" IS '数据同步状态';
    56. 

  56. COMMENT ON COLUMN "public"."ps_js_zyhd"."tbsj" IS '同步时间';
    57. 

  57. COMMENT ON COLUMN "public"."ps_js_zyhd"."kjxx" IS '空间信息';
    58. 

  58. COMMENT ON TABLE "public"."ps_js_zyhd" IS '主要河道属性结构表';
    59. 

  59. 

  60. -- ----------------------------
    61. 

  61. -- Primary Key structure for table ps_js_zyhd
    62. 

  62. -- ----------------------------
    63. 

  63. ALTER TABLE "public"."ps_js_zyhd" ADD CONSTRAINT "ps_js_zyhd_pkey" PRIMARY KEY ("bsm");
    64. 

  64.