From c3c7a6918f0e2dfe597c339117e4185b641be95f Mon Sep 17 00:00:00 2001 From: Jay <csj123456> Date: 星期一, 24 二月 2025 15:10:19 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- iailab-module-model/iailab-module-model-biz/db/mysql.sql | 41 ++++++++++++++++++++++++++++++++++++++++- 1 files changed, 40 insertions(+), 1 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 417acc3..69a4dec 100644 --- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql +++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql @@ -900,4 +900,43 @@ alter table t_mm_item_output add column `iscumulant` tinyint default false COMMENT '是否累计'; alter table t_mm_item_output add column `cumuldivisor` int DEFAULT NULL COMMENT '累计除数'; -alter table t_mm_item_output add column `cumulpoint` varchar(36) DEFAULT NULL, COMMENT '累计测点'; \ No newline at end of file +alter table t_mm_item_output add column `cumulpoint` varchar(36) DEFAULT NULL, COMMENT '累计测点'; + + +CREATE TABLE `t_st_adjust_config` ( + `id` varchar(36) NOT NULL COMMENT 'ID', + `schedule_model_id` varchar(36) DEFAULT NULL COMMENT '调度模型ID', + `remark` varchar(200) DEFAULT NULL COMMENT '备注', + `status` tinyint DEFAULT 1 COMMENT '状态', + create_time datetime default current_timestamp, + update_time datetime default current_timestamp, + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_schedule_model_id`(`schedule_model_id` ASC) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='模拟调整配置表'; + +CREATE TABLE `t_st_adjust_config_det` ( + `id` varchar(36) NOT NULL COMMENT 'ID', + `config_id` varchar(36) DEFAULT NULL COMMENT '配置ID', + `item_type_id` varchar(36) DEFAULT NULL COMMENT '预测项类型', + `predict_item_id` varchar(36) DEFAULT NULL COMMENT '预测项ID', + `out_key` varchar(50) DEFAULT NULL COMMENT '输出KEY', + `out_name` varchar(50) DEFAULT NULL COMMENT '输出名称', + `model_param_order` integer DEFAULT NULL COMMENT '参数排序', + `model_param_port_order` integer DEFAULT NULL COMMENT '输入排序', + `sort` integer COMMENT '执行顺序', + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_config_id`(`config_id` ASC) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='模拟调整配置详细表'; + +CREATE TABLE `t_st_adjust_result` ( + `id` varchar(36) NOT NULL COMMENT 'ID', + `predict_item_id` varchar(36) DEFAULT NULL COMMENT '预测项ID', + `schedule_model_id` varchar(36) DEFAULT NULL COMMENT '调度模型ID', + `adjust_time` datetime NULL DEFAULT NULL COMMENT '模拟调整时间', + `adjust_value` varchar(500) DEFAULT NULL COMMENT '模拟调整值', + `json_value` varchar(1000) DEFAULT NULL COMMENT '模拟调整结果', + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_predict_item_id`(`predict_item_id` ASC) USING BTREE, + INDEX `idx_schedule_model_id`(`schedule_model_id` ASC) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='模拟调整结果表'; + -- Gitblit v1.9.3