online-exam-system
/
examsystem.sql

/*
SQLyog Ultimate v12.5.0 (64 bit)
MySQL - 8.0.19 : Database - examsystem
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`examsystem` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `examsystem`;

/*Table structure for table `class` */

DROP TABLE IF EXISTS `class`;

CREATE TABLE `class` (
  `class_id` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '班级ID',
  `name` varchar(20) NOT NULL COMMENT '班级名称',
  `class_info` varchar(900) DEFAULT NULL COMMENT '备注信息',
  `user_id` varchar(19) NOT NULL COMMENT '创建者',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modify` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `class` */

insert  into `class`(`class_id`,`name`,`class_info`,`user_id`,`gmt_create`,`gmt_modify`) values
('1','软件工程3班','哈哈哈','1','2021-05-06 00:00:00','2021-05-27 00:00:00');

/*Table structure for table `class_user` */

DROP TABLE IF EXISTS `class_user`;

CREATE TABLE `class_user` (
  `id` varchar(19) NOT NULL COMMENT '编号',
  `audit_status` tinyint(1) NOT NULL DEFAULT '-1' COMMENT '审核状态',
  `user_id` varchar(19) NOT NULL COMMENT '用户ID',
  `class_id` varchar(19) NOT NULL COMMENT '班级ID',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modify` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `class_user` */

insert  into `class_user`(`id`,`audit_status`,`user_id`,`class_id`,`gmt_create`,`gmt_modify`) values
('1',-1,'1','1','2021-05-06 00:00:00','2021-05-21 00:00:00');

/*Table structure for table `exam` */

DROP TABLE IF EXISTS `exam`;

CREATE TABLE `exam` (
  `id` varchar(19) NOT NULL COMMENT '编号',
  `paper_id` varchar(19) NOT NULL COMMENT '试卷ID',
  `student_id` varchar(19) NOT NULL COMMENT '学生ID',
  `score` double NOT NULL DEFAULT '0' COMMENT '试卷分数',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '考试状态',
  `objective` varchar(100) DEFAULT NULL COMMENT '用户客观题答案',
  `subjective` varchar(100) DEFAULT NULL COMMENT '用户主观题答案',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modify` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `exam` */

insert  into `exam`(`id`,`paper_id`,`student_id`,`score`,`status`,`objective`,`subjective`,`start_time`,`gmt_create`,`gmt_modify`) values
('1','1','1',50,0,NULL,NULL,'2021-05-13 00:00:00','2021-05-20 00:00:00','2021-05-05 00:00:00');

/*Table structure for table `paper` */

DROP TABLE IF EXISTS `paper`;

CREATE TABLE `paper` (
  `paper_id` varchar(19) NOT NULL COMMENT '试卷ID',
  `name` varchar(100) NOT NULL COMMENT '试卷名称',
  `total_score` int NOT NULL DEFAULT '100' COMMENT '总分',
  `pass_score` double NOT NULL DEFAULT '60' COMMENT '及格分',
  `paper_info` varchar(900) DEFAULT NULL COMMENT '备注信息',
  `limit_time` int NOT NULL COMMENT '时间限制',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modify` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`paper_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `paper` */

insert  into `paper`(`paper_id`,`name`,`total_score`,`pass_score`,`paper_info`,`limit_time`,`gmt_create`,`gmt_modify`) values
('1','期末测试',100,60,NULL,60,'2021-05-19 00:00:00','2021-05-12 00:00:00');

/*Table structure for table `paper_class` */

DROP TABLE IF EXISTS `paper_class`;

CREATE TABLE `paper_class` (
  `id` varchar(19) NOT NULL COMMENT '编号',
  `class_id` varchar(19) DEFAULT NULL COMMENT '班级ID',
  `paper_id` varchar(19) NOT NULL COMMENT '试卷ID',
  `start` datetime NOT NULL COMMENT '开始时间',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modify` datetime NOT NULL COMMENT '修该时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `paper_class` */

insert  into `paper_class`(`id`,`class_id`,`paper_id`,`start`,`gmt_create`,`gmt_modify`) values
('1','1','1','2021-05-21 00:00:00','2021-05-05 00:00:00','2021-05-14 00:00:00');

/*Table structure for table `question` */

DROP TABLE IF EXISTS `question`;

CREATE TABLE `question` (
  `question_id` varchar(19) NOT NULL COMMENT '试题ID',
  `content` text NOT NULL COMMENT '试题内容',
  `answer` varchar(1000) DEFAULT NULL COMMENT '试题答案',
  `analysis` varchar(3000) DEFAULT NULL COMMENT '答案解析',
  `user_id` varchar(19) NOT NULL COMMENT '命题人ID',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '题目类型',
  `difficulty` tinyint(1) NOT NULL DEFAULT '0' COMMENT '题目难度',
  `repository_id` varchar(19) NOT NULL COMMENT '归属题库',
  `audit_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '审核状态',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modify` datetime DEFAULT NULL COMMENT '修该时间',
  PRIMARY KEY (`question_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `question` */

insert  into `question`(`question_id`,`content`,`answer`,`analysis`,`user_id`,`type`,`difficulty`,`repository_id`,`audit_status`,`gmt_create`,`gmt_modify`) values
('1','看脸宽发送追随','123','123','1',0,0,'1',0,'2021-05-01 00:00:00','2021-05-05 00:00:00');

/*Table structure for table `question_paper` */

DROP TABLE IF EXISTS `question_paper`;

CREATE TABLE `question_paper` (
  `id` varchar(19) NOT NULL COMMENT '编号',
  `paper_id` varchar(19) NOT NULL COMMENT '试卷ID',
  `question_id` varchar(19) NOT NULL COMMENT '试题ID',
  `score` double NOT NULL COMMENT '单题分数',
  `num` int NOT NULL COMMENT '题目题号',
  `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modify` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `question_paper` */

insert  into `question_paper`(`id`,`paper_id`,`question_id`,`score`,`num`,`gmt_create`,`gmt_modify`) values
('1','1','1',2,3,'2021-05-05 00:00:00','2021-05-13 00:00:00');

/*Table structure for table `repository` */

DROP TABLE IF EXISTS `repository`;

CREATE TABLE `repository` (
  `repository_id` varchar(19) NOT NULL COMMENT '题库ID',
  `name` varchar(100) NOT NULL COMMENT '题库名称',
  `info` varchar(900) DEFAULT NULL COMMENT '题库备注',
  `user_id` varchar(19) NOT NULL COMMENT '创建者ID',
  `open_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '开放状态',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modify` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`repository_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `repository` */

insert  into `repository`(`repository_id`,`name`,`info`,`user_id`,`open_status`,`gmt_create`,`gmt_modify`) values
('1','数学',NULL,'1',0,'2021-05-03 00:00:00','2021-05-06 00:00:00');

/*Table structure for table `role` */

DROP TABLE IF EXISTS `role`;

CREATE TABLE `role` (
  `role_id` varchar(19) NOT NULL COMMENT '角色ID',
  `role_name` varchar(20) NOT NULL COMMENT '角色名称',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modify` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `role` */

insert  into `role`(`role_id`,`role_name`,`gmt_create`,`gmt_modify`) values
('1','学生','2021-05-11 00:00:00','2021-05-14 00:00:00');

/*Table structure for table `role_user` */

DROP TABLE IF EXISTS `role_user`;

CREATE TABLE `role_user` (
  `id` varchar(19) NOT NULL COMMENT '编号',
  `user_id` varchar(19) NOT NULL COMMENT '用户ID',
  `role_id` varchar(19) NOT NULL COMMENT '角色ID',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modify` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `role_user` */

insert  into `role_user`(`id`,`user_id`,`role_id`,`gmt_create`,`gmt_modify`) values
('1','1','1','2021-05-04 00:00:00','2021-05-10 00:00:00');

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `user_id` varchar(19) NOT NULL COMMENT '用户ID',
  `phone` varchar(11) NOT NULL COMMENT '用户手机号码',
  `password` varchar(50) NOT NULL COMMENT '密码',
  `email` varchar(19) NOT NULL COMMENT '邮箱',
  `sex` tinyint(1) NOT NULL DEFAULT '1' COMMENT '性别',
  `name` varchar(19) NOT NULL COMMENT '真实姓名',
  `avatar` varchar(300) DEFAULT NULL COMMENT '头像',
  `birth` datetime DEFAULT NULL COMMENT '出生日期',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modify` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `user` */

insert  into `user`(`user_id`,`phone`,`password`,`email`,`sex`,`name`,`avatar`,`birth`,`gmt_create`,`gmt_modify`) values
('1','15815479852','123456','qq@qqcom',1,'薇恩',NULL,'2020-07-16 00:00:00','2021-05-10 00:00:00','2021-05-11 00:00:00');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;