From 363d230ac94cd14f6f5b0bdf2265738addc92c50 Mon Sep 17 00:00:00 2001 From: Administrator <1525436766@qq.com> Date: 星期一, 12 十二月 2022 15:47:07 +0800 Subject: [PATCH] V1.47 edit at date 2022-12-06 1.新增电操开关表'db_ram_db.tb_fbs9100_setparam'表新增FBO-4830NT设备参数字段 `OnlineTestFlag` int(11) NOT NULL DEFAULT '0' COMMENT '测试类型：0：离线 1：在线', `BattGroupCount` int(11) NOT NULL DEFAULT '1' COMMENT '电池组组数', `SOCLow` float NOT NULL DEFAULT '0' COMMENT '电池soc[剩余容量]下限(%)', `SOCHigh` float NOT NULL DEFAULT '0' COMMENT '电池soc[剩余容量]上限(%)', `CellDiffVolHigh` float NOT NULL DEFAULT '0' COMMENT '压差上限(mV)', 2.新增告警详情表'db_alarm.tb_alarm_detail'--告警详情 CREATE TABLE `tb_alarm_detail` ( `id` bigint(19) NOT NULL AUTO_INCREMENT, `alm_id` varchar(15) DEFAULT NULL COMMENT '告警id', `alm_reason` text COMMENT '告警原因', `alm_advice` varchar(255) DEFAULT NULL COMMENT '告警建议', `alm_type` int(5) NOT NULL DEFAULT '0' COMMENT '告警来源：0电源，1设备，2电池', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='告警详情'; --- BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java index 2139954..719cac1 100644 --- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java +++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java @@ -260,6 +260,7 @@ public final static String Battalarm_Data_History_Table = DB_ALARM + ".`tb_battalarm_data_history`"; public final static String Tb_Alarm_Message = DB_ALARM + ".`tb_alarm_message`"; public final static String Tb_Alarm_Detail_Table = DB_ALARM + ".`tb_alarm_detail`"; + public final static String Tb_Alarm_Relation_Table = DB_ALARM + ".`tb_alarm_relation`"; /***************************** db_app_sys 数据库 ***************************************/ -- Gitblit v1.9.1