server/install/mysql/init/scan_central_db.sql

CREATE TABLE IF NOT EXISTS `sc_student`
(
    `id`                   bigint      NOT NULL AUTO_INCREMENT,
    `exam_id`              bigint      NOT NULL,
    `exam_number`          varchar(64) NOT NULL,
    `name`                 varchar(64) NOT NULL,
    `subject_code`         varchar(64) NOT NULL,
    `package_code`         varchar(64) DEFAULT NULL,
    `exam_site`            varchar(64) DEFAULT NULL,
    `exam_site_name`       varchar(64) DEFAULT NULL,
    `exam_room`            varchar(64) DEFAULT NULL,
    `seat_number`          varchar(16) DEFAULT NULL,
    `campus_name`          varchar(64) DEFAULT NULL,
    `campus_code`          varchar(64) DEFAULT NULL,
    `status`               varchar(16) NOT NULL,
    `omr_absent`           bit(1)      NOT NULL,
    `question_filled`      bit(1)      NOT NULL,
    `subjective_filled`    bit(1)      NOT NULL,
    `assigned`             bit(1)      NOT NULL,
    `absent_suspect`       bit(1)      NOT NULL,
    `incomplete`           bit(1)      NOT NULL,
    `card_number`          int         DEFAULT NULL,
    `device`               varchar(32) DEFAULT NULL,
    `paper_type`           varchar(16) NOT NULL,
    `exam_status`          varchar(32) DEFAULT NULL,
    `breach_code`          varchar(32) DEFAULT NULL,
    `file_upload_status`   varchar(16) DEFAULT NULL,
    `data_upload_status`   varchar(16) DEFAULT NULL,
    `check_mark`           bit(1)      NOT NULL,
    `assigned_check_count` int         DEFAULT NULL,
    `assigned_suspect`     bit(1)      NOT NULL,
    `image_check_status`   varchar(32) NOT NULL,
    `creator_id`           bigint      DEFAULT NULL,
    `updater_id`           bigint      DEFAULT NULL,
    `create_time`          bigint      DEFAULT NULL,
    `update_time`          bigint      DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `exam_student_subject` (`exam_id`, `subject_code`, `exam_number`),
    KEY `exam_assigned` (`exam_id`, `assigned`, `assigned_check_count`),
    KEY `exam_image_check_status` (`exam_id`, `image_check_status`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for sc_answer_card
-- ----------------------------
CREATE TABLE IF NOT EXISTS `sc_answer_card`
(
    `exam_id`      bigint       NOT NULL,
    `number`       int          NOT NULL,
    `code`         varchar(128) DEFAULT NULL,
    `paper_count`  int          NOT NULL,
    `path`         varchar(255) NOT NULL,
    `md5`          varchar(32)  NOT NULL,
    `source`       varchar(16)  NOT NULL,
    `need_adapte`  bit(1)       NOT NULL,
    `single_page`  bit(1)       NOT NULL,
    `slice_config` text         NOT NULL,
    `dpi`          int          DEFAULT NULL,
    `slice_name`   text         DEFAULT NULL,
    `parameter`    text         DEFAULT NULL,
    `remark`       varchar(255) DEFAULT NULL,
    `creator_id`   bigint       DEFAULT NULL,
    `updater_id`   bigint       DEFAULT NULL,
    `create_time`  bigint       DEFAULT NULL,
    `update_time`  bigint       DEFAULT NULL,
    PRIMARY KEY (`exam_id`, `number`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for sc_exam
-- ----------------------------
CREATE TABLE IF NOT EXISTS `sc_exam`
(
    `id`                               bigint       NOT NULL AUTO_INCREMENT,
    `name`                             varchar(128) NOT NULL,
    `enable`                           bit(1)       NOT NULL,
    `mode`                             varchar(16)  NOT NULL,
    `scan_by_package`                  bit(1)       NOT NULL,
    `allow_unexist_paper`              bit(1)       NOT NULL,
    `answer_front_card_type`           int          NOT NULL,
    `enable_single_page_answer`        bit(1)       NOT NULL,
    `enable_upload`                    bit(1)       NOT NULL,
    `enable_sync_verify`               bit(1)       NOT NULL,
    `exam_number_fill_count`           int         DEFAULT NULL,
    `paper_type_barcode_content`       text        DEFAULT NULL,
    `absent_barcode_content`           varchar(16) DEFAULT NULL,
    `image_transfer_mode`              varchar(32) DEFAULT NULL,
    `image_check_ratio`                double      DEFAULT NULL,
    `image_check_order`                varchar(50) DEFAULT NULL,
    `scanner_assigned_max_count`       int         DEFAULT NULL,
    `scanner_assigned_verify_password` varchar(50) DEFAULT NULL,
    `year`                             int         DEFAULT NULL,
    `year_half`                        int         DEFAULT NULL,
    `scan_site`                        varchar(50) DEFAULT NULL,
    `data_sync_time`                   bigint      DEFAULT NULL,
    `card_sync_time`                   bigint      DEFAULT NULL,
    `creator_id`                       bigint      DEFAULT NULL,
    `updater_id`                       bigint      DEFAULT NULL,
    `create_time`                      bigint      DEFAULT NULL,
    `update_time`                      bigint      DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for sc_exam_summary
-- ----------------------------
CREATE TABLE IF NOT EXISTS `sc_exam_summary`
(
    `id`                          bigint  NOT NULL,
    `student_count`               int(11) NOT NULL,
    `subject_count`               int(11) NOT NULL,
    `batch_count`                 int(11) NOT NULL,
    `answer_scanned_count`        int(11) NOT NULL,
    `answer_unexist_count`        int(11) NOT NULL,
    `answer_manual_absent_count`  int(11) NOT NULL,
    `answer_omr_absent_count`     int(11) NOT NULL,
    `answer_absent_suspect_count` int(11) NOT NULL,
    `answer_incomplete_count`     int(11) NOT NULL,
    `answer_assigned_count`       int(11) NOT NULL,
    `answer_mismatch_count`       int(11) NOT NULL,
    `answer_batch_count`          int(11) NOT NULL,
    `package_total_count`         int(11) NOT NULL,
    `package_scanned_count`       int(11) NOT NULL,
    `student_answer_count`        int(11) NOT NULL,
    `upload_progress`             double  NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for sc_omr_task
-- ----------------------------
CREATE TABLE IF NOT EXISTS `sc_omr_task`
(
    `id`           bigint      NOT NULL AUTO_INCREMENT,
    `exam_id`      bigint      NOT NULL,
    `group_id`     bigint      NOT NULL,
    `student_id`   bigint      NOT NULL,
    `paper_number` int         NOT NULL,
    `paper_id`     int         NOT NULL,
    `card_number`  int         NOT NULL,
    `status`       varchar(16) NOT NULL,
    `device`       varchar(64) DEFAULT NULL,
    `pages`        text        NOT NULL,
    `creator_id`   bigint      DEFAULT NULL,
    `updater_id`   bigint      DEFAULT NULL,
    `create_time`  bigint      DEFAULT NULL,
    `update_time`  bigint      DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `group_paper` (`group_id`, `paper_id`),
    KEY `exam_status` (`exam_id`, `status`, `student_id`),
    KEY `group_student` (`group_id`, `student_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for sc_package_card
-- ----------------------------
CREATE TABLE IF NOT EXISTS `sc_package_card`
(
    `id`          bigint       NOT NULL AUTO_INCREMENT,
    `exam_id`     bigint       NOT NULL,
    `path`        varchar(255) NOT NULL,
    `md5`         varchar(32)  NOT NULL,
    `source`      varchar(16)  NOT NULL,
    `creator_id`  bigint DEFAULT NULL,
    `updater_id`  bigint DEFAULT NULL,
    `create_time` bigint DEFAULT NULL,
    `update_time` bigint DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `exam` (`exam_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for sc_package_task
-- ----------------------------
CREATE TABLE IF NOT EXISTS `sc_package_task`
(
    `id`           bigint      NOT NULL AUTO_INCREMENT,
    `exam_id`      bigint      NOT NULL,
    `package_code` varchar(64) NOT NULL,
    `status`       varchar(16) NOT NULL,
    `device`       varchar(64) NOT NULL,
    `creator_id`   bigint DEFAULT NULL,
    `updater_id`   bigint DEFAULT NULL,
    `create_time`  bigint DEFAULT NULL,
    `update_time`  bigint DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `exam_package` (`exam_id`, `package_code`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for sc_scanner
-- ----------------------------
CREATE TABLE IF NOT EXISTS `sc_scanner`
(
    `device`          varchar(64)  NOT NULL,
    `device_name`     varchar(200) NOT NULL,
    `last_login_time` bigint       NOT NULL,
    `create_time`     bigint DEFAULT NULL,
    `update_time`     bigint DEFAULT NULL,
    PRIMARY KEY (`device`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for ss_system_config
-- ----------------------------
CREATE TABLE IF NOT EXISTS `sc_system_config`
(
    `id`                   bigint      NOT NULL AUTO_INCREMENT,
    `scanner_enable_login` bit(1)      NOT NULL,
    `scanner_password`     varchar(16) NOT NULL,
    `client_version`       varchar(16)  DEFAULT NULL,
    `client_uri`           varchar(255) DEFAULT NULL,
    `client_md5`           varchar(32)  DEFAULT NULL,
    `client_update_time`   bigint       DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_package_result`
(
    `exam_id`      bigint      NOT NULL,
    `package_code` varchar(64) NOT NULL,
    `device`       varchar(64) NOT NULL,
    `path`         text        NOT NULL,
    `assigned`     bit(1)      NOT NULL,
    `creator_id`   bigint DEFAULT NULL,
    `updater_id`   bigint DEFAULT NULL,
    `create_time`  bigint DEFAULT NULL,
    `update_time`  bigint DEFAULT NULL,
    `upload_time`  bigint DEFAULT NULL,
    PRIMARY KEY (`exam_id`, `package_code`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_scanner_card`
(
    `exam_id`     bigint      NOT NULL,
    `device`      varchar(64) NOT NULL,
    `card_number` int         NOT NULL,
    `creator_id`  bigint DEFAULT NULL,
    `updater_id`  bigint DEFAULT NULL,
    `create_time` bigint DEFAULT NULL,
    `update_time` bigint DEFAULT NULL,
    PRIMARY KEY (`exam_id`, `device`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_batch`
(
    `id`                  bigint      NOT NULL AUTO_INCREMENT,
    `exam_id`             bigint      NOT NULL,
    `device`              varchar(64) NOT NULL,
    `package_code`        varchar(64) DEFAULT NULL,
    `subject_code`        varchar(64) DEFAULT NULL,
    `scan_count`          int         NOT NULL,
    `assigned_count`      int         NOT NULL,
    `status`              varchar(16) NOT NULL,
    `verify_status`       varchar(16) DEFAULT NULL,
    `check_status`        varchar(16) DEFAULT NULL,
    `check_image_user_id` bigint      DEFAULT NULL,
    `check_image_time`    bigint      DEFAULT NULL,
    `creator_id`          bigint      DEFAULT NULL,
    `updater_id`          bigint      DEFAULT NULL,
    `create_time`         bigint      DEFAULT NULL,
    `update_time`         bigint      DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `exam_verify_status` (`exam_id`, `verify_status`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_batch_paper`
(
    `batch_id`     bigint(20) NOT NULL,
    `student_id`   bigint(20) NOT NULL,
    `paper_number` int(11)    NOT NULL,
    `paper_id`     bigint(20) NOT NULL,
    `card_number`  int(11)    NOT NULL,
    `assigned`     bit(1)     NOT NULL,
    `need_check`   bit(1)     NOT NULL,
    `creator_id`   bigint DEFAULT NULL,
    `updater_id`   bigint DEFAULT NULL,
    `create_time`  bigint DEFAULT NULL,
    `update_time`  bigint DEFAULT NULL,
    PRIMARY KEY (`batch_id`, `student_id`, `paper_number`),
    UNIQUE KEY `paper_id` (`paper_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_paper`
(
    `id`                bigint       NOT NULL AUTO_INCREMENT,
    `exam_id`           bigint       NOT NULL,
    `card_number`       int          NOT NULL,
    `number`            int          NOT NULL,
    `page_count`        int          NOT NULL,
    `mismatch`          bit(1)       NOT NULL,
    `assigned`          bit(1)       NOT NULL,
    `assigned_suspect`  bit(1)       NOT NULL,
    `question_filled`   bit(1)       NOT NULL,
    `subjective_filled` bit(1)       NOT NULL,
    `omr_exam_number`   varchar(255) NOT NULL,
    `creator_id`        bigint DEFAULT NULL,
    `updater_id`        bigint DEFAULT NULL,
    `create_time`       bigint DEFAULT NULL,
    `update_time`       bigint DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `mismatch` (`exam_id`, `mismatch`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_paper_page`
(
    `paper_id`    bigint       NOT NULL,
    `page_index`  int          NOT NULL,
    `absent`      text     DEFAULT NULL,
    `breach`      text     DEFAULT NULL,
    `paper_type`  text     DEFAULT NULL,
    `question`    text     DEFAULT NULL,
    `selective`   text     DEFAULT NULL,
    `sheet_path`  varchar(255) NOT NULL,
    `slice_path`  text     DEFAULT NULL,
    `recog_data`  longtext DEFAULT NULL,
    `creator_id`  bigint   DEFAULT NULL,
    `updater_id`  bigint   DEFAULT NULL,
    `create_time` bigint   DEFAULT NULL,
    `update_time` bigint   DEFAULT NULL,
    PRIMARY KEY (`paper_id`, `page_index`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_paper_structure`
(
    `id`              bigint      NOT NULL AUTO_INCREMENT,
    `exam_id`         bigint      NOT NULL,
    `card_number`     int         NOT NULL,
    `paper_number`    int         NOT NULL,
    `page_index`      int         NOT NULL,
    `field`           varchar(16) NOT NULL,
    `question_number` int         NOT NULL,
    `single`          bit(1)      NOT NULL,
    `creator_id`      bigint DEFAULT NULL,
    `updater_id`      bigint DEFAULT NULL,
    `create_time`     bigint DEFAULT NULL,
    `update_time`     bigint DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `IDX_PAPER_STRUCTURE_001` (`exam_id`, `card_number`, `paper_number`, `page_index`, `field`,
                                          `question_number`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_question`
(
    `id`           int(11)      NOT NULL AUTO_INCREMENT COMMENT '主键',
    `exam_id`      int(11)      NOT NULL COMMENT '考试ID',
    `subject_code` varchar(32)  NOT NULL COMMENT '科目代码',
    `paper_type`   varchar(8)   NOT NULL COMMENT '试卷类型',
    `objective`    tinyint(1)   NOT NULL COMMENT '是否客观题',
    `main_number`  int(11)      NOT NULL COMMENT '大题号',
    `sub_number`   varchar(32)  NOT NULL COMMENT '小题号',
    `main_title`   varchar(128) NOT NULL COMMENT '大题名称',
    `total_score`  double DEFAULT NULL COMMENT '满分',
    `creator_id`   bigint DEFAULT NULL,
    `updater_id`   bigint DEFAULT NULL,
    `create_time`  bigint DEFAULT NULL,
    `update_time`  bigint DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `index1` (`exam_id`, `subject_code`, `objective`, `paper_type`, `main_number`, `sub_number`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4 COMMENT ='小题信息表';


CREATE TABLE IF NOT EXISTS `sc_omr_group`
(
    `id`          bigint      NOT NULL AUTO_INCREMENT,
    `exam_id`     bigint      NOT NULL,
    `subject_code`       varchar(64) NOT NULL,
    `fixed`       bit(1)      NOT NULL,
    `stage`       varchar(16) NOT NULL,
    `conditions`  text        NOT NULL,
    `total_count` int         NOT NULL,
    `creator_id`  bigint DEFAULT NULL,
    `updater_id`  bigint DEFAULT NULL,
    `create_time` bigint DEFAULT NULL,
    `update_time` bigint DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `exam_fixed` (`exam_id`,`subject_code` , `fixed`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;


CREATE TABLE IF NOT EXISTS `sc_refix_batch`
(
    `id`           bigint NOT NULL AUTO_INCREMENT,
    `exam_id`      bigint NOT NULL,
    `card_number`  int    NOT NULL,
    `conditions`   text   NOT NULL,
    `update_slice` bit(1) NOT NULL,
    `total_count`  int    NOT NULL,
    `sucess_count` int    NOT NULL,
    `finished`     bit(1) NOT NULL,
    `creator_id`   bigint DEFAULT NULL,
    `updater_id`   bigint DEFAULT NULL,
    `create_time`  bigint DEFAULT NULL,
    `update_time`  bigint DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_student_paper`
(
    `student_id`   bigint NOT NULL,
    `paper_number` int    NOT NULL,
    `paper_id`     bigint NOT NULL,
    `create_time`  bigint DEFAULT NULL,
    `update_time`  bigint DEFAULT NULL,
    PRIMARY KEY (`student_id`, `paper_number`),
    UNIQUE KEY `paper_id` (`paper_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_subject`
(
    `exam_id`                    bigint      NOT NULL,
    `code`                       varchar(64) NOT NULL,
    `name`                       varchar(64) NOT NULL,
    `paper_type_barcode_content` text   DEFAULT NULL,
    `creator_id`                 bigint DEFAULT NULL,
    `updater_id`                 bigint DEFAULT NULL,
    `create_time`                bigint DEFAULT NULL,
    `update_time`                bigint DEFAULT NULL,
    PRIMARY KEY (`exam_id`, `code`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_file_property`
(
    `path`        varchar(255) NOT NULL,
    `md5`         varchar(32)  NOT NULL,
    `exam_id`     bigint       NOT NULL,
    `file_size`   bigint       NOT NULL,
    `create_time` bigint DEFAULT NULL,
    `update_time` bigint DEFAULT NULL,
    PRIMARY KEY (`path`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_user`
(
    `id`          int(11)     NOT NULL AUTO_INCREMENT,
    `login_name`  varchar(64) NOT NULL,
    `name`        varchar(64) NOT NULL,
    `password`    varchar(64) NOT NULL,
    `role`        varchar(16) NOT NULL,
    `enable`      tinyint(1)  NOT NULL,
    `device`      varchar(64) DEFAULT NULL,
    `creator_id`  bigint      DEFAULT NULL,
    `updater_id`  bigint      DEFAULT NULL,
    `create_time` bigint      DEFAULT NULL,
    `update_time` bigint      DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `login_name` (`login_name`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_adapte_file`
(
    `exam_id`     bigint       NOT NULL,
    `card_number` int          NOT NULL,
    `role`        varchar(16)  NOT NULL,
    `device`      varchar(64)  NOT NULL,
    `uri`         varchar(255) NOT NULL,
    `md5`         varchar(32)  NOT NULL,
    `dpi`         int    DEFAULT NULL,
    `create_time` bigint DEFAULT NULL,
    `update_time` bigint DEFAULT NULL,
    PRIMARY KEY (`exam_id`, `card_number`, `role`, `device`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_student_answer_task`
(
    `id`          bigint      NOT NULL AUTO_INCREMENT,
    `exam_id`     bigint      NOT NULL,
    `group_id`    bigint      NOT NULL,
    `student_id`  bigint      NOT NULL,
    `status`      varchar(16) NOT NULL,
    `device`      varchar(64) DEFAULT NULL,
    `creator_id`  bigint      DEFAULT NULL,
    `updater_id`  bigint      DEFAULT NULL,
    `create_time` bigint      DEFAULT NULL,
    `update_time` bigint      DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `group_student` (`group_id`, `student_id`),
    KEY `exam_status` (`exam_id`, `student_id`, `status`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_student_answer_group`
(
    `id`          bigint NOT NULL AUTO_INCREMENT,
    `exam_id`     bigint NOT NULL,
    `conditions`  text   NOT NULL,
    `total_count` int    NOT NULL,
    `creator_id`  bigint DEFAULT NULL,
    `updater_id`  bigint DEFAULT NULL,
    `create_time` bigint DEFAULT NULL,
    `update_time` bigint DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_answer_card_subject`
(
    `exam_id`      bigint      NOT NULL,
    `card_number`  int         NOT NULL,
    `subject_code` varchar(64) NOT NULL,
    `create_time`  bigint DEFAULT NULL,
    `update_time`  bigint DEFAULT NULL,
    PRIMARY KEY (`exam_id`, `card_number`, `subject_code`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for sc_assigned_check_history
-- ----------------------------
CREATE TABLE IF NOT EXISTS `sc_assigned_check_history`
(
    `id`          bigint NOT NULL AUTO_INCREMENT,
    `exam_id`     bigint NOT NULL,
    `student_id`  bigint NOT NULL,
    `user_id`     bigint NOT NULL,
    `creator_id`  bigint DEFAULT NULL,
    `updater_id`  bigint DEFAULT NULL,
    `create_time` bigint DEFAULT NULL,
    `update_time` bigint DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `student_user` (`student_id`, `user_id`),
    KEY `student` (`student_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `sc_mark_site`
(
    `id`           bigint       NOT NULL AUTO_INCREMENT,
    `exam_id`      bigint       NOT NULL,
    `subject_code` varchar(100) NOT NULL,
    `paper_type`   varchar(100) NOT NULL,
    `odd_number`   varchar(100) NOT NULL,
    `even_number`  varchar(100) NOT NULL,
    `creator_id`   bigint DEFAULT NULL,
    `updater_id`   bigint DEFAULT NULL,
    `create_time`  bigint DEFAULT NULL,
    `update_time`  bigint DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `exam_subject_paper` (`exam_id`, `subject_code`, `paper_type`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;