SpringbootMybatismysqlelement-vue高校就业管理系统.zip

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 80021 Source Host : localhost:3306 Source Database : employmentsystem Target Server Type : MYSQL Target Server Version : 80021 File Encoding : 65001 Date: 2022-04-21 16:37:36 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `admins` -- ---------------------------- DROP TABLE IF EXISTS `admins`; CREATE TABLE `admins` ( `id` int NOT NULL AUTO_INCREMENT, `uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `upwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `utel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of admins -- ---------------------------- INSERT INTO `admins` VALUES ('1', '管理员', '123', '10086'); -- ---------------------------- -- Table structure for `applys` -- ---------------------------- DROP TABLE IF EXISTS `applys`; CREATE TABLE `applys` ( `id` int NOT NULL AUTO_INCREMENT, `rname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '岗位名称', `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '公司名称', `ctel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '公司电话', `cattr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '公司地址', `rintroduce` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '岗位介绍', `cmajor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '公司服务范围', `rtitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '简历名称', `sname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学生姓名', `stel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学生电话', `smajor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学生专业', `scollege` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所在学院', `sclass` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所在班级', `tname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '简历类型', `aflag` int DEFAULT '0' COMMENT '0 简历待审核 1 简历通过 2 简历不通过 3 发送三方协议邀请 4 学生同意签订 5 企业确认 6企业确认通过 7 企业确认不通过 8 学校审核 9 审核通过 10 审核不通过', `astuts` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '应聘状态', `rdate` date DEFAULT NULL, `classid` int DEFAULT '0', `marjorid` int DEFAULT '0', `collegeid` int DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of applys -- ---------------------------- INSERT INTO `applys` VALUES ('7', 'Java开发工程师', '阿里', '10070', '杭州', '1、根据设计文档或需求说明完成代码编写，调试，内部测试和维护； 2、辅助进行系统的功能定义,程序设计； 3、协助测试工程师制定测试计划，定位发现的问题； 4、配合项目经理完成相关任务目标。', '软件开发设计', '张同学个人简历', '张同学', '10087', '计算机工程', '清华大学', '19级1班', 'IT软件开发', '1', '应聘成功', '2022-04-21', '0', '0', '0'); -- ---------------------------- -- Table structure for `classes` -- ---------------------------- DROP TABLE IF EXISTS `classes`; CREATE TABLE `classes` ( `id` int NOT NULL AUTO_INCREMENT, `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cheadmaster` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班主任', `ctel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '电话', `cnums` int DEFAULT '0' COMMENT '就业人数', `ctotalnums` int DEFAULT '0' COMMENT '总人数', `crates` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '就业率', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of classes -- ---------------------------- INSERT INTO `classes` VALUES ('1', '19级1班', '张三', '13826892228', '0', '0', '0'); INSERT INTO `classes` VALUES ('2', '19级2班', '王五', '13926892229', '0', '0', '0'); -- ---------------------------- -- Table structure for `collections` -- ---------------------------- DROP TABLE IF EXISTS `collections`; CREATE TABLE `collections` ( `Sid` int NOT NULL AUTO_INCREMENT, `Suid` int DEFAULT '0', `Srid` int DEFAULT '0', `Sdate` datetime DEFAULT NULL, `Ssformattime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`Sid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of collections -- ---------------------------- INSERT INTO `collections` VALUES ('1', '1', '1', '2021-09-24 22:05:02', '201-09-25'); INSERT INTO `collections` VALUES ('2', '1', '4', '2021-10-08 16:00:00', '2021-10-09'); -- ---------------------------- -- Table structure for `colleges` -- ---------------------------- DROP TABLE IF EXISTS `colleges`; CREATE TABLE `colleges` ( `id` int NOT NULL AUTO_INCREMENT, `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cbianhao` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cnums` int DEFAULT '0', `ctotalnums` int DEFAULT '0', `crates` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of colleges -- ---------------------------- INSERT INTO `colleges` VALUES ('1', '清华大学', '202298501', '1', '2', '50%'); INSERT INTO `colleges` VALUES ('2', '北京大学', '202298502', '0', '0', null); INSERT INTO `colleges` VALUES ('3', '复亘大学', '202221101', '0', '0', null); INSERT INTO `colleges` VALUES ('4', '上海财经', '202298503', '0', '0', null); -- ---------------------------- -- Table structure for `companys` -- ---------------------------- DROP TABLE IF EXISTS `companys`; CREATE TABLE `companys` ( `id` int NOT NULL AUTO_INCREMENT, `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cpwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `ctel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cattr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cmajor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cboss` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cstaffnums` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cflag` int DEFAULT '0', `cstatus` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `imgtype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cshen` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `cnums` int DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Re