基于SSM的学生勤工助学俭学管理系统

SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for chat -- ---------------------------- DROP TABLE IF EXISTS `chat`; CREATE TABLE `chat` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint NOT NULL COMMENT '用户id', `adminid` bigint NULL DEFAULT NULL COMMENT '管理员id', `ask` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '提问', `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复', `isreply` int NULL DEFAULT NULL COMMENT '是否回复', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 149 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '在线客服' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of chat -- ---------------------------- INSERT INTO `chat` VALUES (141, '2023-02-23 16:20:20', 1, 1, '提问1', '回复1', 1); INSERT INTO `chat` VALUES (142, '2023-02-23 16:20:20', 2, 2, '提问2', '回复2', 2); INSERT INTO `chat` VALUES (143, '2023-02-23 16:20:20', 3, 3, '提问3', '回复3', 3); INSERT INTO `chat` VALUES (144, '2023-02-23 16:20:20', 4, 4, '提问4', '回复4', 4); INSERT INTO `chat` VALUES (145, '2023-02-23 16:20:20', 5, 5, '提问5', '回复5', 5); INSERT INTO `chat` VALUES (146, '2023-02-23 16:20:20', 6, 6, '提问6', '回复6', 6); INSERT INTO `chat` VALUES (147, '2023-02-23 16:20:20', 7, 7, '提问7', '回复7', 7); INSERT INTO `chat` VALUES (148, '2023-02-23 16:20:20', 8, 8, '提问8', '回复8', 8); INSERT INTO `chat` VALUES (1683795979276, '2023-05-11 17:06:18', 11, NULL, '2313', NULL, 1); -- ---------------------------- -- Table structure for config -- ---------------------------- DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置参数名称', `value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置文件' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of config -- ---------------------------- INSERT INTO `config` VALUES (1, 'picture1', 'upload/picture1.jpg'); INSERT INTO `config` VALUES (2, 'picture2', 'upload/picture2.jpg'); INSERT INTO `config` VALUES (3, 'picture3', 'upload/picture3.jpg'); -- ---------------------------- -- Table structure for discussgangweixinxi -- ---------------------------- DROP TABLE IF EXISTS `discussgangweixinxi`; CREATE TABLE `discussgangweixinxi` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `refid` bigint NOT NULL COMMENT '关联表id', `userid` bigint NOT NULL COMMENT '用户id', `avatarurl` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '头像', `nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名', `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容', `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '岗位信息评论表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of discussgangweixinxi -- ---------------------------- -- ---------------------------- -- Table structure for discussjiaowuzhuxue -- ---------------------------- DROP TABLE IF EXISTS `discussjiaowuzhuxue`; CREATE TABLE `discussjiaowuzhuxue` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `refid` bigint NOT NULL COMMENT '关联表id', `userid` bigint NOT NULL COMMENT '用户id', `avatarurl` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '头像', `nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名', `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容', `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '教务助学评论表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of discussjiaowuzhuxue -- ---------------------------- -- ---------------------------- -- Table structure for gangweibaoming -- ---------------------------- DROP TABLE IF EXISTS `gangweibaoming`; CREATE TABLE `gangweibaoming` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `gangweimingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '岗位名称', `meirigongzi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '每日工资', `gangweifenlei` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '岗位分类', `gongzuodidian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作地点', `qiyedizhi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业地址', `qiyemingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业名称', `gerenjianli` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '个人简历', `yingpinliuyan` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '应聘留言', `shenqingriqi` date NULL DEFAULT NULL COMMENT '申请日期', `xuehao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学号', `xueshengxingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学生姓名', `touxiang` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '头像', `zhuanye` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业', `lianxifangshi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式', `sfsh` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '待审核' COMMENT '是否审核', `shhf` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核回复', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1683191173845 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '岗位报名' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of gangweibaoming -- ---------------------------- INSERT INTO `gangweibaoming` VALUES (61, '2023-02-23 16:20:20', '岗位名称1', '每日工资1', '岗位分类1', '工作地点1', '企业地址1', '企业名称1', '', '应聘留言1', '2023-02-23', '学号1', '学生姓名1', 'upload/gangweibaoming_touxiang1.jpg,upload/gangweibaoming_touxiang2.jpg,upload/gangweibaoming_touxiang3.jpg', '专业1', '联系方式1', '是', ''); INSERT INTO `gangweibaoming` VALUES (62, '2023-02-23 16:20:20', '岗位名称2', '每日工资2', '岗位分类2', '工作地点2', '企业地址2', '企业名称2', '', '应聘留言2', '2023-02-23', '学号2', '学生姓名2', 'upload/gangweibaoming_touxiang2.jpg,upload/gangweibaoming_touxiang3.jpg,upload/gangweibaoming_touxiang4.jpg', '专业2', '联系方式2', '是', ''); INSERT INTO `gangweibaoming` VALUES (63, '2023-02-23 16:20:20', '岗位名称3', '每日工资3', '岗位分类3', '工作地点3', '企业地�