From 680be40f0e730bdb72e19a04faf30108fba64600 Mon Sep 17 00:00:00 2001
From: dengzedong <dengzedong@email>
Date: 星期二, 05 十一月 2024 17:22:08 +0800
Subject: [PATCH] 图表参数 sql
---
iailab-module-model/iailab-module-model-biz/db/mysql.sql | 27 ++++++++++++++++++++++++++-
1 files changed, 26 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 ecd5752..05c9225 100644
--- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql
+++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
@@ -630,4 +630,29 @@
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '模型文件分组' ROW_FORMAT = Dynamic;
-alter table t_mm_predict_model add column `mpkprojectid` varchar(36) DEFAULT NULL;
\ No newline at end of file
+alter table t_mm_predict_model add column `mpkprojectid` varchar(36) DEFAULT NULL;
+
+CREATE TABLE `t_chart` (
+ `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 '修改时间',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `uk_chart_code` (`chart_code`),
+ KEY `index_id` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+
+CREATE TABLE `t_chart_param` (
+ `id` varchar(36) NOT NULL,
+ `chart_id` varchar(36) NOT NULL COMMENT '图表id',
+ `param_name` varchar(255) DEFAULT NULL COMMENT '参数名称',
+ `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 '修改时间',
+ 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
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
\ No newline at end of file
--
Gitblit v1.9.3