-- auto-generated definition
create table consolidate_question
(
 question_id int null comment '题目标识',
 que_content text null comment '题目正文',
 id int not null comment '题目id
'
 primary key,
 que_point varchar(50) null comment '题目知识点',
 que_difficulty varchar(10) null comment '题目难易度',
 que_answer varchar(255) null comment '题目答案'
)
 comment '巩固类题型表' charset = utf8mb4;

-- 考试安排
-- auto-generated definition
create table exam_arrangement
(
 id int not null
 primary key,
 exam_paper_id int null comment '试卷id',
 exam_student_id int null comment '考试学生id',
 exam_begin_time datetime null comment '考试开始时间',
 exam_end_time datetime null comment '考试结束时间',
 is_delete int default 0 null comment '是否删除 0 - 未删除 1 - 已删除',
 constraint exam_arrangement_id_uindex
 unique (id)
)
 comment '考试安排';

-- 答题卡
-- auto-generated definition
create table exam_card
(
 id int auto_increment
 primary key,
 student_id int null comment '学生id',
 exam_paper_id int null comment '试卷id',
 choose_topic1_id int null comment '题目1题号',
 choose_topic1_ans int null comment '题目1标准答案',
 choose_topic1_real int null comment '题目1实际作答',
 choose_topic2_id int null comment '题目2题号',
 choose_topic2_ans int null comment '题目2标准答案',
 choose_topic2_real int null comment '题目2实际作答',
 choose_topic3_id int null comment '题目3题号',
 choose_topic3_ans int null comment '题目3标准答案',
 choose_topic3_real int null comment '题目3实际作答',
 choose_topic4_id int null comment '题目4题号',
 choose_topic4_ans int null comment '题目4标准答案',
 choose_topic4_real int null comment '题目4实际作答',
 choose_topic5_id int null comment '题目5题号',
 choose_topic5_ans int null comment '题目5标准答案',
 choose_topic5_real int null comment '题目55实际作答',
 choose_topic6_id int null comment '题目6题号',
 choose_topic6_ans int null comment '题目6标准答案',
 choose_topic6_real int null comment '题目6实际作答',
 choose_topic7_id int null comment '题目7题号',
 choose_topic7_ans int null comment '题目7标准答案',
 choose_topic7_real int null comment '题目7实际作答',
 choose_topic8_id int null comment '题目8题号',
 choose_topic8_ans int null comment '题目8标准答案',
 choose_topic8_real int null comment '题目8实际答案',
 choose_topic9_id int null comment '题目9题号',
 choose_topic9_ans int null comment '题目9标准答案',
 choose_topic9_real int null comment '题目9实际作答',
 choose_topic10_id int null comment '题目10题号',
 choose_topic10_ans int null comment '题目10标准答案',
 choose_topic10_real int null comment '题目10实际作答',
 choose_topic1_point int null comment '题目1实际获得分数',
 choose_topic2_point int null comment '题目2实际获得分数',
 choose_topic3_point int null comment '题目3实际获得分数',
 choose_topic4_point int null comment '题目4实际获得分数',
 choose_topic5_point int null comment '题目5实际获得分数',
 choose_topic6_point int null comment '题目6实际获得分数',
 choose_topic7_point int null comment '题目7实际获得分数',
 choose_topic8_point int null comment '题目8实际获得分数',
 choose_topic9_point int null comment '题目9实际获得分数',
 choose_topic10_point int null comment '题目10实际获得分数',
 blank_topic1_id int null comment '填空1题号',
 blank_topic1_ans int null comment '填空1标准答案',
 blank_topic1_real int null comment '填空1实际答案',
 blank_topic2_id int null comment '填空2题号',
 blank_topic2_ans int null comment '填空2标准答案',
 blank_topic2_real int null comment '填空2实际作答',
 blank_topic3_id int null comment '填空3题号',
 blank_topic3_ans int null comment '填空3标准答案',
 blank_topic3_real int null comment '填空3实际作答',
 blank_topic4_id int null comment '填空4题号',
 blank_topic4_ans int null comment '填空4标准答案',
 blank_topic4_real int null comment '填空4实际作答',
 blank_topic5_id int null comment '填空5题号',
 blank_topic5_ans int null comment '填空5标准答案',
 blank_topic5_real int null comment '填空5实际作答',
 blank_topic1_point int null comment '填空1实际得分',
 blank_topic2_point int null comment '填空2实际得分',
 blank_topic3_point int null comment '填空3实际得分',
 blank_topic4_point int null comment '填空4实际得分',
 blank_topic5_point int null comment '填空5实际得分',
 obj_topic1_id int null comment '客观题1题号',
 obj_topic1_real int null comment '客观题1实际作答',
 obj_topic2_id int null comment '客观题2题号',
 obj_topic2_real int null comment '客观题2实际作答',
 obj_topic3_id int null comment '客观题3题号',
 obj_topic3_real int null comment '客观题3实际作答',
 obj_topic4_id int null comment '客观题4题号',
 obj_topic4_real int null comment '客观题4实际作答',
 obj_topic5_id int null comment '客观题5题号',
 obj_topic5_real int null comment '客观题5实际作答',
 obj_topic1_point int null comment '客观题1实际得分',
 obj_topic2_point int null comment '客观题2实际得分',
 obj_topic3_point int null comment '客观题3实际得分',
 obj_topic4_point int null comment '客观题4实际得分',
 obj_topic5_point int null comment '客观题5实际得分',
 total_point int null comment '总分',
 is_delete int default 0 null comment '是否删除 0 - 未删除 1 - 已删除',
 constraint exam_card_id_uindex
 unique (id)
)
 comment '答题卡';

-- auto-generated definition
create table exam_paper
(
 id int auto_increment
 primary key,
 title varchar(255) null comment '试卷标题',
 total_score int null comment '总分',
 difficulty_avg int null comment '难度',
 choice_num int null comment '选择题数量',
 fill_num int null comment '填空题数量',
 essay_num int null comment '问答题数量'
)
 comment '试卷表' charset = utf8mb4
 auto_increment = 5;

-- auto-generated definition
create table exam_paper_question
(
 id int auto_increment comment 'id'
 primary key,
 exam_paper_id int null comment '试卷id',
 question_id int null comment '题目id',
 score double null comment '分值'
)
 comment '试卷中题目表' charset = utf8mb4;

-- auto-generated definition
create table question_bank
(
 question_id int auto_increment comment '题目标识'
 primary key,
 question_type int not null comment '题目类型(1选择题,2填空题,3问答题)',
 question_content text not null comment '题目正文',
 question_image varchar(255) null comment '主观题图片',
 question_options varchar(255) null comment '选择题选项'
)
 comment '题库表' auto_increment = 2;

-- auto-generated definition
create table question_property
(
 id int not null comment '题目id'
 primary key,
 question_answer varchar(255) not null comment '题目答案',
 kwonledge_point varchar(255) not null comment '题目知识点',
 question_difficulty int not null comment '题目难易度',
 question_chapter varchar(255) not null comment '题目所在课程的章节',
 error_rate double not null comment '题目出错率',
 error_prone varchar(255) not null comment '题目易错点'
)
 comment '题目性质表';

-- auto-generated definition
create table student
(
 stu_id int not null
 primary key,
 stu_name char(20) not null,
 stu_password char(30) not null,
 stu_age int null,
 stu_sex char(2) null
)
 comment '学生表';

-- auto-generated definition
create table teacher
(
 teacher_id varchar(20) not null comment '教师标识'
 primary key,
 teacher_name varchar(20) not null comment '教师名字',
 password varchar(20) not null comment '教师密码'
)
 comment '教师表';

-- auto-generated definition
create table wrong_question
(
 id int auto_increment
 primary key,
 test_id int not null,
 stu_id int not null,
 question_id int not null,
 level varchar(10) not null,
 answer varchar(50) not null,
 points varchar(50) null,
 wrong_answer varchar(50) null
)
 charset = utf8mb4;