基于SpringBoot+Mybatis Plus+Shiro+mysql+redis智慧云智能教育平台

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 50726 Source Host : localhost:3306 Source Schema : education_final Target Server Type : MySQL Target Server Version : 50726 File Encoding : 65001 Date: 17/07/2021 11:56:17 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for course_info -- ---------------------------- DROP TABLE IF EXISTS `course_info`; CREATE TABLE `course_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `grade_info_id` int(2) NOT NULL, `school_type` int(2) NOT NULL, `subject_id` int(11) NOT NULL, `create_date` datetime(0) NULL DEFAULT NULL, `update_date` datetime(0) NULL DEFAULT NULL, `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程编号', `sort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '排序', `parent_id` int(11) NULL DEFAULT 0, `head_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `represent` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程简介', `recommend_index_flag` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否推荐到系统首页', `study_number` int(11) NOT NULL DEFAULT 0, `status` tinyint(2) NULL DEFAULT 1 COMMENT '状态 （0 下架 1 草稿 2. 已上架）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of course_info -- ---------------------------- INSERT INTO `course_info` VALUES (55, '测试课程', 1, 1, 67, '2020-11-29 15:12:03', '2021-06-05 12:58:09', '', '0', 0, '/images/2020/11/29df3fe4a3dcbb45a39ed3a44e8a348d70.jpg', '反对法', 1, 0, 2); -- ---------------------------- -- Table structure for course_question_info -- ---------------------------- DROP TABLE IF EXISTS `course_question_info`; CREATE TABLE `course_question_info` ( `sort` int(11) NOT NULL DEFAULT 0, `id` int(11) NOT NULL AUTO_INCREMENT, `question_info_id` int(11) NOT NULL, `course_id` int(11) NOT NULL, `mark` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 233 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of course_question_info -- ---------------------------- INSERT INTO `course_question_info` VALUES (0, 232, 1728, 53, 5); -- ---------------------------- -- Table structure for exam_info -- ---------------------------- DROP TABLE IF EXISTS `exam_info`; CREATE TABLE `exam_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `student_id` int(11) NOT NULL, `create_date` datetime(0) NULL DEFAULT NULL, `update_date` datetime(0) NULL DEFAULT NULL, `mark` int(11) NOT NULL DEFAULT 0 COMMENT '总得分', `test_paper_info_id` int(11) NOT NULL, `correct_flag` tinyint(2) NOT NULL DEFAULT 0 COMMENT '1 已批改 0.待批改', `system_mark` int(2) NOT NULL DEFAULT 0 COMMENT '系统判分', `teacher_mark` int(2) NOT NULL DEFAULT 0 COMMENT '老师评分', `exam_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '考试耗时（字符串存储）', `correct_type` tinyint(2) NULL DEFAULT NULL COMMENT '批改形式（1 系统 2 .教师 3 系统 + 教师）', `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT '批改人', `right_number` int(11) NOT NULL COMMENT '客观题答对题数', `error_number` int(11) NOT NULL DEFAULT 0 COMMENT '客观题答错题数（包括主观题未作答数量）', `subjective_question_number` int(11) NOT NULL DEFAULT 0 COMMENT '主观题数量', `question_number` int(11) NULL DEFAULT NULL COMMENT '试题数量', `exam_time_long_value` int(11) NOT NULL DEFAULT 0 COMMENT '考试时间（整数存储）', PRIMARY KEY (`id`) USING BTREE, INDEX `student_id`(`student_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 26299 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of exam_info -- ---------------------------- INSERT INTO `exam_info` VALUES (26298, 89, '2021-07-11 17:19:21', NULL, 50, 11, 1, 50, 0, '05秒', 1, 0, 1, 1, 0, 2, 5); -- ---------------------------- -- Table structure for grade_info -- ---------------------------- DROP TABLE IF EXISTS `grade_info`; CREATE TABLE `grade_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `create_date` datetime(0) NULL DEFAULT NULL, `update_date` datetime(0) NULL DEFAULT NULL, `school_type` tinyint(2) NOT NULL COMMENT '所属阶段', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of grade_info -- ---------------------------- INSERT INTO `grade_info` VALUES (1, '一年级', '2020-11-29 14:50:11', NULL, 1); INSERT INTO `grade_info` VALUES (2, '三年级', '2020-11-29 14:51:44', '2020-11-29 14:52:11', 1); -- ---------------------------- -- Table structure for language_points_info -- ---------------------------- DROP TABLE IF EXISTS `language_points_info`; CREATE TABLE `language_points_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `grade_info_id` int(11) NOT NULL, `subject_id` int(11) NOT NULL, `parent_id` int(11) NOT NULL DEFAULT 0, `create_date` datetime(0) NULL DEFAULT NULL, `update_date` datetime(0) NULL DEFAULT NULL, `hasChildren` tinyint(1) NOT NULL DEFAULT 0, `sort` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of language_points_info -- ---------------------------- INSERT INTO `language_points_info` VALUES (5, '第一单与', 1, 67, 0, '2020-11-29 15:28:38', NULL, 1, 0); INSERT INTO `language_points_info` VALUES (6, '1.1.。。', 1, 67, 5, '2020-11-29 15:34:24', '2020-11-29 15:52:06', 1, 0); INSERT INTO `language_points_info` VALUES (7, '1.1.1', 1, 67, 6, '2020-11-29 15:45:43', '2020-11-29 16:00:24', 0, 0); INSERT INTO `language_points_info` VALUES (9, 'test数学', 1, 68, 0, '2020-12-08 11:52:43', NULL, 1, 0); INSERT INTO `language_points_info` VALUES (10, '数学1.1', 1, 68, 9, '2020-12-08 11:52:53', NULL, 1, 0); INSERT INTO `language_points_info` VALUES (11, '数学1.1.1', 1, 68, 10, '2020-12-08 11:53:02', NULL, 0, 0); -- ---------------------------- -- Table structure for message_info -- ---------------------------- DROP TABLE IF EXISTS `message_info`; CREATE TABLE `message_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `student_id` int(11) NOT NULL COMMENT '学员id', `create_date` datetime(0) NOT NULL, `update_date` datetime(0) NULL DEFAULT NULL, `read_flag` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否已读', `message_type` tinyint(2) NOT NULL DEFAULT 1 COMMENT '消息类型（1 试卷批改通知)', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for message_log -- ---------------------------- DROP TABLE IF EXISTS `message_log`; CREATE TABLE `message_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `status