From 8fb99de46ce93eb442b918d8973f3ff789ce1769 Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期三, 07 五月 2025 07:01:02 +0800
Subject: [PATCH] 电流状态
---
ansteel-biz/db/mysql.sql | 18 +++++++++++++++++-
1 files changed, 17 insertions(+), 1 deletions(-)
diff --git a/ansteel-biz/db/mysql.sql b/ansteel-biz/db/mysql.sql
index 8c26e46..0a0e42a 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 '无功上限';
+
-- ----------------------------
-- 电力功率因数-发电机组实时状态
-- ----------------------------
@@ -718,7 +734,7 @@
`code` varchar(50),
`name` varchar(50) DEFAULT NULL COMMENT '机组名称',
`point` varchar(50) DEFAULT NULL COMMENT '测点',
- `limit` decimal(8, 2) DEFAULT NULL COMMENT '阈值',
+ `limit_h` decimal(8, 2) DEFAULT NULL COMMENT '阈值',
`sort` int NULL DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='功率因数-母线电压状态';
--
Gitblit v1.9.3