From 594a8983a040ff81ad800e788f9e0da541e726f4 Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期二, 15 四月 2025 22:23:38 +0800
Subject: [PATCH] 电网拓扑预警信息
---
ansteel-biz/db/mysql.sql | 31 ++++++++++++++++++++++++++++---
1 files changed, 28 insertions(+), 3 deletions(-)
diff --git a/ansteel-biz/db/mysql.sql b/ansteel-biz/db/mysql.sql
index e17d690..31342be 100644
--- a/ansteel-biz/db/mysql.sql
+++ b/ansteel-biz/db/mysql.sql
@@ -252,6 +252,25 @@
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '电力功率因数电网拓扑';
+ALTER TABLE `t_power_net_factor` ADD COLUMN `cur_flag` int DEFAULT 0 COMMENT '无功返送(1:大于0是，-1：小于0是)';
+
+-- ----------------------------
+-- 电力功率因数-发电机组实时状态
+-- ----------------------------
+DROP TABLE IF EXISTS `t_power_gen_status`;
+CREATE TABLE `t_power_gen_status` (
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `name` varchar(50) NULL DEFAULT NULL COMMENT '机组名称',
+ `cur_p` varchar(50) NULL DEFAULT NULL COMMENT '当前有功',
+ `cur_q` varchar(50) NULL DEFAULT NULL COMMENT '当前无功',
+ `cur_cos` varchar(50) NULL DEFAULT NULL COMMENT '当前功率因数',
+ `limit_h` decimal(6, 3) NULL DEFAULT NULL COMMENT '上限',
+ `limit_l` decimal(6, 3) NULL DEFAULT NULL COMMENT '下限',
+ `status` int DEFAULT 0 COMMENT '是否超限(0:正常，1：超限)',
+ `sort` int NULL DEFAULT NULL COMMENT '排序',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '电力功率因数发电机组实时状态';
+
-- ----------------------------
-- 电力功率因数-电容器投运状态
-- ----------------------------
@@ -282,7 +301,10 @@
UNIQUE INDEX `uk_name` (`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '电力功率因数管控功率因数主表';
--- ----------------------------
+ALTER TABLE `t_power_control_main` ADD COLUMN `limit_h` decimal(6, 4) NULL DEFAULT NULL COMMENT '上限';
+ALTER TABLE `t_power_control_main` ADD COLUMN `limit_l` decimal(6, 4) NULL DEFAULT NULL COMMENT '下限',
+
+ -- ----------------------------
-- 电力功率因数-管控功率因数从表
-- ----------------------------
DROP TABLE IF EXISTS `t_power_control_det`;
@@ -386,7 +408,9 @@
`analy_title` varchar(20) NULL DEFAULT NULL COMMENT '分析标题',
`analy_date` varchar(20) NULL DEFAULT NULL COMMENT '分析日期',
`analy_class` varchar(20) NULL DEFAULT NULL COMMENT '分析班次',
- `analy_content` varchar(20) NULL DEFAULT NULL COMMENT '内容',
+ `analy_value` varchar(20) NULL DEFAULT NULL COMMENT '分析值',
+ `analy_content` varchar(100) NULL 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 '焦化工序趋势分析';
@@ -399,6 +423,7 @@
`analy_type` varchar(20) NULL DEFAULT NULL COMMENT '分析类型',
`analy_date` varchar(20) NULL DEFAULT NULL COMMENT '分析日期',
`analy_class` varchar(20) NULL DEFAULT NULL COMMENT '分析班次',
- `analy_content` varchar(20) NULL DEFAULT NULL COMMENT '内容',
+ `analy_content` varchar(100) NULL 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 '焦化工序指标分析';
--
Gitblit v1.9.3