From cb49dac543bedaa42503e343356841293f6b13de Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期三, 11 九月 2024 17:26:06 +0800
Subject: [PATCH] 指标分类

---
 iailab-module-model/iailab-module-model-biz/db/mysql.sql |   12 ++++++------
 1 files changed, 6 insertions(+), 6 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 fd22ec0..e0c8110 100644
--- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql
+++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
@@ -256,8 +256,8 @@
 create table t_st_schedule_scheme
 (
   `id`                varchar(36) not null COMMENT 'ID',
-  `code`              varchar(20) COMMENT '编号',
-  `name`              varchar(20) COMMENT '名称',
+  `code`              varchar(20) not null COMMENT '编号',
+  `name`              varchar(20) not null COMMENT '名称',
   `trigger_method`    varchar(20) COMMENT '触发方式',
   `trigger_condition` varchar(20) COMMENT '触发条件',
   `schedule_obj`      varchar(20) COMMENT '调整对象',
@@ -280,8 +280,8 @@
 create table t_st_schedule_model
 (
   `id`              varchar(36) not null COMMENT 'ID',
-  `model_code`      varchar(64) COMMENT '模型编号',
-  `model_name`      varchar(64) COMMENT '模型名称',
+  `model_code`      varchar(64) not null COMMENT '模型编号',
+  `model_name`      varchar(64) not null COMMENT '模型名称',
   `model_type`      varchar(64) COMMENT '模型类型',
   `class_name`      varchar(128) COMMENT '类名',
   `method_name`     varchar(64) COMMENT '方法名',
@@ -304,7 +304,7 @@
   t_st_schedule_model_param
 (
   id                  varchar(36) not null,
-  modelid             varchar(64),
+  modelid             varchar(64) not null,
   modelparamname      varchar(64),
   modelparamid        varchar(64),
   modelparamorder     integer,
@@ -320,7 +320,7 @@
   t_st_schedule_model_setting
 (
   `id`        varchar(36) not null,
-  `modelid`   varchar(64),
+  `modelid`   varchar(64) not null,
   `key`       varchar(64),
   `value`     varchar(64),
   `valuetype` varchar(64),

--
Gitblit v1.9.3