| | |
|---|
| | | -- ---------------------------- |
|---|
| | | -- 学员与练习题关系表 |
|---|
| | | -- ---------------------------- |
|---|
| | | drop table if exists `train_exam`.`ex_exercise_answer`; |
|---|
| | | CREATE TABLE `train_exam`.`ex_exercise_answer` ( |
|---|
| | | `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' , |
|---|
| | | `bank_id` bigint(20) NOT NULL COMMENT '题库id', |
|---|
| | |
|---|
| | | `remark` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', |
|---|
| | | `version` int NULL DEFAULT 0 COMMENT '乐观锁', |
|---|
| | | PRIMARY KEY (`id`) USING BTREE, |
|---|
| | | UNIQUE KEY `paper_student_id` (`student_id`,`question_id`) |
|---|
| | | UNIQUE KEY `question_student_id` (`student_id`,`question_id`) |
|---|
| | | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '学员与练习题关系表' ROW_FORMAT = DYNAMIC; |
|---|
