基于.NET 6和Furion框架的在线考试系统设计源码

/* Navicat Premium Data Transfer Source Server : 127.0.0.1 Source Server Type : MySQL Source Server Version : 80027 Source Host : localhost:3306 Source Schema : examking Target Server Type : MySQL Target Server Version : 80027 File Encoding : 65001 Date: 16/03/2023 15:47:40 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for __EFMigrationsHistory -- ---------------------------- DROP TABLE IF EXISTS `__EFMigrationsHistory`; CREATE TABLE `__EFMigrationsHistory` ( `MigrationId` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `ProductVersion` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, PRIMARY KEY (`MigrationId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of __EFMigrationsHistory -- ---------------------------- BEGIN; INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`) VALUES ('20201201170344_v1.0.0', '6.0.6'); 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_unicode_ci NOT NULL COMMENT '账号', `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_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` (`id`, `username`, `password`, `createTime`) 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课程章节表'; -- ---------------------------- -- Records of tb_chapter -- ---------------------------- BEGIN; INSERT INTO `tb_chapter` (`id`, `chapterName`, `courseId`, `desc`) VALUES (1, '第一章', 2, '第一章'); 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='班级表'; -- ---------------------------- -- Records of tb_classes -- ---------------------------- BEGIN; INSERT INTO `tb_classes` (`id`, `classesName`, `DeptId`, `createTime`) VALUES (1, '计算机应用工程（专升本）1班', 1, '2023-03-16 14:58:43.225662'); 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课程表'; -- ---------------------------- -- Records of tb_course -- ---------------------------- BEGIN; INSERT INTO `tb_course` (`id`, `courseName`, `DeptId`, `teacherId`, `createTime`) VALUES (2, 'Java程序设计', 1, 1, '2023-03-16 15:14:25.563265'); 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; INSERT INTO `tb_courseclasses` (`courseId`, `classesId`) VALUES (2, 1); 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系别表'; -- ---------------------------- -- Records of tb_dept -- ---------------------------- BEGIN; INSERT INTO `tb_dept` (`id`, `deptName`, `createTime`) VALUES (1, '国科数字产业学院', '2023-03-16 14:58:26.770133'); 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` (`