|
|
|
|
/*
|
|
|
|
|
Navicat Premium Data Transfer
|
|
|
|
|
|
|
|
|
|
Source Server : 10.8.30.160
|
|
|
|
|
Source Server Type : PostgreSQL
|
|
|
|
|
Source Server Version : 120001
|
|
|
|
|
Source Host : 10.8.30.160:30432
|
|
|
|
|
Source Catalog : jilin
|
|
|
|
|
Source Schema : public
|
|
|
|
|
|
|
|
|
|
Target Server Type : PostgreSQL
|
|
|
|
|
Target Server Version : 120001
|
|
|
|
|
File Encoding : 65001
|
|
|
|
|
|
|
|
|
|
Date: 16/08/2023 09:55:48
|
|
|
|
|
*/
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- ----------------------------
|
|
|
|
|
-- Table structure for flood_control_headquarters
|
|
|
|
|
-- ----------------------------
|
|
|
|
|
DROP TABLE IF EXISTS "public"."flood_control_headquarters";
|
|
|
|
|
CREATE TABLE "public"."flood_control_headquarters" (
|
|
|
|
|
"id" serial PRIMARY KEY,
|
|
|
|
|
"name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
|
|
|
|
|
"location" varchar(255) COLLATE "pg_catalog"."default",
|
|
|
|
|
"dike_length" varchar(255) COLLATE "pg_catalog"."default",
|
|
|
|
|
"commander" varchar(255) COLLATE "pg_catalog"."default"
|
|
|
|
|
)
|
|
|
|
|
;
|
|
|
|
|
COMMENT ON COLUMN "public"."flood_control_headquarters"."id" IS '序号';
|
|
|
|
|
COMMENT ON COLUMN "public"."flood_control_headquarters"."name" IS '名称';
|
|
|
|
|
COMMENT ON COLUMN "public"."flood_control_headquarters"."location" IS '设立地点';
|
|
|
|
|
COMMENT ON COLUMN "public"."flood_control_headquarters"."dike_length" IS '管辖堤长';
|
|
|
|
|
COMMENT ON COLUMN "public"."flood_control_headquarters"."commander" IS '指挥';
|
|
|
|
|
|
|
|
|
|
-- ----------------------------
|
|
|
|
|
-- Records of flood_control_headquarters
|
|
|
|
|
-- ----------------------------
|
|
|
|
|
INSERT INTO "public"."flood_control_headquarters" VALUES (1, '象湖防汛分指挥部', '莲塘镇人民政府', '106379 米', '李 碧、葛 苗、龚芦花');
|
|
|
|
|
INSERT INTO "public"."flood_control_headquarters" VALUES (2, '抚河分洪区防汛分指挥部', '向塘镇人民政府', '130950 米', '皮 钧、吴桂珍、万耀华、魏松林');
|
|
|
|
|
INSERT INTO "public"."flood_control_headquarters" VALUES (3, '南新联圩防汛分指挥部', '南新联圩分中心', '57070 米', '万向阳、刘 玉、涂 超、段 毅');
|
|
|
|
|
INSERT INTO "public"."flood_control_headquarters" VALUES (4, '塔城防汛分指挥部', '塔城乡人民政府', '64129 米', '邬春华、王光华、江振国');
|
|
|
|
|
INSERT INTO "public"."flood_control_headquarters" VALUES (5, '蒋巷联圩防汛分指挥部', '蒋巷联圩分中心', '95070 米', '张秉公、黄华明、郭朝辉、梁文杰');
|
|
|
|
|
INSERT INTO "public"."flood_control_headquarters" VALUES (6, '赣东大堤防汛分指挥部', '赣东大堤分中心', '43166 米', '胡朝辉、伍 曦、汪 芳');
|
|
|
|
|
INSERT INTO "public"."flood_control_headquarters" VALUES (7, '抚西大堤防汛分指挥部', '抚西大堤分中心', '41314 米', '熊健俊、万卫国、吴 晶');
|
|
|
|
|
INSERT INTO "public"."flood_control_headquarters" VALUES (8, '塘南防汛分指挥部', '塘南镇水管站', '31814 米', '付向宇、陈 欣、涂相鸿、刘龙军');
|
|
|
|
|
INSERT INTO "public"."flood_control_headquarters" VALUES (9, '泾口防汛分指挥部', '长乐联圩分中心', '68563 米', '易才宏、黄炳锋、万家平');
|
|
|
|
|
|
