-- ----------------------------
|
-- 课时批次与学员关系表
|
-- ----------------------------
|
drop table if exists `train_exam`.`ex_phase_student`;
|
CREATE TABLE `train_exam`.`ex_phase_student` (
|
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' ,
|
`phase_id` bigint(20) NOT NULL COMMENT '课时批次id',
|
`student_id` bigint(20) NOT NULL COMMENT '学员id',
|
`create_id` bigint(20) NOT NULL COMMENT '创建的管理员用户id',
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `phase_student_id`(`phase_id`, `student_id`)
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课时批次与学员关系表' ROW_FORMAT = DYNAMIC;
|
