| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | varchar(36) | PRI | NO | ||
| rule_id | varchar(36) | YES | |||
| rule_code | varchar(64) | YES | |||
| metric_value | decimal(16,4) | YES | 0.0000 | ||
| threshold | decimal(16,4) | YES | 0.0000 | ||
| level | varchar(16) | YES | |||
| content | varchar(255) | YES | |||
| status | varchar(16) | YES | open | ||
| acked_by | varchar(36) | YES | |||
| acked_at | datetime | YES | |||
| created_at | datetime | YES | |||
| source_event_id | bigint(20) | UNI | YES | 设备事件源ID |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| uk_src | source_event_id | 普通 |
| id | rule_id | rule_code | metric_value | threshold | level | content | status | acked_by | acked_at | created_at | source_event_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0359aee6-3c21-455b-b626-8b46914f960d | NULL | iot.temperature | 9.8000 | 8.0000 | warn | IOT-B5 temperature 值 9.8000 超出区间 [-25.0, 8… | pending | NULL | NULL | 2026-11-07 01:50:03 | 306 |
| 03cf33e6-58f6-4e67-8698-7490cdc7625f | NULL | iot.temperature | 8.5000 | 8.0000 | warn | IOT-B12 temperature 值 8.5000 超出区间 [-25.0, … | pending | NULL | NULL | 2026-11-07 01:50:02 | 335 |
| 05b4deb5-de17-425b-a1a2-d92b9264acca | NULL | iot.temperature | 8.5000 | 8.0000 | warn | IOT-B8 temperature 值 8.5000 超出区间 [-25.0, 8… | pending | NULL | NULL | 2026-11-07 01:49:59 | 382 |