35 Star 321 Fork 118

辣条老板 / 考试君 - Backend

Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
Clone or download
examking.sql 18.72 KB
Copy Edit Web IDE Raw Blame History
辣条老板 authored 2021-04-08 23:08 . 更新Furion到1.18.6&解决跨域
/*
Navicat Premium Data Transfer
Source Server : 127.0.0.1
Source Server Type : MySQL
Source Server Version : 80023
Source Host : localhost:3306
Source Schema : exam
Target Server Type : MySQL
Target Server Version : 80023
File Encoding : 65001
Date: 08/04/2021 21:22:16
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for __EFMigrationsHistory
-- ----------------------------
DROP TABLE IF EXISTS `__EFMigrationsHistory`;
CREATE TABLE `__EFMigrationsHistory` (
`MigrationId` varchar(95) COLLATE utf8mb4_unicode_ci NOT NULL,
`ProductVersion` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`MigrationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of __EFMigrationsHistory
-- ----------------------------
BEGIN;
INSERT INTO `__EFMigrationsHistory` VALUES ('20201201170344_v1.0.0', '5.0.5');
COMMIT;
-- ----------------------------
-- Table structure for tb_admin
-- ----------------------------
DROP TABLE IF EXISTS `tb_admin`;
CREATE TABLE `tb_admin` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账号',
`password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密码',
`createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理员表';
-- ----------------------------
-- Records of tb_admin
-- ----------------------------
BEGIN;
INSERT INTO `tb_admin` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', '2020-11-18 13:15:38.000000');
COMMIT;
-- ----------------------------
-- Table structure for tb_chapter
-- ----------------------------
DROP TABLE IF EXISTS `tb_chapter`;
CREATE TABLE `tb_chapter` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`chapterName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '章节名称',
`courseId` int NOT NULL COMMENT '课程ID',
`desc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '章节描述',
PRIMARY KEY (`id`),
UNIQUE KEY `chapter_id` (`id`),
KEY `chapter_course_id` (`courseId`),
CONSTRAINT `chapter_course_id` FOREIGN KEY (`courseId`) REFERENCES `tb_course` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课程章节表';
-- ----------------------------
-- Records of tb_chapter
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_classes
-- ----------------------------
DROP TABLE IF EXISTS `tb_classes`;
CREATE TABLE `tb_classes` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`classesName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '班级名称',
`DeptId` int NOT NULL COMMENT '系别ID',
`createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `classes_id` (`id`),
KEY `classes_dept_id` (`DeptId`),
CONSTRAINT `classes_dept_id` FOREIGN KEY (`DeptId`) REFERENCES `tb_dept` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='班级表';
-- ----------------------------
-- Records of tb_classes
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_course
-- ----------------------------
DROP TABLE IF EXISTS `tb_course`;
CREATE TABLE `tb_course` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`courseName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '课程名称',
`DeptId` int NOT NULL COMMENT '系别ID',
`teacherId` int NOT NULL COMMENT '教师ID',
`createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `course_id` (`id`),
KEY `course_dept_id` (`DeptId`),
KEY `course_teacher_id` (`teacherId`),
CONSTRAINT `course_dept_id` FOREIGN KEY (`DeptId`) REFERENCES `tb_dept` (`id`) ON DELETE RESTRICT,
CONSTRAINT `course_teacher_id` FOREIGN KEY (`teacherId`) REFERENCES `tb_teacher` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课程表';
-- ----------------------------
-- Records of tb_course
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_courseclasses
-- ----------------------------
DROP TABLE IF EXISTS `tb_courseclasses`;
CREATE TABLE `tb_courseclasses` (
`courseId` int NOT NULL COMMENT '课程ID',
`classesId` int NOT NULL COMMENT '班级ID',
PRIMARY KEY (`classesId`,`courseId`),
KEY `courseclasses_classes_idx` (`classesId`),
KEY `courseclasses_course_idx` (`courseId`),
CONSTRAINT `courseclasses_classes_idx` FOREIGN KEY (`classesId`) REFERENCES `tb_classes` (`id`) ON DELETE RESTRICT,
CONSTRAINT `courseclasses_course_idx` FOREIGN KEY (`courseId`) REFERENCES `tb_course` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课程班级关联表';
-- ----------------------------
-- Records of tb_courseclasses
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_dept
-- ----------------------------
DROP TABLE IF EXISTS `tb_dept`;
CREATE TABLE `tb_dept` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`deptName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '系别名称',
`createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `dept_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系别表';
-- ----------------------------
-- Records of tb_dept
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_exam
-- ----------------------------
DROP TABLE IF EXISTS `tb_exam`;
CREATE TABLE `tb_exam` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`examName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '试卷名称',
`courseId` int NOT NULL COMMENT '课程ID',
`teacherId` int NOT NULL COMMENT '教师ID',
`startTime` datetime(6) NOT NULL COMMENT '开始时间',
`endTime` datetime(6) NOT NULL COMMENT '结束时间',
`duration` int NOT NULL COMMENT '考试时长',
`isEnable` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '启用状态',
`isFinish` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '结束状态',
`createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
`examScore` int NOT NULL COMMENT '试卷总分',
`judgeScore` int NOT NULL COMMENT '是非题分值',
`singleScore` int NOT NULL COMMENT '单选题分值',
`selectScore` int NOT NULL COMMENT '多选题分值',
PRIMARY KEY (`id`),
UNIQUE KEY `exam_id` (`id`),
KEY `exam_course_id` (`courseId`),
KEY `exam_teacher_id` (`teacherId`),
CONSTRAINT `exam_course_id` FOREIGN KEY (`courseId`) REFERENCES `tb_course` (`id`) ON DELETE RESTRICT,
CONSTRAINT `exam_teacher_id` FOREIGN KEY (`teacherId`) REFERENCES `tb_teacher` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='试卷表';
-- ----------------------------
-- Records of tb_exam
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_examclasses
-- ----------------------------
DROP TABLE IF EXISTS `tb_examclasses`;
CREATE TABLE `tb_examclasses` (
`examId` int NOT NULL COMMENT '试卷ID',
`classesId` int NOT NULL COMMENT '班级ID',
PRIMARY KEY (`examId`,`classesId`),
KEY `examclasses_classes_idx` (`classesId`),
KEY `examclasses_exam_idx` (`examId`),
CONSTRAINT `examclasses_classes_idx` FOREIGN KEY (`classesId`) REFERENCES `tb_classes` (`id`) ON DELETE RESTRICT,
CONSTRAINT `examclasses_exam_idx` FOREIGN KEY (`examId`) REFERENCES `tb_exam` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='试卷班级关联表';
-- ----------------------------
-- Records of tb_examclasses
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_examjobs
-- ----------------------------
DROP TABLE IF EXISTS `tb_examjobs`;
CREATE TABLE `tb_examjobs` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`examId` int NOT NULL COMMENT '考试ID',
`status` int NOT NULL COMMENT '任务状态',
PRIMARY KEY (`id`),
UNIQUE KEY `examjobs_id` (`id`),
KEY `examjobs_exam_id` (`examId`),
CONSTRAINT `examjobs_exam_id` FOREIGN KEY (`examId`) REFERENCES `tb_exam` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='考试任务表';
-- ----------------------------
-- Records of tb_examjobs
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_examquestion
-- ----------------------------
DROP TABLE IF EXISTS `tb_examquestion`;
CREATE TABLE `tb_examquestion` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`questionType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '题型',
`examId` int NOT NULL COMMENT '试卷ID',
`questionId` int NOT NULL COMMENT '题目ID',
`score` int NOT NULL COMMENT '分数',
PRIMARY KEY (`id`),
UNIQUE KEY `examquestion_id` (`id`),
KEY `IX_tb_examquestion_examId` (`examId`),
CONSTRAINT `examquestion_exam_id` FOREIGN KEY (`examId`) REFERENCES `tb_exam` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='试卷题目关联表';
-- ----------------------------
-- Records of tb_examquestion
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_judge
-- ----------------------------
DROP TABLE IF EXISTS `tb_judge`;
CREATE TABLE `tb_judge` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`question` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '题目',
`answer` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '答案',
`courseId` int NOT NULL COMMENT '课程ID',
`chapterId` int NOT NULL COMMENT '课程章节ID',
`teacherId` int NOT NULL COMMENT '教师ID',
`ideas` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '解题思路',
`createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `judge_id` (`id`),
KEY `judge_chapter_id` (`chapterId`),
KEY `judge_source_id` (`courseId`),
KEY `judge_teacher_id` (`teacherId`),
CONSTRAINT `judge_chapter_id` FOREIGN KEY (`chapterId`) REFERENCES `tb_chapter` (`id`) ON DELETE RESTRICT,
CONSTRAINT `judge_source_id` FOREIGN KEY (`courseId`) REFERENCES `tb_course` (`id`) ON DELETE RESTRICT,
CONSTRAINT `judge_teacher_id` FOREIGN KEY (`teacherId`) REFERENCES `tb_teacher` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='是非题表';
-- ----------------------------
-- Records of tb_judge
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_select
-- ----------------------------
DROP TABLE IF EXISTS `tb_select`;
CREATE TABLE `tb_select` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`question` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '问题',
`answer` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '答案',
`isSingle` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '是否单选',
`courseId` int NOT NULL COMMENT '课程ID',
`chapterId` int NOT NULL COMMENT '课程章节ID',
`teacherId` int NOT NULL COMMENT '教师ID',
`optionA` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '选项A',
`optionB` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '选项B',
`optionC` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '选项C',
`optionD` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '选项D',
`ideas` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '解题思路',
`createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `select_id` (`id`),
KEY `select_chapter_id` (`chapterId`),
KEY `select_source_id` (`courseId`),
KEY `select_teacher_id` (`teacherId`),
CONSTRAINT `select_chapter_id` FOREIGN KEY (`chapterId`) REFERENCES `tb_chapter` (`id`) ON DELETE RESTRICT,
CONSTRAINT `select_source_id` FOREIGN KEY (`courseId`) REFERENCES `tb_course` (`id`) ON DELETE RESTRICT,
CONSTRAINT `select_teacher_id` FOREIGN KEY (`teacherId`) REFERENCES `tb_teacher` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='选择题表';
-- ----------------------------
-- Records of tb_select
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_stuanswerdetail
-- ----------------------------
DROP TABLE IF EXISTS `tb_stuanswerdetail`;
CREATE TABLE `tb_stuanswerdetail` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`stuId` int NOT NULL COMMENT '学生ID',
`examId` int NOT NULL COMMENT '试卷ID',
`questionId` int NOT NULL COMMENT '题目ID',
`questionType` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '题型',
`stuanswer` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学生答案',
`answer` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '正确答案',
`isright` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '是否正确',
`createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `answerdetail_stu_id_question_id` (`stuId`,`examId`,`questionId`),
UNIQUE KEY `stuanseerdetail_id` (`id`),
KEY `answerdetail_exam_id` (`examId`),
KEY `answerdetail_examquestion_id` (`questionId`),
KEY `answerdetail_stu_id` (`stuId`),
CONSTRAINT `answerdetail_exam_id` FOREIGN KEY (`examId`) REFERENCES `tb_exam` (`id`) ON DELETE RESTRICT,
CONSTRAINT `answerdetail_examquestion_id` FOREIGN KEY (`questionId`) REFERENCES `tb_examquestion` (`id`) ON DELETE RESTRICT,
CONSTRAINT `answerdetail_stu_id` FOREIGN KEY (`stuId`) REFERENCES `tb_student` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='答题明细表';
-- ----------------------------
-- Records of tb_stuanswerdetail
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_student
-- ----------------------------
DROP TABLE IF EXISTS `tb_student`;
CREATE TABLE `tb_student` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`stuName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
`deptId` int NOT NULL COMMENT '系别ID',
`classesId` int NOT NULL COMMENT '班级ID',
`sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '性别',
`stuNo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学号',
`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
`telphone` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话',
`idCard` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份证号码',
`createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `student_id` (`id`),
KEY `student_classes_id` (`classesId`),
KEY `student_dept_id` (`deptId`),
CONSTRAINT `student_classes_id` FOREIGN KEY (`classesId`) REFERENCES `tb_classes` (`id`) ON DELETE RESTRICT,
CONSTRAINT `student_dept_id` FOREIGN KEY (`deptId`) REFERENCES `tb_dept` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='学生表';
-- ----------------------------
-- Records of tb_student
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_stuscore
-- ----------------------------
DROP TABLE IF EXISTS `tb_stuscore`;
CREATE TABLE `tb_stuscore` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`stuId` int NOT NULL COMMENT '学生ID',
`courseId` int NOT NULL COMMENT '课程ID',
`examId` int NOT NULL COMMENT '考试ID',
`score` int NOT NULL COMMENT '分数',
`createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `stuscore_id` (`id`),
UNIQUE KEY `stuscore_stu_id_exam_id` (`stuId`,`examId`),
KEY `stuscore_course_id` (`courseId`),
KEY `stuscore_exam_id` (`examId`),
KEY `stuscore_stu_id` (`stuId`),
CONSTRAINT `stuscore_course_id` FOREIGN KEY (`courseId`) REFERENCES `tb_course` (`id`) ON DELETE RESTRICT,
CONSTRAINT `stuscore_exam_id` FOREIGN KEY (`examId`) REFERENCES `tb_exam` (`id`) ON DELETE RESTRICT,
CONSTRAINT `stuscore_stu_id` FOREIGN KEY (`stuId`) REFERENCES `tb_student` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='学生成绩表';
-- ----------------------------
-- Records of tb_stuscore
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for tb_teacher
-- ----------------------------
DROP TABLE IF EXISTS `tb_teacher`;
CREATE TABLE `tb_teacher` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`teacherName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
`sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '性别',
`telphone` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话',
`teacherNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '教师编号',
`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
`DeptId` int NOT NULL COMMENT '系别ID',
`idCard` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份证号',
`createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `teacher_id` (`id`),
KEY `teacher_dept_id` (`DeptId`),
CONSTRAINT `teacher_dept_id` FOREIGN KEY (`DeptId`) REFERENCES `tb_dept` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='教师表';
-- ----------------------------
-- Records of tb_teacher
-- ----------------------------
BEGIN;
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;

Comment ( 0 )

Sign in for post a comment

C#
1
https://gitee.com/pig0224/ExamKing.git
git@gitee.com:pig0224/ExamKing.git
pig0224
ExamKing
考试君 - Backend
master

Search