From 24996ea75ec4ca3b7d154387bfe37ec9dd387255 Mon Sep 17 00:00:00 2001
From: houzhongjian <houzhongyi@126.com>
Date: 星期四, 29 五月 2025 14:40:05 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
iailab-module-model/iailab-module-model-biz/db/增量SQL/2025.sql | 28 +++++++++++++++-------------
1 files changed, 15 insertions(+), 13 deletions(-)
diff --git "a/iailab-module-model/iailab-module-model-biz/db/\345\242\236\351\207\217SQL/2025.sql" "b/iailab-module-model/iailab-module-model-biz/db/\345\242\236\351\207\217SQL/2025.sql"
index c62d030..1b0906d 100644
--- "a/iailab-module-model/iailab-module-model-biz/db/\345\242\236\351\207\217SQL/2025.sql"
+++ "b/iailab-module-model/iailab-module-model-biz/db/\345\242\236\351\207\217SQL/2025.sql"
@@ -43,6 +43,7 @@
`conf_id` varchar(36) COMMENT '快照配置ID',
`data_type` varchar(20) DEFAULT NULL COMMENT '数据类型（DATAPOINT,IND,PLAN,PREDICTITEM）',
`data_no` varchar(36) COMMENT '数据编号',
+ `data_name` varchar(36) COMMENT '数据名称',
`left_length` integer COMMENT '左侧长度(min)',
`right_length` integer COMMENT '右侧侧长度(min)',
`sort` integer COMMENT '排序',
@@ -57,20 +58,21 @@
CREATE TABLE `t_st_suggest_snapshot_record`
(
- `id` varchar(36) NOT NULL,
- `suggest_id` varchar(36) COMMENT '建议ID(只记录采纳)',
- `operation_id` varchar(36) COMMENT '操作记录ID(只记录采纳)',
- `model_id` varchar(36) DEFAULT NULL COMMENT '模型ID',
- `data_type` varchar(20) DEFAULT NULL COMMENT '数据类型（DATAPOINT,IND,PLAN,PREDICTITEM）',
- `data_no` varchar(36) COMMENT '数据编号',
- `schedule_time` datetime DEFAULT NULL COMMENT '调度时间',
- `start_time` datetime DEFAULT NULL COMMENT '开始时间',
- `end_time` datetime DEFAULT NULL COMMENT '结束时间',
- `json_value` varchar(50) COMMENT '序列化的数据',
- `sort` integer COMMENT '排序',
+ `id` varchar(36) NOT NULL,
+ `suggest_id` varchar(36) COMMENT '建议ID(只记录采纳)',
+ `operation_id` varchar(36) COMMENT '操作记录ID(只记录采纳)',
+ `model_id` varchar(36) DEFAULT NULL COMMENT '模型ID',
+ `data_type` varchar(20) DEFAULT NULL COMMENT '数据类型（DATAPOINT,IND,PLAN,PREDICTITEM）',
+ `data_no` varchar(36) COMMENT '数据编号',
+ `data_name` varchar(36) COMMENT '数据名称',
+ `schedule_time` datetime DEFAULT NULL COMMENT '调度时间',
+ `start_time` datetime DEFAULT NULL COMMENT '开始时间',
+ `end_time` datetime DEFAULT NULL COMMENT '结束时间',
+ `json_value` varchar(50) COMMENT '序列化的数据',
+ `sort` integer COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE,
- KEY `idx_suggest_id` (`suggest_id`) USING BTREE
+ KEY `idx_suggest_id` (`suggest_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='调度建议快照记录表';
-ALTER TABLE `iailab_expert_tenant_shasteel`.`t_st_suggest_operation_record`
+ALTER TABLE `t_st_suggest_operation_record`
ADD COLUMN `reason` varchar(255) NULL COMMENT '原因' AFTER `operate`;
\ No newline at end of file
--
Gitblit v1.9.3