-- 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;