/*
 Navicat Premium Data Transfer

 Source Server         : pgsql政务测试2.22.195.139
 Source Server Type    : PostgreSQL
 Source Server Version : 140010
 Source Host           : 2.22.195.139:54321
 Source Catalog        : citylifeline_db
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 140010
 File Encoding         : 65001

 Date: 26/07/2024 13:07:12
*/


-- ----------------------------
-- Table structure for industry_supervision_scheme_node
-- ----------------------------
DROP TABLE IF EXISTS "public"."industry_supervision_scheme_node";
CREATE TABLE "public"."industry_supervision_scheme_node" (
  "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "supervision_scheme_id" varchar(64) COLLATE "pg_catalog"."default",
  "dept_name" varchar(500) COLLATE "pg_catalog"."default",
  "dept_id" varchar(500) COLLATE "pg_catalog"."default",
  "ya_node_name" varchar(64) COLLATE "pg_catalog"."default",
  "bz" varchar(500) COLLATE "pg_catalog"."default",
  "deleted" int4,
  "created_at" timestamp(6),
  "created_by" varchar(100) COLLATE "pg_catalog"."default",
  "updated_at" timestamp(6),
  "updated_by" varchar(100) COLLATE "pg_catalog"."default",
  "disposal_time" int4
)
;
COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."supervision_scheme_id" IS '应急预案id';
COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."dept_name" IS '部门名称';
COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."dept_id" IS '部门id';
COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."ya_node_name" IS '预案节点';
COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."bz" IS '备注';
COMMENT ON COLUMN "public"."industry_supervision_scheme_node"."disposal_time" IS '处置时间(分钟)';
COMMENT ON TABLE "public"."industry_supervision_scheme_node" IS '应急预案节点';

-- ----------------------------
-- Primary Key structure for table industry_supervision_scheme_node
-- ----------------------------
ALTER TABLE "public"."industry_supervision_scheme_node" ADD CONSTRAINT "industry_supervision_scheme_node_pkey" PRIMARY KEY ("id");