GitHub - HuadongYang/examArrange

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 5 Commits
.idea		.idea
src/main		src/main
target		target
.gitignore		.gitignore
pom.xml		pom.xml
readme.txt		readme.txt
学生信息(1).xlsx		学生信息(1).xlsx
教室.xlsx		教室.xlsx

Repository files navigation

mysql数据库
CREATE TABLE `exam` (
  `id` int NOT NULL AUTO_INCREMENT,
  `grade` varchar(45) DEFAULT NULL,
  `major` varchar(45) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `startTime` datetime DEFAULT NULL,
  `endTime` datetime DEFAULT NULL,
  `subject` varchar(45) DEFAULT NULL,
  `examcol` varchar(45) DEFAULT NULL,
  `duration` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `classroom` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(450) DEFAULT NULL,
  `area` varchar(45) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `floorNum` varchar(45) DEFAULT NULL,
  `numTotal` int DEFAULT NULL,
  `numExam` int DEFAULT NULL,
  `canClass` varchar(45) DEFAULT NULL,
  `canBorrow` varchar(45) DEFAULT NULL,
  `canExam` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=889 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `student` (
  `id` varchar(45) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `level` varchar(45) DEFAULT NULL,
  `major` varchar(45) DEFAULT NULL,
  `classNum` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `teacher` (
  `id` int NOT NULL AUTO_INCREMENT,
  `major` varchar(45) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `phone` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`,`major`)
) ENGINE=InnoDB AUTO_INCREMENT=6463 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `relation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `examId` int DEFAULT NULL,
  `studentId` varchar(45) DEFAULT NULL,
  `teacherId` int DEFAULT NULL,
  `classroomId` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `relation_student` (
  `id` int NOT NULL AUTO_INCREMENT,
  `relationId` int DEFAULT NULL,
  `studentId` varchar(45) DEFAULT NULL,
  `order` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6958 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `setting` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(45) DEFAULT NULL,
  `time` datetime(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `account` varchar(45) DEFAULT NULL,
  `password` varchar(45) DEFAULT NULL,
  `role` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9873 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;