programs_info/无锡市生命线项目/其他文件/第七批次修改数据库/zhjg_analysis_facility_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: 08/08/2024 15:35:01
*/


-- ----------------------------
-- Table structure for zhjg_analysis_facility_lifeline
-- ----------------------------
DROP TABLE IF EXISTS "public"."zhjg_analysis_facility_lifeline";
CREATE TABLE "public"."zhjg_analysis_facility_lifeline" (
  "id" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "owner2" varchar(500) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."zhjg_analysis_facility_lifeline"."owner2" IS '权属单位';
COMMENT ON TABLE "public"."zhjg_analysis_facility_lifeline" IS '基础设施表';

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