- student_id (primary key)
- name 学生姓名
- password 密码
- question_id (primary key)
- stem 题干内容
- selections (string) 使用某个分隔符 @caixunkun@ 切分选项
- answer 题目答案
- test_paper_id (primary key)
- title 试卷名称(仅供老师查看)
- duration 考试持续时间
- test_id (primary key)
- test_paper_id (foreign key)
- title 测试名称(仅供学生查看)
- start_time 测试开始时间 type: DateTime(YYYY-MM-DD HH:MM:SS)
- end_time 测试截止时间 type: DateTime(YYYY-MM-DD HH:MM:SS)
- test_paper_id (foreign key)
- question_id (foreign key)
- score 每道题的分值
- student_id (foreign key)
- test_id (foreign key)
- question_id (foreign key)
- selection 学生选择的答案