| | |
|---|
| | | handled_at_utc DATETIME(3) NULL, |
|---|
| | | handling_note VARCHAR(1000) NULL, |
|---|
| | | PRIMARY KEY (exception_id), |
|---|
| | | open_threshold_id BIGINT GENERATED ALWAYS AS (IF(exception_status = 'OPEN', threshold_id, NULL)) STORED, |
|---|
| | | UNIQUE KEY uk_warning_exception_open (test_id, metric_code, open_threshold_id), |
|---|
| | | UNIQUE KEY uk_warning_exception_open (test_id, metric_code, threshold_id, exception_status), |
|---|
| | | KEY idx_warning_exception_query (test_id, exception_status, last_occurred_at_utc) |
|---|
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='测试预警阈值异常'; |
|---|
