From 73b3a394952353c318a8712d2cc1efec03dc009d Mon Sep 17 00:00:00 2001 From: 潘志宝 <979469083@qq.com> Date: 星期四, 10 四月 2025 16:40:14 +0800 Subject: [PATCH] Merge branch 'master' of http://dlindusit.com:53929/r/iailab-plat --- iailab-module-model/iailab-module-model-biz/db/mysql.sql | 17 +++++++++++++++++ 1 files changed, 17 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..a0a416a 100644 --- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql +++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql @@ -1011,3 +1011,20 @@ -- 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`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='预测结果自动调整配置表'; -- Gitblit v1.9.3