新增调度建议操作记录表

 iailab-module-model/iailab-module-model-biz/db/增量SQL/2025.sql

@@ -2,4 +2,23 @@

alter table t_st_schedule_scheme add column `warning_adjust_rate` int DEFAULT NULL COMMENT '预警调整速率';

alter table t_mm_predict_alarm_config modify column `comp_length` varchar(30) COMMENT '比较长度';
alter table t_mm_predict_alarm_config modify column `comp_length` varchar(30) COMMENT '比较长度';

CREATE TABLE `t_st_schedule_suggest_operation_record` (
                                                          `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
                                                          `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '标题',
                                                          `content` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '内容',
                                                          `scheme_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '方案ID',
                                                          `model_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '模型ID',
                                                          `model_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '名称',
                                                          `schedule_time` datetime DEFAULT NULL COMMENT '调度时间',
                                                          `result_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '结果code',
                                                          `result_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '调度结果',
                                                          `operate` varchar(36) NOT NULL COMMENT '操作（已采纳,取消采纳，已忽略等）',
                                                          `handler_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '处理人ID',
                                                          `handler` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '处理人',
                                                          `handle_time` datetime DEFAULT NULL COMMENT '处理时间',
                                                          `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                                          PRIMARY KEY (`id`) USING BTREE,
                                                          KEY `idx_model_id` (`model_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='调度建议操作记录表';