From 8458e64aab474c0fc2f49ae4ff22fb11ce5cf6e2 Mon Sep 17 00:00:00 2001 From: “djh” <“3298565835@qq.com”> Date: 星期一, 11 十一月 2024 16:55:28 +0800 Subject: [PATCH] 批次新增学员查询条件，新增题目导入接口 --- exam-admin/src/main/resources/db/migration/V20240604001_exam_record.sql | 3 +-- 1 files changed, 1 insertions(+), 2 deletions(-) diff --git a/exam-admin/src/main/resources/db/migration/V20240604001_exam_record.sql b/exam-admin/src/main/resources/db/migration/V20240604001_exam_record.sql index e4410e7..a3589e0 100644 --- a/exam-admin/src/main/resources/db/migration/V20240604001_exam_record.sql +++ b/exam-admin/src/main/resources/db/migration/V20240604001_exam_record.sql @@ -1,14 +1,13 @@ -- ---------------------------- -- 线下教育登记表 -- ---------------------------- -drop table if exists `train_exam`.`ex_exam_record`; CREATE TABLE `train_exam`.`ex_exam_record` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' , `company_id` bigint(20) NOT NULL COMMENT '公司id', `student_id` bigint(20) NOT NULL COMMENT '学员id', `plan_name` varchar(50) NOT NULL COMMENT '计划名称', `course_name` varchar(50) NOT NULL COMMENT '课程名称', -`level` varchar(20) NOT NULL COMMENT '培训等级', +`level` tinyint NOT NULL DEFAULT 1 COMMENT '培训等级(1公司级 2部门级 3车间级 默认1)', `period` int NOT NULL COMMENT '要求课时(分)', `actual_period` int NOT NULL COMMENT '实际课时(分)', `score` int NOT NULL COMMENT '考试成绩', -- Gitblit v1.9.2