/* 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");