programs_info/无锡市生命线项目/其他文件/第七批次修改数据库/industry_supervision_evaluate.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:03:50
*/


-- ----------------------------
-- Table structure for industry_supervision_evaluate
-- ----------------------------
DROP TABLE IF EXISTS "public"."industry_supervision_evaluate";
CREATE TABLE "public"."industry_supervision_evaluate" (
  "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "name" varchar(500) COLLATE "pg_catalog"."default",
  "national_rank" int8,
  "jiangsu_rank" int8,
  "wuxi_rank" int8,
  "rank_time" timestamp(6),
  "scene" varchar(50) COLLATE "pg_catalog"."default",
  "label" varchar(500) COLLATE "pg_catalog"."default",
  "annex" varchar(500) COLLATE "pg_catalog"."default",
  "release_time" timestamp(6),
  "state" varchar(50) COLLATE "pg_catalog"."default",
  "order_num" int8,
  "create_time" timestamp(6),
  "create_user" varchar(50) COLLATE "pg_catalog"."default",
  "update_time" timestamp(6),
  "update_user" varchar(50) COLLATE "pg_catalog"."default",
  "del_flag" int4 DEFAULT 1,
  "annexwuxi_rank" text COLLATE "pg_catalog"."default",
  "annexjiangsu_rank" text COLLATE "pg_catalog"."default",
  "annexnational_rank" text COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."id" IS '主键';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."name" IS '企业名称';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."national_rank" IS '全国排名';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."jiangsu_rank" IS '江苏省排名';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."wuxi_rank" IS '无锡市排名';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."rank_time" IS '排名统计时间';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."scene" IS '专项场景  燃气爆炸、城市内涝、供水爆管、第三方破坏、地下管线、桥梁倒塌、道路塌陷 ';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."label" IS '标签';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."annex" IS '附件';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."release_time" IS '发布时间';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."state" IS '发布状态 未发布:0  已发布:1';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."order_num" IS '排序';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."create_time" IS '数据创建日期';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."create_user" IS '数据创建人员';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."update_time" IS '数据更新日期';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."update_user" IS '数据更新人员';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."del_flag" IS '逻辑删除状态 无效：0 有效：1';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."annexwuxi_rank" IS '无锡附件';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."annexjiangsu_rank" IS '江苏附件';
COMMENT ON COLUMN "public"."industry_supervision_evaluate"."annexnational_rank" IS '全国附件';
COMMENT ON TABLE "public"."industry_supervision_evaluate" IS '行业监督-行业评价';

-- ----------------------------
-- Indexes structure for table industry_supervision_evaluate
-- ----------------------------
CREATE UNIQUE INDEX "industry_supervision_evaluate_id_idx" ON "public"."industry_supervision_evaluate" USING btree (
  "id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

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