programs_info/无锡市生命线项目/其他文件/第七批次修改数据库/warning_info_lifeline.sql

/*
 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:02:04
*/


-- ----------------------------
-- Table structure for warning_info_lifeline
-- ----------------------------
DROP TABLE IF EXISTS "public"."warning_info_lifeline";
CREATE TABLE "public"."warning_info_lifeline" (
  "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "warning_type_lifeline" varchar(100) COLLATE "pg_catalog"."default",
  "warning_rank_lifeline" varchar(16) COLLATE "pg_catalog"."default",
  "associated_plan_lifeline" text COLLATE "pg_catalog"."default",
  "remark" varchar(255) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."warning_info_lifeline"."warning_type_lifeline" IS '预警类型';
COMMENT ON COLUMN "public"."warning_info_lifeline"."warning_rank_lifeline" IS '预警级别 1一级、2二级、3三级、4四级(通用_JCYJ_YJJB_DM)';
COMMENT ON COLUMN "public"."warning_info_lifeline"."associated_plan_lifeline" IS '关联预案';
COMMENT ON COLUMN "public"."warning_info_lifeline"."remark" IS '备注';
COMMENT ON TABLE "public"."warning_info_lifeline" IS '预警管理表(平台设置预警类型,预警级别,关联预案)';

-- ----------------------------
-- Table structure for public_report_hidden_trouble_lifeline
-- ----------------------------
DROP TABLE IF EXISTS "public"."public_report_hidden_trouble_lifeline";
CREATE TABLE "public"."public_report_hidden_trouble_lifeline" (
  "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "scene" varchar(16) COLLATE "pg_catalog"."default",
  "area" varchar(16) COLLATE "pg_catalog"."default",
  "hidden_trouble_name" varchar(500) COLLATE "pg_catalog"."default",
  "report_type" varchar(16) COLLATE "pg_catalog"."default",
  "hidden_trouble_description" varchar(2000) COLLATE "pg_catalog"."default",
  "hidden_trouble_address" varchar(500) COLLATE "pg_catalog"."default",
  "hidden_trouble_grade" varchar(16) COLLATE "pg_catalog"."default",
  "find_time" timestamp(6),
  "report_unit" varchar(200) COLLATE "pg_catalog"."default",
  "report_people" varchar(32) COLLATE "pg_catalog"."default",
  "report_people_tel" varchar(32) COLLATE "pg_catalog"."default",
  "scene_photo" text COLLATE "pg_catalog"."default",
  "dispose_progress" varchar(16) COLLATE "pg_catalog"."default",
  "dispose_unit" varchar(200) COLLATE "pg_catalog"."default",
  "dispose_people" varchar(32) COLLATE "pg_catalog"."default",
  "dispose_people_tel" varchar(32) COLLATE "pg_catalog"."default",
  "dispose_finish_time" timestamp(6),
  "remark" varchar(500) COLLATE "pg_catalog"."default",
  "dispose_photo" text COLLATE "pg_catalog"."default",
  "defined" int4,
  "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",
  "geom_data" "public"."geometry"
)
;
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."scene" IS '专项场景';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."area" IS '行政区划';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."hidden_trouble_name" IS '隐患名称';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."report_type" IS '上报类型';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."hidden_trouble_description" IS '隐患描述';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."hidden_trouble_address" IS '隐患地址';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."hidden_trouble_grade" IS '隐患等级 0-I级、1-II级、2-III级、3-IV级(备用)';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."find_time" IS '发现时间';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."report_unit" IS '上报单位(备用)';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."report_people" IS '上报人员';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."report_people_tel" IS '人员联系电话';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."scene_photo" IS '现场照片';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."dispose_progress" IS '处置进度 0未处置、1处置中、2已完成';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."dispose_unit" IS '处置单位';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."dispose_people" IS '处置负责人';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."dispose_people_tel" IS '负责人联系电话';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."dispose_finish_time" IS '处置完成时间';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."remark" IS '备注 ';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."dispose_photo" IS '处置照片';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."defined" IS '是否自定义(备用)';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."deleted" IS '是否删除';
COMMENT ON COLUMN "public"."public_report_hidden_trouble_lifeline"."geom_data" IS '空间信息(备用)';
COMMENT ON TABLE "public"."public_report_hidden_trouble_lifeline" IS '公众上报的隐患';

-- ----------------------------
-- Table structure for industry_supervision_plan_lifeline
-- ----------------------------
DROP TABLE IF EXISTS "public"."industry_supervision_plan_lifeline";
CREATE TABLE "public"."industry_supervision_plan_lifeline" (
  "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "project_progress" int4,
  "project_progress_description" varchar(1024) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."industry_supervision_plan_lifeline"."id" IS '主键';
COMMENT ON COLUMN "public"."industry_supervision_plan_lifeline"."project_progress" IS '项目进度0-100的值';
COMMENT ON COLUMN "public"."industry_supervision_plan_lifeline"."project_progress_description" IS '项目进度描述';
COMMENT ON TABLE "public"."industry_supervision_plan_lifeline" IS '行业监督-规划建设(平台设置部分)';

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

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

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