From 977edcb50e46f57d5b8fdd4551736b1605fef6fc Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期二, 19 十一月 2024 13:15:02 +0800
Subject: [PATCH] 预测数据查询
---
iailab-module-model/iailab-module-model-biz/db/mysql.sql | 31 ++++++++-----------------------
1 files changed, 8 insertions(+), 23 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 4dab812..f24ad84 100644
--- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql
+++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
@@ -87,13 +87,6 @@
INDEX idx_modelid (modelid)
) engine = innodb default character set utf8mb4 COMMENT = '预测模型输入参数表';
-create table t_mm_model_resultstr
-(
- id varchar(64) not null,
- resultstr varchar(64),
- primary key (id)
-) engine = innodb default character set utf8mb4 COMMENT = '预测模型结果字符串表';
-
create table
t_mm_predict_item
(
@@ -159,14 +152,6 @@
UNIQUE INDEX idx_itemid (itemid)
) engine = innodb
default character set utf8mb4 COMMENT = '预测项模型表';
-
-create table t_mm_result_table
-(
- id varchar(36) not null,
- tablename varchar(30),
- primary key (id)
-) engine = innodb default character set utf8mb4 COMMENT = '预测结果存放表';
-
create table t_mm_item_result_json
(
@@ -598,7 +583,7 @@
`file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件名',
`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件保存路径',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
- `create_time` timestamp NULL DEFAULT NULL COMMENT '生成时间',
+ `create_time` datetime NULL DEFAULT NULL COMMENT '生成时间',
PRIMARY KEY (`id`, `mdk_id`) USING BTREE,
INDEX `del_code_history`(`mdk_id` ASC) USING BTREE,
CONSTRAINT `del_code_history` FOREIGN KEY (`mdk_id`) REFERENCES `t_mpk_file` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
@@ -671,8 +656,8 @@
`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
`project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目名称',
`project_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目编码',
- `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
- `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
+ `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
+ `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目表' ROW_FORMAT = DYNAMIC;
@@ -705,7 +690,7 @@
`version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '版本号',
`log` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新日志',
`model_names` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '打包模型名称（“，”分割）',
- `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
+ `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`, `project_id`) USING BTREE,
INDEX `del_package_history`(`project_id` ASC) USING BTREE,
CONSTRAINT `del_package_history` FOREIGN KEY (`project_id`) REFERENCES `t_mpk_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
@@ -810,8 +795,8 @@
`id` varchar(36) NOT NULL,
`chart_name` varchar(100) DEFAULT NULL COMMENT '图表名称',
`chart_code` varchar(100) DEFAULT NULL COMMENT '图表编码',
- `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
- `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
+ `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
+ `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_chart_code` (`chart_code`),
KEY `index_id` (`id`)
@@ -825,8 +810,8 @@
`param_code` varchar(100) DEFAULT NULL COMMENT '参数编码',
`param_value` varchar(1000) DEFAULT NULL COMMENT '参数值',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
- `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
- `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
+ `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
+ `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`, `chart_id`) USING BTREE,
KEY `index_chart_id` (`chart_id`),
CONSTRAINT `chart_id` FOREIGN KEY (`chart_id`) REFERENCES `t_chart` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
--
Gitblit v1.9.3