From f8bffb3ae6854fbcf6f78ed953bf73e33fadc8a9 Mon Sep 17 00:00:00 2001 From: 潘志宝 <979469083@qq.com> Date: 星期一, 28 四月 2025 14:52:48 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- iailab-module-model/iailab-module-model-biz/db/mysql.sql | 51 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 51 insertions(+), 0 deletions(-) diff --git a/iailab-module-model/iailab-module-model-biz/db/mysql.sql b/iailab-module-model/iailab-module-model-biz/db/mysql.sql index e49a221..ab367f1 100644 --- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql +++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql @@ -384,6 +384,8 @@ ) engine = innodb default character set utf8mb4 COMMENT = '调度记录详情表'; +create index `idx_schedule_time` on `t_st_schedule_record_detail` (schedule_time); + -- mpk -- menu @@ -1011,3 +1013,52 @@ -- t_st_schedule_record 创建复合索引 CREATE INDEX idx_st_schedule_record_scheme_result_time ON t_st_schedule_record (scheme_id, result_code, schedule_time DESC, create_time DESC); + +CREATE TABLE `t_mm_predict_auto_adjust_config` ( + `id` varchar(36) NOT NULL, + `config_name` varchar(255) DEFAULT NULL COMMENT '配置名称', + `config_code` varchar(255) DEFAULT NULL COMMENT '配置编码', + `output_id` varchar(36) DEFAULT NULL COMMENT '预测输出id', + `point_id` varchar(36) DEFAULT NULL COMMENT '测点id', + `t` int DEFAULT NULL COMMENT '取值时间范围', + `trigger_rule` varchar(36) DEFAULT NULL COMMENT '触发规则', + `trigger_value` double DEFAULT NULL COMMENT '触发值', + `adjust_direction` tinyint DEFAULT '1' COMMENT '调整方向(1:正向，-1：反向)', + `adjust_length` int DEFAULT NULL COMMENT '调整长度', + `adjust_value_rule` varchar(36) DEFAULT NULL COMMENT '调整值计算规则', + `is_enable` tinyint DEFAULT NULL COMMENT '是否启用（0禁用 1启用）', + `create_time` datetime DEFAULT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `config_code` (`config_code`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='预测结果自动调整配置表'; + +-- 预测项影响因素 + +CREATE TABLE `t_mm_predict_influence_factor_config` ( + `id` varchar(36) NOT NULL, + `output_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '预测项id', + `pattern` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '统计方式', + `is_enable` tinyint DEFAULT NULL COMMENT '是否启用（0禁用 1启用）', + `create_time` datetime DEFAULT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `output_id_pattern_unique` (`output_id`,`pattern`), + KEY `output_id` (`output_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='预测项影响因素配置表'; + +CREATE TABLE `t_mm_predict_influence_factor` ( + `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `config_id` varchar(36) DEFAULT NULL COMMENT '配置id', + `factor_output_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '因素预测项id', + `deviation_value` double DEFAULT NULL COMMENT '偏差值', + PRIMARY KEY (`id`), + UNIQUE KEY `config_id_factor_output_id_unique` (`config_id`,`factor_output_id`), + CONSTRAINT `t_mm_predict_influence_factor_ibfk_1` FOREIGN KEY (`config_id`) REFERENCES `t_mm_predict_influence_factor_config` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='预测项影响因素关联表'; + +CREATE TABLE `t_mm_predict_influence_factor_result` ( + `factor_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '因素id', + `time` datetime DEFAULT NULL COMMENT '影响时间', + `value` double DEFAULT NULL COMMENT '影响值', + UNIQUE KEY `factor_id_time_unique` (`factor_id`,`time` DESC) USING BTREE, + CONSTRAINT `t_mm_predict_influence_factor_result_ibfk_1` FOREIGN KEY (`factor_id`) REFERENCES `t_mm_predict_influence_factor` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='预测项影响因素结果表'; -- Gitblit v1.9.3