-- ----------------------------
-- 课时批次与学员关系表
-- ----------------------------
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;
