From fe2eef140ed049409555c20b8e55d0a106fea95a Mon Sep 17 00:00:00 2001
From: dengzedong <dengzedong@email>
Date: 星期五, 27 六月 2025 13:47:31 +0800
Subject: [PATCH] 影响因素20 sql
---
ansteel-biz/db/mysql.sql | 430 ++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 391 insertions(+), 39 deletions(-)
diff --git a/ansteel-biz/db/mysql.sql b/ansteel-biz/db/mysql.sql
index 7dfe3eb..a5e3e70 100644
--- a/ansteel-biz/db/mysql.sql
+++ b/ansteel-biz/db/mysql.sql
@@ -250,6 +250,22 @@
ALTER TABLE `t_power_net_factor`
ADD COLUMN `node_code` varchar(50) NULL DEFAULT NULL COMMENT '节点编号';
+ALTER TABLE `t_power_net_factor`
+ ADD COLUMN `cur_a` varchar(50) NULL DEFAULT NULL COMMENT '当前电流' AFTER `node_name`;
+
+ALTER TABLE `t_power_net_factor`
+ ADD COLUMN `p_limit_l` decimal(9, 3) NULL DEFAULT NULL COMMENT '有功下限';
+ALTER TABLE `t_power_net_factor`
+ ADD COLUMN `p_limit_h` decimal(9, 3) NULL DEFAULT NULL COMMENT '有功上限';
+ALTER TABLE `t_power_net_factor`
+ ADD COLUMN `q_limit_l` varchar(50) NULL DEFAULT NULL COMMENT '无功下限';
+ALTER TABLE `t_power_net_factor`
+ ADD COLUMN `q_limit_h` varchar(50) NULL DEFAULT NULL COMMENT '无功上限';
+ALTER TABLE `t_power_net_factor`
+ ADD COLUMN `cos_limit_l` varchar(50) NULL DEFAULT NULL COMMENT '功率因数下限';
+ALTER TABLE `t_power_net_factor`
+ ADD COLUMN `cos_limit_h` varchar(50) NULL DEFAULT NULL COMMENT '功率因数上限';
+
-- ----------------------------
-- 电力功率因数-发电机组实时状态
-- ----------------------------
@@ -311,7 +327,7 @@
`id` varchar(36) NOT NULL COMMENT 'id',
`det_id` varchar(36) NULL DEFAULT NULL COMMENT '详情ID',
`name` varchar(50) NULL DEFAULT NULL COMMENT '电容器名称',
- `status` varchar(50) NULL DEFAULT NULL COMMENT '状态',
+ `status` int NULL DEFAULT NULL COMMENT '状态',
`content` varchar(50) NULL DEFAULT NULL COMMENT '内容',
`remark` varchar(50) NULL DEFAULT NULL COMMENT '备注',
`create_date` datetime COMMENT '创建时间',
@@ -544,38 +560,82 @@
-- 焦化工序-影响因数偏差值
-- ----------------------------
DROP TABLE IF EXISTS `t_coking_trace_deviation`;
-CREATE TABLE `t_coking_trace_deviation`
-(
- `id` varchar(36) NOT NULL COMMENT 'id',
- `rel_id` varchar(36) NULL DEFAULT NULL COMMENT '关联ID',
- `process` varchar(20) NULL DEFAULT NULL COMMENT '工序名称',
- `sug_obj` varchar(20) NULL DEFAULT NULL COMMENT '建议对象',
- `clock` varchar(20) NULL DEFAULT NULL COMMENT '查询时间',
- `ind1_name` varchar(20) NULL DEFAULT NULL COMMENT '一级指标-偏差值-名称',
- `ind1_value` varchar(20) NULL DEFAULT NULL COMMENT '一级指标-偏差值-值',
- `ind1_unit` varchar(20) NULL DEFAULT NULL COMMENT '一级指标-偏差值-单位',
- `ind2_name` varchar(20) NULL DEFAULT NULL COMMENT '二级指标-偏差值-名称',
- `ind2_value` varchar(20) NULL DEFAULT NULL COMMENT '二级指标-偏差值-值',
- `ind2_unit` varchar(20) NULL DEFAULT NULL COMMENT '二级指标-偏差值-单位',
- `fac1_name` varchar(20) NULL DEFAULT NULL COMMENT '影响因素1-偏差值-名称',
- `fac1_value` varchar(20) NULL DEFAULT NULL COMMENT '影响因素1-偏差值-值',
- `fac1_unit` varchar(20) NULL DEFAULT NULL COMMENT '影响因素1-偏差值-单位',
- `fac2_name` varchar(20) NULL DEFAULT NULL COMMENT '影响因素2-偏差值-名称',
- `fac2_value` varchar(20) NULL DEFAULT NULL COMMENT '影响因素2-偏差值-值',
- `fac2_unit` varchar(20) NULL DEFAULT NULL COMMENT '影响因素2-偏差值-单位',
- `fac3_name` varchar(20) NULL DEFAULT NULL COMMENT '影响因素3-偏差值-名称',
- `fac3_value` varchar(20) NULL DEFAULT NULL COMMENT '影响因素3-偏差值-值',
- `fac3_unit` varchar(20) NULL DEFAULT NULL COMMENT '影响因素4-偏差值-单位',
- `fac4_name` varchar(20) NULL DEFAULT NULL COMMENT '影响因素4-偏差值-名称',
- `fac4_value` varchar(20) NULL DEFAULT NULL COMMENT '影响因素4-偏差值-值',
- `fac4_unit` varchar(20) NULL DEFAULT NULL COMMENT '影响因素4-偏差值-单位',
- `fac5_name` varchar(20) NULL DEFAULT NULL COMMENT '影响因素5-偏差值-名称',
- `fac5_value` varchar(20) NULL DEFAULT NULL COMMENT '影响因素5-偏差值-值',
- `fac5_unit` varchar(20) NULL DEFAULT NULL COMMENT '影响因素5-偏差值-单位',
- `create_date` datetime COMMENT '创建时间',
- PRIMARY KEY (`id`) USING BTREE,
- key idx_clock (clock)
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '焦化工序影响因数偏差值';
+CREATE TABLE `t_coking_trace_deviation` (
+ `id` varchar(36) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
+ `rel_id` varchar(36) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '关联ID',
+ `process` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工序名称',
+ `sug_obj` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '建议对象',
+ `clock` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '查询时间',
+ `ind1_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '一级指标-偏差值-名称',
+ `ind1_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '一级指标-偏差值-值',
+ `ind1_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '一级指标-偏差值-单位',
+ `ind2_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '二级指标-偏差值-名称',
+ `ind2_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '二级指标-偏差值-值',
+ `ind2_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '二级指标-偏差值-单位',
+ `fac1_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素1-偏差值-名称',
+ `fac1_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素1-偏差值-值',
+ `fac1_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素1-偏差值-单位',
+ `fac2_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素2-偏差值-名称',
+ `fac2_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素2-偏差值-值',
+ `fac2_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素2-偏差值-单位',
+ `fac3_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素3-偏差值-名称',
+ `fac3_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素3-偏差值-值',
+ `fac3_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素4-偏差值-单位',
+ `fac4_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素4-偏差值-名称',
+ `fac4_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素4-偏差值-值',
+ `fac4_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素4-偏差值-单位',
+ `fac5_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素5-偏差值-名称',
+ `fac5_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素5-偏差值-值',
+ `fac5_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素5-偏差值-单位',
+ `fac6_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素6-偏差值-名称',
+ `fac6_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素6-偏差值-值',
+ `fac6_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素6-偏差值-单位',
+ `fac7_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素7-偏差值-名称',
+ `fac7_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素7-偏差值-值',
+ `fac7_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素7-偏差值-单位',
+ `fac8_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素8-偏差值-名称',
+ `fac8_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素8-偏差值-值',
+ `fac8_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素8-偏差值-单位',
+ `fac9_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素9-偏差值-名称',
+ `fac9_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素9-偏差值-值',
+ `fac9_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素9-偏差值-单位',
+ `fac10_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素10-偏差值-名称',
+ `fac10_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素10-偏差值-值',
+ `fac10_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素10-偏差值-单位',
+ `fac11_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素11-偏差值-名称',
+ `fac11_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素11-偏差值-值',
+ `fac11_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素11-偏差值-单位',
+ `fac12_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素12-偏差值-名称',
+ `fac12_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素12-偏差值-值',
+ `fac12_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素12-偏差值-单位',
+ `fac13_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素13-偏差值-名称',
+ `fac13_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素13-偏差值-值',
+ `fac13_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素13-偏差值-单位',
+ `fac14_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素14-偏差值-名称',
+ `fac14_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素14-偏差值-值',
+ `fac14_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素14-偏差值-单位',
+ `fac15_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素15-偏差值-名称',
+ `fac15_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素15-偏差值-值',
+ `fac15_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素15-偏差值-单位',
+ `fac16_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素16-偏差值-名称',
+ `fac16_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素16-偏差值-值',
+ `fac16_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素16-偏差值-单位',
+ `fac17_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素17-偏差值-名称',
+ `fac17_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素17-偏差值-值',
+ `fac17_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素17-偏差值-单位',
+ `fac18_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素18-偏差值-名称',
+ `fac18_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素18-偏差值-值',
+ `fac18_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素18-偏差值-单位',
+ `fac19_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素19-偏差值-名称',
+ `fac19_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素19-偏差值-值',
+ `fac19_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素19-偏差值-单位',
+ `fac20_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素20-偏差值-名称',
+ `fac20_value` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素20-偏差值-值',
+ `fac20_unit` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '影响因素20-偏差值-单位',
+ `create_date` datetime DEFAULT NULL COMMENT '创建时间',
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `idx_clock` (`clock`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='焦化工序影响因数偏差值';
-- ----------------------------
@@ -714,12 +774,12 @@
-- ----------------------------
CREATE TABLE `t_power_voltage_status`
(
- `id` varchar(36) NOT NULL COMMENT 'id',
- `code` varchar(50),
- `name` varchar(50) DEFAULT NULL COMMENT '机组名称',
- `point` varchar(50) DEFAULT NULL COMMENT '测点',
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `code` varchar(50),
+ `name` varchar(50) DEFAULT NULL COMMENT '机组名称',
+ `point` varchar(50) DEFAULT NULL COMMENT '测点',
`limit_h` decimal(8, 2) DEFAULT NULL COMMENT '阈值',
- `sort` int NULL DEFAULT NULL COMMENT '排序',
+ `sort` int NULL DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='功率因数-母线电压状态';
@@ -760,4 +820,296 @@
PRIMARY KEY (`id`),
key uk_p_code (p_code),
UNIQUE key uk_node_code (node_code)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='电力下拉关系表';
\ No newline at end of file
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='电力下拉关系表';
+
+
+-- ----------------------------
+-- 煤气预测析配置
+-- ----------------------------
+DROP TABLE IF EXISTS `t_gas_pred_conf`;
+CREATE TABLE `t_gas_pred_conf`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `chart_code` varchar(50) NULL DEFAULT NULL COMMENT '预测图编号',
+ `user_type` varchar(50) NULL DEFAULT NULL COMMENT '用户类型（发生，消耗）',
+ `item_no` varchar(50) NULL DEFAULT NULL COMMENT '预测项编号',
+ `item_name` varchar(50) NULL DEFAULT NULL COMMENT '预测项名称',
+ `out_key` varchar(50) NULL DEFAULT NULL COMMENT '预测项输出key',
+ `out_name` varchar(50) NULL DEFAULT NULL COMMENT '预测项输出名称',
+ `is_default_load` int DEFAULT NULL COMMENT '是否默认加载',
+ `sort` int NULL DEFAULT NULL COMMENT '排序',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '煤气预测析配置';
+
+ALTER TABLE `t_gas_pred_conf`
+ ADD COLUMN `out_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '预测项输出id' AFTER `item_name`,
+ADD COLUMN `is_default_load` int DEFAULT NULL COMMENT '是否默认加载' AFTER `out_name`;
+
+-- ----------------------------
+-- 负荷移植-最大需量发生记录
+-- ----------------------------
+DROP TABLE IF EXISTS `t_power_maxdemand_main`;
+CREATE TABLE `t_power_maxdemand_main`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `occur_time` datetime COMMENT '发生时间',
+ `code` varchar(50) NULL DEFAULT NULL COMMENT '编号',
+ `name` varchar(50) NULL DEFAULT NULL COMMENT '名称',
+ `max_demand` decimal(10, 2) NULL DEFAULT NULL COMMENT '最大需量',
+ PRIMARY KEY (`id`) USING BTREE,
+ key idx_code (code)
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '负荷移植最大需量发生记录';
+
+-- ----------------------------
+-- 负荷移植-最大需量发生记录详情
+-- ----------------------------
+DROP TABLE IF EXISTS `t_power_maxdemand_det`;
+CREATE TABLE `t_power_maxdemand_det`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `rel_id` varchar(36) NULL DEFAULT NULL COMMENT '关联ID',
+ `occur_time` datetime COMMENT '发生时间',
+ `code` varchar(50) NULL DEFAULT NULL COMMENT '编号',
+ `name` varchar(50) NULL DEFAULT NULL COMMENT '名称',
+ `max_demand` decimal(10, 2) NULL DEFAULT NULL COMMENT '最大需量',
+ `sort` int NULL DEFAULT NULL COMMENT '排序',
+ PRIMARY KEY (`id`) USING BTREE,
+ key idx_rel_id (rel_id)
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '负荷移植最大需量发生记录详情';
+
+
+alter table `t_power_capacitor_his` modify column `status` int NULL DEFAULT NULL COMMENT '状态(0：退出，1：投入)';
+
+
+-- ----------------------------
+-- 峰谷平电价方案表
+-- ----------------------------
+DROP TABLE IF EXISTS `t_power_price_main`;
+CREATE TABLE `t_power_price_main`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `code` varchar(50) NULL DEFAULT NULL COMMENT '方案编号(自动生成流水号)',
+ `name` varchar(50) NULL DEFAULT NULL COMMENT '方案名称',
+ `status` int DEFAULT 0 COMMENT '是否有效(0:无效，1：有效)',
+ `creator` bigint COMMENT '创建者',
+ `create_date` datetime COMMENT '创建时间',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '峰谷平电价方案表';
+
+-- ----------------------------
+-- 峰谷平电价时段表
+-- ----------------------------
+DROP TABLE IF EXISTS `t_power_price_det`;
+CREATE TABLE `t_power_price_det`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `main_id` varchar(36) NOT NULL COMMENT '主表ID',
+ `name` varchar(20) NULL DEFAULT NULL COMMENT '时段名称(尖，峰，谷，平)',
+ `start` varchar(50) NULL DEFAULT NULL COMMENT '时段开始（00:00）',
+ `end` varchar(50) NULL DEFAULT NULL COMMENT '时段结束（00:00）',
+ `price` varchar(20) NULL DEFAULT NULL COMMENT '电价',
+ `sort` int NULL DEFAULT NULL COMMENT '排序',
+ PRIMARY KEY (`id`) USING BTREE,
+ key idx_main_id (main_id)
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '峰谷平电价时段表';
+
+-- ----------------------------
+-- 峰谷平累计计算配置
+-- ----------------------------
+CREATE TABLE `t_peak_valley_flat`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `name` varchar(36) DEFAULT NULL COMMENT '名称',
+ `type` varchar(36) DEFAULT NULL COMMENT '类型（peak/vallay/flat）',
+ `point_no` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '下发测点编码_日_占比',
+ `point_no_month` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '下发测点编码_月_占比',
+ `point_no_total` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '下发测点编码_日_峰/谷耗电量',
+ `power_no` varchar(36) DEFAULT NULL COMMENT '功率点位',
+ `create_time` datetime DEFAULT NULL COMMENT '创建时间',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='峰谷平累计计算配置';
+
+CREATE INDEX `idx_occur_time` ON `t_power_maxdemand_main` (`occur_time`);
+
+
+ALTER TABLE `t_power_net_factor`
+ ADD COLUMN `p_day` varchar(50) NULL DEFAULT NULL COMMENT '有功日累计';
+ALTER TABLE `t_power_net_factor`
+ ADD COLUMN `q_day` varchar(50) NULL DEFAULT NULL COMMENT '无功日累计';
+ALTER TABLE `t_power_net_factor`
+ ADD COLUMN `p_mon` varchar(50) NULL DEFAULT NULL COMMENT '有功月累计';
+ALTER TABLE `t_power_net_factor`
+ ADD COLUMN `q_mon` varchar(50) NULL DEFAULT NULL COMMENT '无功月累计';
+
+-- ----------------------------
+-- 功率因数管控
+-- ----------------------------
+CREATE TABLE `t_power_factor_control`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `type` varchar(36) DEFAULT NULL COMMENT '类型',
+ `name` varchar(36) DEFAULT NULL COMMENT '名称',
+ `pred_result` varchar(36) DEFAULT NULL COMMENT '预测结果',
+ `sort` int NULL DEFAULT NULL COMMENT '排序',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='功率因数管控';
+
+ALTER TABLE `t_power_factor_control`
+ ADD COLUMN `data_type` varchar(20) NULL DEFAULT NULL COMMENT '数据类型' after `name`;
+ALTER TABLE `t_power_factor_control`
+ ADD COLUMN `cos_index` int NULL DEFAULT NULL COMMENT '功率因素结果角标' after `pred_result`;
+
+-- ----------------------------
+-- 日报表
+-- ----------------------------
+CREATE TABLE `t_xxb_duty_report`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `cde_index` varchar(36) DEFAULT NULL COMMENT '类型',
+ `name_index` varchar(36) DEFAULT NULL COMMENT '名称',
+ `point_no1` varchar(36) DEFAULT NULL COMMENT '测点1',
+ `point_no2` varchar(36) DEFAULT NULL COMMENT '测点2',
+ `point_no3` varchar(36) DEFAULT NULL COMMENT '测点3',
+ `sort` int NULL DEFAULT NULL COMMENT '排序',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='功率因数管控';
+
+-- ----------------------------
+-- 日报表
+-- ----------------------------
+CREATE TABLE `t_xxb_duty_report`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `cde_index` varchar(36) DEFAULT NULL COMMENT '类型',
+ `name_index` varchar(36) DEFAULT NULL COMMENT '名称',
+ `point_no1` varchar(36) DEFAULT NULL COMMENT '测点1',
+ `point_no2` varchar(36) DEFAULT NULL COMMENT '测点2',
+ `point_no3` varchar(36) DEFAULT NULL COMMENT '测点3',
+ `sort` int NULL DEFAULT NULL COMMENT '排序',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='功率因数管控';
+
+
+-- ----------------------------
+-- 135机组数据配置表
+-- ----------------------------
+DROP TABLE IF EXISTS `t_plant_conf`;
+CREATE TABLE `t_plant_conf`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `data_category` varchar(20) DEFAULT NULL COMMENT '数据类别（REAL:实时，HIS:历史）',
+ `data_type` varchar(20) DEFAULT NULL COMMENT '数据类型',
+ `data_no` varchar(20) DEFAULT NULL COMMENT '数据编码',
+ `business_type` varchar(20) NULL DEFAULT NULL COMMENT '业务类别',
+ `business_desc` varchar(20) NULL DEFAULT NULL COMMENT '业务描述',
+ `ind_code` varchar(20) NULL DEFAULT NULL COMMENT '指标编码',
+ `ind_name` varchar(20) NULL DEFAULT NULL COMMENT '指标名称',
+ `ind_unit` varchar(20) NULL DEFAULT NULL COMMENT '指标单位',
+ `remark` varchar(100) NULL DEFAULT NULL COMMENT '备注',
+ `ext1` varchar(20) NULL DEFAULT NULL COMMENT '拓展字段1',
+ `ext2` varchar(20) NULL DEFAULT NULL COMMENT '拓展字段2',
+ `ext3` varchar(20) NULL DEFAULT NULL COMMENT '拓展字段3',
+ `ext4` varchar(20) NULL DEFAULT NULL COMMENT '拓展字段4',
+ `ext5` varchar(20) NULL DEFAULT NULL COMMENT '拓展字段5',
+ `sort` int NULL DEFAULT NULL COMMENT '排序',
+ PRIMARY KEY (`id`),
+ KEY `idx_business_type` (`business_type`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='135机组数据配置表';
+
+-- ----------------------------
+-- xiz135机组指标数据配置表
+-- ----------------------------
+DROP TABLE IF EXISTS `t_plant_index_conf`;
+CREATE TABLE `t_plant_index_conf`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `business_type` varchar(20) DEFAULT NULL COMMENT '业务类别',
+ `business_desc` varchar(20) DEFAULT NULL COMMENT '业务描述',
+ `ind_code` varchar(20) DEFAULT NULL COMMENT '指标编码',
+ `ind_name` varchar(20) DEFAULT NULL COMMENT '指标名称',
+ `ind_unit` varchar(20) DEFAULT NULL COMMENT '指标单位',
+ `ind_avg` varchar(20) DEFAULT NULL COMMENT '历史平均',
+ `ind_theory` varchar(20) DEFAULT NULL COMMENT '理论值',
+ `ind_optimal` varchar(20) DEFAULT NULL COMMENT '最优值',
+ `ind_real` varchar(20) DEFAULT NULL COMMENT '实时值',
+ `ind_deviation_value` varchar(20) DEFAULT NULL COMMENT '偏差值',
+ `ind_deviation_rate` varchar(20) DEFAULT NULL COMMENT '偏差率',
+ `ind_previous` varchar(20) DEFAULT NULL COMMENT '上班数据',
+ `sort` int DEFAULT NULL COMMENT '排序',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='135机组指标数据配置表';
+
+CREATE TABLE `t_sync_log`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `table_name` varchar(50) NULL DEFAULT NULL COMMENT '表名称',
+ `remark` varchar(50) NULL DEFAULT NULL COMMENT '备注',
+ create_date datetime COMMENT '创建时间',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '同步日志';
+
+
+CREATE TABLE `t_page_param`
+(
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `param_type` varchar(50) NULL DEFAULT NULL COMMENT '参数类型',
+ `param_code` varchar(50) NULL DEFAULT NULL COMMENT '参数编码',
+ `param_name` varchar(50) NULL DEFAULT NULL COMMENT '参数名称',
+ `param_value` varchar(50) NULL DEFAULT NULL COMMENT '参数值',
+ `param_unit` varchar(50) NULL DEFAULT NULL COMMENT '参数单位',
+ `point_no` varchar(50) NULL DEFAULT NULL COMMENT '测点编码',
+ `chart_code` varchar(50) NULL DEFAULT NULL COMMENT '图表编码',
+ `chart_param` varchar(50) NULL DEFAULT NULL COMMENT '图表参数',
+ `model_id` varchar(50) NULL DEFAULT NULL COMMENT '模型ID',
+ `model_param` varchar(50) NULL DEFAULT NULL COMMENT '模型参数',
+ `sort` int DEFAULT NULL COMMENT '排序',
+ `update_date` datetime COMMENT '创建时间',
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `idx_param_type` (`param_type`),
+ UNIQUE KEY `idx_param_code` (`param_code`)
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '参数设置';
+
+DROP TABLE IF EXISTS `byqlz_ads_wh_cl_jh01_byq`;
+CREATE TABLE `byqlz_ads_wh_cl_jh01_byq` (
+ `REC_ID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分区键',
+ `REC_CREATE_TIME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '记录创建时刻',
+ `REC_CREATOR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `REC_REVISE_TIME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `REC_REVISOR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `DATE_CODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `MSC_LINE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `INDEX_CODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `MONTHLY_PLAT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '月计划产量',
+ `VAL1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '1日计划产量',
+ `VAL2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL7` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL8` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL9` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL10` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL11` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL12` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL13` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL14` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL15` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL16` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL17` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL18` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL19` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL20` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL21` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL22` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL23` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL24` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL25` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL26` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL27` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL28` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL29` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL30` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `VAL31` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `LOAD_TIME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '记录程序生成时刻'
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鲅鱼圈产量计划维护表' ROW_FORMAT = Dynamic;
\ No newline at end of file
--
Gitblit v1.9.3