bd_alert_rule商机· 告警
yjgw 库的实体表 · 12 个字段 · 主键 id · 数据行约 5
字段结构
| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|
| id | varchar(36) | PRI | NO | | |
| rule_code | varchar(64) | | NO | | |
| rule_name | varchar(128) | | YES | | |
| metric_code | varchar(64) | | YES | | |
| operator | varchar(8) | | YES | > | |
| threshold | decimal(16,4) | | YES | 0.0000 | |
| level | varchar(16) | | YES | warn | |
| window_min | int(11) | | YES | 5 | |
| enabled | tinyint(4) | | YES | 1 | |
| created_at | datetime | | YES | | |
| updated_at | datetime | | YES | | |
| is_deleted | tinyint(4) | | YES | 0 | |
索引
样本数据 · 已脱敏 · 前 3 行
| id | rule_code | rule_name | metric_code | operator | threshold | level | window_min | enabled | created_at | updated_at | is_deleted |
|---|
| 129234a5-a776-49c9-89aa-1cc952066c02 | ACK_TEST | ACK_TEST | order_count | < | 999999.0000 | warn | 5 | 1 | 2026-11-07 22:43:00 | 2026-11-07 22:43:00 | 0 |
| 16e19240-a83e-4fb6-a86d-d6032c7f71de | iot.temperature | IoT温度超限 | temperature | gt | 8.0000 | warn | 5 | 1 | 2026-11-07 23:26:03 | 2026-11-07 23:26:03 | 0 |
| 7886264d-c481-456e-bf7d-a5044fc79ddf | ACC_TEST | 验收规则 | order_count | > | 0.0000 | warn | 5 | 1 | 2026-11-07 22:42:34 | 2026-11-07 22:42:34 | 0 |