基于springboot,vue毕业设计管理系统-011

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50732 Source Host : localhost:3306 Source Schema : graduationmanager Target Server Type : MySQL Target Server Version : 50732 File Encoding : 65001 Date: 17/11/2022 22:59:41 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `admin_id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键,管理员id', `user_id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外键,用户id', PRIMARY KEY (`admin_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `admin_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表，\r\n' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES ('1', '30001'); -- ---------------------------- -- Table structure for classi -- ---------------------------- DROP TABLE IF EXISTS `classi`; CREATE TABLE `classi` ( `class_id` int(11) NOT NULL, `class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `subject_id` int(11) NOT NULL, PRIMARY KEY (`class_id`) USING BTREE, INDEX `class_ibfk_1`(`subject_id`) USING BTREE, CONSTRAINT `classi_ibfk_1` FOREIGN KEY (`subject_id`) REFERENCES `subject` (`subject_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of classi -- ---------------------------- INSERT INTO `classi` VALUES (1, '2020级计算机科学技术', 1); INSERT INTO `classi` VALUES (2, '2020级电子信息', 2); INSERT INTO `classi` VALUES (3, '2020级人工智能', 3); INSERT INTO `classi` VALUES (4, '2020级数据分析', 4); -- ---------------------------- -- Table structure for dept -- ---------------------------- DROP TABLE IF EXISTS `dept`; CREATE TABLE `dept` ( `dept_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键,部门id', `dept_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门科室名', PRIMARY KEY (`dept_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of dept -- ---------------------------- INSERT INTO `dept` VALUES (1, '计算机科学教研室'); INSERT INTO `dept` VALUES (2, '大数据教研室'); INSERT INTO `dept` VALUES (3, '数字媒体技术教研室'); INSERT INTO `dept` VALUES (4, '广播电视工程教研室'); -- ---------------------------- -- Table structure for down -- ---------------------------- DROP TABLE IF EXISTS `down`; CREATE TABLE `down` ( `down_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公共资源下载', `down_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '资源标题', `down_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '资源下载地址', `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `admin_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外键,管理员id', PRIMARY KEY (`down_id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, CONSTRAINT `down_ibfk_1` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`admin_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件下载' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of down -- ---------------------------- INSERT INTO `down` VALUES (1, '免答辩申请表.docx', '免答辩申请表.docx', '2018-03-24 21:23:15', '1'); INSERT INTO `down` VALUES (2, '中期检查表', '中期检查表.docx', '2018-03-25 17:15:39', '1'); INSERT INTO `down` VALUES (3, '开题报告表', '开题报告.docx', '2018-03-25 17:16:10', '1'); INSERT INTO `down` VALUES (4, '论文要求说明', '', '2018-03-25 17:16:47', '1'); INSERT INTO `down` VALUES (5, '2018届毕业设计（论文）完成情况评价表（新）.doc', '', '2018-03-25 17:17:19', '1'); INSERT INTO `down` VALUES (6, '2018届毕业设计开题报告完成情况统计.xlsx', '', '2018-03-25 17:17:42', '1'); INSERT INTO `down` VALUES (7, 'Javascript参考手册.chm', '', '2018-03-25 17:18:09', '1'); INSERT INTO `down` VALUES (8, 'J2EE_1.6_API.chm', '', '2018-03-25 17:18:30', '1'); -- ---------------------------- -- Table structure for inform -- ---------------------------- DROP TABLE IF EXISTS `inform`; CREATE TABLE `inform` ( `inform_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键,通知公告id', `inform_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知公告标题', `inform_body` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知公告主体', `is_attachment` int(11) NULL DEFAULT 0 COMMENT '是否有附件(0否1有)', `attachment_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件地址', `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `admin_id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外键,管理员id', PRIMARY KEY (`inform_id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, CONSTRAINT `inform_ibfk_1` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`admin_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of inform -- ---------------------------- INSERT INTO `inform` VALUES (1, '信息技术学院2018届本科毕业设计答辩工作安排说明', '通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----', 0, NULL, '2018-04-26 21:25:13', '1'); INSERT INTO `inform` VALUES (2, '关于对2018届本科毕业设计(论文)进行系统验收的通知', '通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----', 0, NULL, '2018-04-06 15:45:28', '1'); INSERT INTO `inform` VALUES (3, '关于对2018届本科毕业设计(论文)进行中期检查的通知', '通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----', 0, NULL, '2018-03-25 15:46:00', '1'); INSERT INTO `inform` VALUES (4, '关于对2018届本科毕业设计(论文)进行开题报告检查的通知', '通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----通知内容信息----', 0, NULL, '2018-02-23 15:46:25', '1'); INSERT INTO `inform` VALUES (5, '信�