-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathinsert_station_err.sql
executable file
·75 lines (69 loc) · 13 KB
/
insert_station_err.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境温度超上限_红','MaxTem_R','60','检查空调状态及时降温或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境温度将达上限_橙','MaxTem_O','55','检查空调状态及时降温或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境温度偏高_黄','MaxTem_Y','50','检查空调状态及时降温或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境温度超下限_红','MinTem_R','3','检查空调状态及时保温或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境温度将达下限_橙','MinTem_O','5','检查空调状态及时保温或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境温度偏低_黄','MinTem_Y','9','检查空调状态及时保温或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境温湿度传感器故障_黄','TemSenErr','7','联系BMS厂家维护');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境湿度超上限_红','MaxHum_R','90','检查加湿器状态或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境湿度将达上限_橙','MaxHum_O','85','检查加湿器状态或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境湿度偏高_黄','MaxHum_Y','80','检查加湿器状态或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境湿度超下限_红','MinHum_R','3','检查加湿器工作状态');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境湿度将达下限_橙','MinHum_O','5','检查加湿器工作状态');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','环境湿度偏低_黄','MinHum_Y','8','检查加湿器工作状态');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站放电电流超上限_红','DisChaLim_R','40','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站放电电流将达上限_橙','DisChaLim_O','35','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站放电电流偏高_黄','DisChaLim_Y','30','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站充电电流超上限_红','ChaLim_R','-20','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站充电电流将达上限_橙','ChaLim_O','-18','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站充电电流偏高_黄','ChaLim_Y','-16','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站电流传感器故障_黄','CurSenErr','7','联系BMS厂家维护');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站电池总电压超上限_红','HiVolLim_R','89','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站电池总电压将达上限_橙','HiVolLim_O','86','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站电池总电压偏高_黄','HiVolLim_Y','83','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站电池总电压超下限_红','LoVolLim_R','63','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站电池总电压将达下限_橙','LoVolLim_O','65','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','站电池总电压偏低_黄','LoVolLim_Y','67','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','组间电流偏差_红','GroCurDevLim_R','10','检查电池线缆连接状态或通知BMS厂家检测电流传感器');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','组间电流偏差_橙','GroCurDevLim_0','7','检查电池线缆连接状态或通知BMS厂家检测电流传感器');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','组间电流偏差_黄','GroCurDevLim_Y','4','检查电池线缆连接状态或通知BMS厂家检测电流传感器');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','组间电压偏差_红','GroVolDevLim_R','3','检查单个电池电压状态或通知BMS厂家检测电压传感器');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','组间电压偏差_橙','GroVolDevLim_0','2','检查单个电池电压状态或通知BMS厂家检测电压传感器');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','组间电压偏差_黄','GroVolDevLim_Y','1','检查单个电池电压状态或通知BMS厂家检测电压传感器');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','组间温度偏差_红','GroTTemDevLim_R','7','检查电池箱温度状态或通知BMS厂家检测温度传感器');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','组间温度偏差_橙','GroTemDevLim_0','5','检查电池箱温度状态或通知BMS厂家检测温度传感器');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('station','组间温度偏差_黄','GroTemDevLim_Y','3','检查电池箱温度状态或通知BMS厂家检测温度传感器');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('group','组放电电流超上限_红','DisChaLim_R','30','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('group','组放电电流将达上限_橙','DisChaLim_O','28','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('group','组放电电流偏高_黄','DisChaLim_Y','25','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('group','组充电电流超上限_红','ChaLim_R','-20','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('group','组充电电流将达上限_橙','ChaLim_O','-18','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('group','组充电电流偏高_黄','ChaLim_Y','-16','检查UPS状态或关闭UPS、联系UPS厂家');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('group','组电流传感器故障_黄','CurSenErr','7','联系BMS厂家检查传感器状态');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池电压超上限_红','MaxU_R','14.1','检查电池状态或关闭UPS、更换电池，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池电压将达上限_橙','MaxU_O','14','检查电池状态或关闭UPS、更换电池，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池电压偏高_黄','MaxU_Y','13.9','检查电池状态或关闭UPS、更换电池，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池电压超下限_红','MinU_R','10.2','检查电池状态或关闭UPS、更换电池，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池电压将达下限_橙','MinU_O','10.5','检查电池状态或关闭UPS、更换电池，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池电压偏低_黄','MinU_Y','10.8','检查电池状态或关闭UPS、更换电池，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电压传感器故障','VolSenErr','7','检查通信线路连接状态、联系BMS厂家维护或更换采集模块');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池温度超上限_红','MaxT_R','55','检查电池状态或关闭UPS、更换电池，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池温度将达上限_橙','MaxT_O','50','检查电池状态或关闭UPS、更换电池，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池温度偏高_黄','MaxT_Y','45','检查电池状态或关闭UPS、更换电池，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池温度超下限_红','MinT_R','3','做好电池保温或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池温度将达下限_橙','MinT_O','6','做好电池保温或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池温度偏低_黄','MinT_Y','9','做好电池保温或关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','温度传感器故障','TemSenErr','7','检查通信线路连接状态、联系BMS厂家维护或更换采集模块');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池内阻超上限_红','MaxR_R','15','联系电池或UPS厂家、更换电池、关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池内阻将达上限_橙','MaxR_O','12.5','联系电池或UPS厂家、更换电池、关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池内阻偏高_黄','MaxR_Y','10','联系电池或UPS厂家、更换电池、关闭UPS');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','内阻传感器故障','ResSenErr','7','检查通信线路连接状态、联系BMS厂家维护或更换采集模块');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池电压偏差_红','MaxDevU_R','0.5','关注电池变化，偏离过大或超过门限，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池电压偏差_橙','MaxDevU_O','0.4','关注电池变化，偏离过大或超过门限，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池电压偏差_黄','MaxDevU_Y','0.3','关注电池变化，偏离过大或超过门限，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池温度偏差_红','MaxDevT_R','5','关注电池变化，偏离过大或超过门限，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池温度偏差_橙','MaxDevT_O','4','关注电池变化，偏离过大或超过门限，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池温度偏差_黄','MaxDevT_Y','3','关注电池变化，偏离过大或超过门限，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池内阻偏差_红','MaxDevR_R','5','关注电池变化，偏离过大或超过门限，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池内阻偏差_橙','MaxDevR_O','4','关注电池变化，偏离过大或超过门限，联系电池、UPS厂商');
insert into my_station_alert_desc(`type`,`desc`,`en`,`limit`,`suggest`) values('battery','电池内阻偏差_黄','MacDevR_Y','3','关注电池变化，偏离过大或超过门限，联系电池、UPS厂商');