You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
224 lines
21 KiB
224 lines
21 KiB
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : shuili
|
|
Source Server Type : MySQL
|
|
Source Server Version : 50738
|
|
Source Host : rm-7xv36ek6qb84h9utmfo.mysql.rds.aliyuncs.com:3333
|
|
Source Schema : sgc_yg
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 50738
|
|
File Encoding : 65001
|
|
|
|
Date: 18/01/2024 11:23:26
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for bs_sgc_df_gcgl
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `bs_sgc_df_gcgl`;
|
|
CREATE TABLE `bs_sgc_df_gcgl` (
|
|
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
|
`DIKE_CODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '堤防编码',
|
|
`ENGINEERING_MANAGEMENT_UNIT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位',
|
|
`MANAGEMENT_UNIT_NATURE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位性质',
|
|
`ENGINEERING_MANAGEMENT_OWNERSHIP` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位权属',
|
|
`ENGINEERING_MANAGEMENT_PERSON` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位责任人',
|
|
`ENGINEERING_MANAGEMENT_POSITION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位责任人职务',
|
|
`ENGINEERING_MANAGEMENT_PHONE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位责任人手机号码',
|
|
`WATER_ADMINISTRATIVE_DEPARTMENT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '水行政主管部门',
|
|
`ADMINISTRATION_DEPARTMENT_NATURE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '水行政主管部门性质',
|
|
`ADMINISTRATION_DEPARTMENT_PERSON` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`ADMINISTRATION_DEPARTMENT_POSITION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`ADMINISTRATION_DEPARTMENT_PHONE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`CENTRALIZED_MANAGEMENT_DEPARTMENT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '行业归口管理部门',
|
|
`MANAGEMENT_DELIMITATION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '管理范围划界',
|
|
`DELIMITATION_TIME` datetime(0) NULL DEFAULT NULL COMMENT '完成时间',
|
|
`DELIMITATION_EVIDENCE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '证明材料',
|
|
`MANAGEMENT_CONFIRMATION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '管理范围确权',
|
|
`CONFIRMATION_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`CONFIRMATION_EVIDENCE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`PROTECTION_DELIMITATION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '保护范围划界',
|
|
`PROTECTION_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`PROTECTION_EVIDENCE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`GATE_OPERATING_PROCEDURES` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '闸门操作规程',
|
|
`WATER_GATE_CONTROL_OPERATION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '水闸控制运用计划(方案)批复文件',
|
|
`ENGINEERING_COMPLETION_ACCEPTANCE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程竣工验收鉴定书',
|
|
`ENGINEERING_CHART` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程图表',
|
|
`ENGINEERING_PANORAMIC_PHOTOS` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工程全景照片',
|
|
`APPROVAL_DOCUMENTS_DOWNGRADE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '降等批复文件',
|
|
`CREATE_UID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`UPDATE_UID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`CREATE_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`UPDATE_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`PRO_CODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`PRO_NO` int(11) NULL DEFAULT NULL,
|
|
`REMARK` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`OWER_DEPT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`RELATIONS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`EFF_DATE` datetime(0) NULL DEFAULT NULL COMMENT '记录生效时间',
|
|
`EXPR_DATE` datetime(0) NULL DEFAULT NULL COMMENT '记录失效时间',
|
|
`monitoring_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '监控类型',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '堤防工程管理信息' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for bs_sgc_df_jbxx
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `bs_sgc_df_jbxx`;
|
|
CREATE TABLE `bs_sgc_df_jbxx` (
|
|
`ID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
|
|
`DIKE_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '堤防名称',
|
|
`ADCD_START` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '起点行政区划',
|
|
`DIKE_CODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '堤防编码',
|
|
`PLOT_EMBANKMENTS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标绘堤防',
|
|
`ADCD_END` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '终点行政区划',
|
|
`DIKE_START_NUM` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '起点桩号',
|
|
`DIKE_END_NUM` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '终点桩号',
|
|
`DIKE_TYPE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '堤防类型',
|
|
`IS_FLOOD_STORAGE_DETENTION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为蓄滞洪区堤防',
|
|
`STORAGE_DETENTION_AREA_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在蓄滞洪区名称',
|
|
`AREA_STARTING_STATION_NUMBER` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`AREA_END_STATION_NUMBER` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`TOTAL_LENGTH_FLOOD_STORAGE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '堤防蓄滞洪区段总长度(m)',
|
|
`FLOOD_STORAGE_DETENTION_AREAS_EXPLANATION` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '蓄滞洪区特殊情况说明',
|
|
`CROSS_BORDER_SITUATION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '堤防跨界情况',
|
|
`DIKE_PATT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '堤防型式',
|
|
`COMP_DATE` datetime(0) NULL DEFAULT NULL COMMENT '建成时间',
|
|
`RECENT_COMPLIANCE_REINFORCEMENT_STATUS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最近达标加固完工状态',
|
|
`RECENT_COMPLIANCE_REINFORCEMENT_TIME` datetime(0) NULL DEFAULT NULL COMMENT '最近达标加固完成时间',
|
|
`ENG_TASK` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程任务',
|
|
`DIKE_GRAD` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '堤防级别',
|
|
`DESIGN_FLOOD_CONTROL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设计防洪（潮）标准[重现期（年）]',
|
|
`DIKE_LEN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '堤防长度(m)',
|
|
`PLANNING_FLOOD_CONTROL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规划防洪（潮）标准[重现期（年）]',
|
|
`EMBANKMENT_LENGTH_PLANNING_STANDARDS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '达到规划标准的堤防长度(m)',
|
|
`POPULATION_PROTECTION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '保护人口（单位：万人）',
|
|
`PROTECTING_FARMLAND` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '保护农田（单位：万亩）',
|
|
`CRITICAL_INFRASTRUCTURE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '重要基础设施',
|
|
`CREATE_UID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`UPDATE_UID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`CREATE_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`UPDATE_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`PRO_CODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`PRO_NO` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`OWER_DEPT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`REMARK` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`RELATIONS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联字段1',
|
|
`EFF_DATE` datetime(0) NULL DEFAULT NULL COMMENT '记录生效时间',
|
|
`EXPR_DATE` datetime(0) NULL DEFAULT NULL COMMENT '记录失效时间',
|
|
`adcd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '行政区划',
|
|
`river_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在河流',
|
|
`riverside_classification` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '河流岸别',
|
|
`lake_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在湖泊名称',
|
|
`coastline_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在海岸名称',
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '堤防基本信息' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for bs_sgc_sz_gcgl
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `bs_sgc_sz_gcgl`;
|
|
CREATE TABLE `bs_sgc_sz_gcgl` (
|
|
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
|
`WAGA_CODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '水闸编码',
|
|
`ENGINEERING_MANAGEMENT_UNIT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位',
|
|
`MANAGEMENT_UNIT_NATURE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位性质',
|
|
`ENGINEERING_MANAGEMENT_OWNERSHIP` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位权属',
|
|
`ENGINEERING_MANAGEMENT_PERSON` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位责任人',
|
|
`ENGINEERING_MANAGEMENT_POSITION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位责任人职务',
|
|
`ENGINEERING_MANAGEMENT_PHONE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程管理单位责任人手机号码',
|
|
`WATER_ADMINISTRATIVE_DEPARTMENT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '水行政主管部门',
|
|
`ADMINISTRATION_DEPARTMENT_NATURE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '水行政主管部门性质',
|
|
`ADMINISTRATION_DEPARTMENT_PERSON` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`ADMINISTRATION_DEPARTMENT_POSITION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`ADMINISTRATION_DEPARTMENT_PHONE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`CENTRALIZED_MANAGEMENT_DEPARTMENT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '行业归口管理部门',
|
|
`MANAGEMENT_DELIMITATION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '管理范围划界',
|
|
`DELIMITATION_TIME` datetime(0) NULL DEFAULT NULL COMMENT '完成时间',
|
|
`DELIMITATION_EVIDENCE` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '证明材料',
|
|
`MANAGEMENT_CONFIRMATION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '管理范围确权',
|
|
`CONFIRMATION_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`CONFIRMATION_EVIDENCE` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
|
|
`PROTECTION_DELIMITATION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '保护范围划界',
|
|
`PROTECTION_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`PROTECTION_EVIDENCE` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
|
|
`GATE_OPERATING_PROCEDURES` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '闸门操作规程',
|
|
`WATER_GATE_CONTROL_OPERATION` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '水闸控制运用计划(方案)批复文件',
|
|
`ENGINEERING_COMPLETION_ACCEPTANCE` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工程竣工验收鉴定书',
|
|
`ENGINEERING_CHART` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工程图表',
|
|
`ENGINEERING_PANORAMIC_PHOTOS` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工程全景照片',
|
|
`APPROVAL_DOCUMENTS_DOWNGRADE` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '降等批复文件',
|
|
`CREATE_UID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`UPDATE_UID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`CREATE_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`UPDATE_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`PRO_CODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`PRO_NO` int(11) NULL DEFAULT NULL,
|
|
`REMARK` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`OWER_DEPT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`RELATIONS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`EFF_DATE` datetime(0) NULL DEFAULT NULL COMMENT '记录生效时间',
|
|
`EXPR_DATE` datetime(0) NULL DEFAULT NULL COMMENT '记录失效时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '水闸工程管理信息' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for bs_sgc_sz_jbxx
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `bs_sgc_sz_jbxx`;
|
|
CREATE TABLE `bs_sgc_sz_jbxx` (
|
|
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
|
`WAGA_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '水闸名称',
|
|
`adcd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '行政区划',
|
|
`WAGA_CODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '水闸编码',
|
|
`WAGA_LOC` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在位置',
|
|
`plotting_sluice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标绘水闸',
|
|
`ACCEPTANCE_STATUS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '验收情况',
|
|
`RISK_ELIMINATION_STATUS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '除险加固情况',
|
|
`IS_HUB_PROJECT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为枢纽工程',
|
|
`IS_GATE_STATION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为闸站工程',
|
|
`IS_SET_GATE_PROJECT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为套闸工程',
|
|
`WAGA_TYPE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '水闸类型',
|
|
`DSLCFL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设计过闸流量（m³/s）',
|
|
`CHLCFL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '校核过闸流量（m³/s）',
|
|
`ENG_SCAL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工程规模',
|
|
`MAIN_BUILD_GRAD` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '建筑物级别',
|
|
`DSRCIN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设计标准[重现期（年）]',
|
|
`CHRCIN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '校核标准[重现期（年）]',
|
|
`HISTORICAL_MAXIMUM_GATE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '历史最大过闸流量(m³/s)',
|
|
`HISTORICAL_MAXIMUM_DATE` datetime(0) NULL DEFAULT NULL COMMENT '历史最大过闸流量日期',
|
|
`DESIGN_SEISMIC_INTENSITY` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设计地震烈度',
|
|
`GAOR_NUM` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '闸孔数量',
|
|
`GAOR_TOT_NET_WID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '闸孔总净宽(m)',
|
|
`GTST` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '闸门型式',
|
|
`HOISTS_NUMBER` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '启闭机数量',
|
|
`OBSERVATION_PROJECT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '观测项目',
|
|
`LOCK_CHAMBER_STRUCTURE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '闸室结构',
|
|
`MACHINE_FORM` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '启闭机形式',
|
|
`ENDSST` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消能方式',
|
|
`AUTOMATION_CONTROL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '自动化控制',
|
|
`CREATE_UID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`UPDATE_UID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`CREATE_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`UPDATE_TIME` datetime(0) NULL DEFAULT NULL,
|
|
`PRO_NO` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`PRO_CODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`RELATION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联字段1',
|
|
`COMPLETION_TIME` datetime(0) NULL DEFAULT NULL COMMENT '建成时间',
|
|
`COMPLETION_ACCEPTANCE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '竣工验收时间',
|
|
`RECENT_COMPLETION_TIME` datetime(0) NULL DEFAULT NULL COMMENT '最近除险加固完工时间',
|
|
`HUB_BUILDINGS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '枢纽建筑物',
|
|
`AUXILIARY_GATE_HOLES` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '副闸闸孔数量',
|
|
`AUXILIARY_GATE_HOLES_WIDTH` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '副闸闸孔总净宽',
|
|
`EFF_DATE` datetime(0) NULL DEFAULT NULL COMMENT '记录生效时间',
|
|
`EXPR_DATE` datetime(0) NULL DEFAULT NULL COMMENT '记录失效时间',
|
|
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '水闸工程基础信息' ROW_FORMAT = Dynamic;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
|