Página inicial Explorar Ajuda
Entrar
zhangtao
/
programs_info
Observar 1
Favorito 0
Fork 0
Arquivos Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
programs_info
/
无锡市生命线项目
/
其他文件
/
第七批次修改数据库
/
industry_supervision_scheme_node.sql

industry_supervision_scheme_node.sql 2.1 KB
Link permanente Histórico Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : pgsql政务测试2.22.195.139
    5. 

  5.  Source Server Type    : PostgreSQL
    6. 

  6.  Source Server Version : 140010
    7. 

  7.  Source Host           : 2.22.195.139:54321
    8. 

  8.  Source Catalog        : citylifeline_db
    9. 

  9.  Source Schema         : public
    10. 

  10. 

  11.  Target Server Type    : PostgreSQL
    12. 

  12.  Target Server Version : 140010
    13. 

  13.  File Encoding         : 65001
    14. 

  14. 

  15.  Date: 26/07/2024 13:07:12
    16. 

  16. */
    17. 

  17. 

  18. 

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

  20. -- Table structure for industry_supervision_scheme_node
    21. 

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

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

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

  24.   "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
    25. 

  25.   "supervision_scheme_id" varchar(64) COLLATE "pg_catalog"."default",
    26. 

  26.   "dept_name" varchar(500) COLLATE "pg_catalog"."default",
    27. 

  27.   "dept_id" varchar(500) COLLATE "pg_catalog"."default",
    28. 

  28.   "ya_node_name" varchar(64) COLLATE "pg_catalog"."default",
    29. 

  29.   "bz" varchar(500) COLLATE "pg_catalog"."default",
    30. 

  30.   "deleted" int4,
    31. 

  31.   "created_at" timestamp(6),
    32. 

  32.   "created_by" varchar(100) COLLATE "pg_catalog"."default",
    33. 

  33.   "updated_at" timestamp(6),
    34. 

  34.   "updated_by" varchar(100) COLLATE "pg_catalog"."default",
    35. 

  35.   "disposal_time" int4
    36. 

  36. )
    37. 

  37. ;
    38. 

  38. COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."supervision_scheme_id" IS '应急预案id';
    39. 

  39. COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."dept_name" IS '部门名称';
    40. 

  40. COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."dept_id" IS '部门id';
    41. 

  41. COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."ya_node_name" IS '预案节点';
    42. 

  42. COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."bz" IS '备注';
    43. 

  43. COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."disposal_time" IS '处置时间(分钟)';
    44. 

  44. COMMENT ON TABLE "public"."industry_supervision_scheme_node" IS '应急预案节点';
    45. 

  45. 

  46. -- ----------------------------
    47. 

  47. -- Primary Key structure for table industry_supervision_scheme_node
    48. 

  48. -- ----------------------------
    49. 

  49. ALTER TABLE "public"."industry_supervision_scheme_node" ADD CONSTRAINT "industry_supervision_scheme_node_pkey" PRIMARY KEY ("id");
    50. 

  50.