/* Navicat Premium Dump SQL Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 80040 (8.0.40) Source Host : localhost:3306 Source Schema : t100 Target Server Type : MySQL Target Server Version : 80040 (8.0.40) File Encoding : 65001 Date: 29/12/2024 18:24:50 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for banji -- ---------------------------- DROP TABLE IF EXISTS `banji`; CREATE TABLE `banji` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '班级', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `banji`(`banji` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '班级' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of banji -- ---------------------------- INSERT INTO `banji` VALUES (11, '2025-01-01 16:20:00', '班级1'); INSERT INTO `banji` VALUES (12, '2025-01-01 16:20:00', '班级2'); INSERT INTO `banji` VALUES (13, '2025-01-01 16:20:00', '班级3'); INSERT INTO `banji` VALUES (14, '2025-01-01 16:20:00', '班级4'); INSERT INTO `banji` VALUES (15, '2025-01-01 16:20:00', '班级5'); INSERT INTO `banji` VALUES (16, '2025-01-01 16:20:00', '班级6'); INSERT INTO `banji` VALUES (17, '2025-01-01 16:20:00', '班级7'); INSERT INTO `banji` VALUES (18, '2025-01-01 16:20:00', '班级8'); INSERT INTO `banji` VALUES (19, '2025-01-01 16:20:00', '班级9'); INSERT INTO `banji` VALUES (20, '2025-01-01 16:20:00', '班级10'); -- ---------------------------- -- Table structure for baoxiuchuli -- ---------------------------- DROP TABLE IF EXISTS `baoxiuchuli`; CREATE TABLE `baoxiuchuli` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `baoxiushebei` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '报修设备', `leixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '类型', `baoxiuriqi` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '报修日期', `weixiufankui` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '维修反馈', `weixiujindu` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '维修进度', `gengxinriqi` datetime NULL DEFAULT NULL COMMENT '更新日期', `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号', `xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名', `sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号', `banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级', `weixiugonghao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '维修工号', `xingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '姓名', `lianxidianhua` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系电话', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 91 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '报修处理' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of baoxiuchuli -- ---------------------------- INSERT INTO `baoxiuchuli` VALUES (81, '2025-01-01 16:20:00', '报修设备1', '类型1', '2025-01-01', '维修反馈1', '维修中', '2025-01-01 16:20:00', '学号1', '学生姓名1', '宿舍号1', '班级1', '维修工号1', '姓名1', '联系电话1'); INSERT INTO `baoxiuchuli` VALUES (82, '2025-01-01 16:20:00', '报修设备2', '类型2', '2025-01-01', '维修反馈2', '维修中', '2025-01-01 16:20:00', '学号2', '学生姓名2', '宿舍号2', '班级2', '维修工号2', '姓名2', '联系电话2'); INSERT INTO `baoxiuchuli` VALUES (83, '2025-01-01 16:20:00', '报修设备3', '类型3', '2025-01-01', '维修反馈3', '维修中', '2025-01-01 16:20:00', '学号3', '学生姓名3', '宿舍号3', '班级3', '维修工号3', '姓名3', '联系电话3'); INSERT INTO `baoxiuchuli` VALUES (84, '2025-01-01 16:20:00', '报修设备4', '类型4', '2025-01-01', '维修反馈4', '维修中', '2025-01-01 16:20:00', '学号4', '学生姓名4', '宿舍号4', '班级4', '维修工号4', '姓名4', '联系电话4'); INSERT INTO `baoxiuchuli` VALUES (85, '2025-01-01 16:20:00', '报修设备5', '类型5', '2025-01-01', '维修反馈5', '维修中', '2025-01-01 16:20:00', '学号5', '学生姓名5', '宿舍号5', '班级5', '维修工号5', '姓名5', '联系电话5'); INSERT INTO `baoxiuchuli` VALUES (86, '2025-01-01 16:20:00', '报修设备6', '类型6', '2025-01-01', '维修反馈6', '维修中', '2025-01-01 16:20:00', '学号6', '学生姓名6', '宿舍号6', '班级6', '维修工号6', '姓名6', '联系电话6'); INSERT INTO `baoxiuchuli` VALUES (87, '2025-01-01 16:20:00', '报修设备7', '类型7', '2025-01-01', '维修反馈7', '维修中', '2025-01-01 16:20:00', '学号7', '学生姓名7', '宿舍号7', '班级7', '维修工号7', '姓名7', '联系电话7'); INSERT INTO `baoxiuchuli` VALUES (88, '2025-01-01 16:20:00', '报修设备8', '类型8', '2025-01-01', '维修反馈8', '维修中', '2025-01-01 16:20:00', '学号8', '学生姓名8', '宿舍号8', '班级8', '维修工号8', '姓名8', '联系电话8'); INSERT INTO `baoxiuchuli` VALUES (89, '2025-01-01 16:20:00', '报修设备9', '类型9', '2025-01-01', '维修反馈9', '维修中', '2025-01-01 16:20:00', '学号9', '学生姓名9', '宿舍号9', '班级9', '维修工号9', '姓名9', '联系电话9'); INSERT INTO `baoxiuchuli` VALUES (90, '2025-01-01 16:20:00', '报修设备10', '类型10', '2025-01-01', '维修反馈10', '维修中', '2025-01-01 16:20:00', '学号10', '学生姓名10', '宿舍号10', '班级10', '维修工号10', '姓名10', '联系电话10'); -- ---------------------------- -- Table structure for baoxiuxinxi -- ---------------------------- DROP TABLE IF EXISTS `baoxiuxinxi`; CREATE TABLE `baoxiuxinxi` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `baoxiushebei` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '报修设备', `leixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '类型', `tupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片', `baoxiuneirong` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '报修内容', `baoxiuriqi` date NULL DEFAULT NULL COMMENT '报修日期', `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号', `xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名', `banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级', `sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号', `shouji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机', `sfsh` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '否' COMMENT '是否审核', `shhf` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '审核回复', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 81 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '报修信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of baoxiuxinxi -- ---------------------------- INSERT INTO `baoxiuxinxi` VALUES (71, '2025-01-01 16:20:00', '报修设备1', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容1', '2025-01-01', '学号1', '学生姓名1', '班级1', '宿舍号1', '手机1', '是', ''); INSERT INTO `baoxiuxinxi` VALUES (72, '2025-01-01 16:20:00', '报修设备2', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容2', '2025-01-01', '学号2', '学生姓名2', '班级2', '宿舍号2', '手机2', '是', ''); INSERT INTO `baoxiuxinxi` VALUES (73, '2025-01-01 16:20:00', '报修设备3', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容3', '2025-01-01', '学号3', '学生姓名3', '班级3', '宿舍号3', '手机3', '是', ''); INSERT INTO `baoxiuxinxi` VALUES (74, '2025-01-01 16:20:00', '报修设备4', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容4', '2025-01-01', '学号4', '学生姓名4', '班级4', '宿舍号4', '手机4', '是', ''); INSERT INTO `baoxiuxinxi` VALUES (75, '2025-01-01 16:20:00', '报修设备5', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容5', '2025-01-01', '学号5', '学生姓名5', '班级5', '宿舍号5', '手机5', '是', ''); INSERT INTO `baoxiuxinxi` VALUES (76, '2025-01-01 16:20:00', '报修设备6', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容6', '2025-01-01', '学号6', '学生姓名6', '班级6', '宿舍号6', '手机6', '是', ''); INSERT INTO `baoxiuxinxi` VALUES (77, '2025-01-01 16:20:00', '报修设备7', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容7', '2025-01-01', '学号7', '学生姓名7', '班级7', '宿舍号7', '手机7', '是', ''); INSERT INTO `baoxiuxinxi` VALUES (78, '2025-01-01 16:20:00', '报修设备8', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容8', '2025-01-01', '学号8', '学生姓名8', '班级8', '宿舍号8', '手机8', '是', ''); INSERT INTO `baoxiuxinxi` VALUES (79, '2025-01-01 16:20:00', '报修设备9', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容9', '2025-01-01', '学号9', '学生姓名9', '班级9', '宿舍号9', '手机9', '是', ''); INSERT INTO `baoxiuxinxi` VALUES (80, '2025-01-01 16:20:00', '报修设备10', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容10', '2025-01-01', '学号10', '学生姓名10', '班级10', '宿舍号10', '手机10', '是', ''); -- ---------------------------- -- Table structure for config -- ---------------------------- DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '配置参数名称', `value` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '配置文件' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of config -- ---------------------------- INSERT INTO `config` VALUES (1, 'picture1', 'http://localhost:8080/springboot68ozj/upload/1735467731837.jpg'); INSERT INTO `config` VALUES (2, 'picture2', 'http://localhost:8080/springboot68ozj/upload/1735467765132.jpg'); INSERT INTO `config` VALUES (3, 'picture3', 'http://localhost:8080/springboot68ozj/upload/1735467775814.jpg'); -- ---------------------------- -- Table structure for discussshiwuxinxi -- ---------------------------- DROP TABLE IF EXISTS `discussshiwuxinxi`; CREATE TABLE `discussshiwuxinxi` ( `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', `nickname` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户名', `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '评论内容', `reply` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '回复内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 231 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '失物信息评论表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of discussshiwuxinxi -- ---------------------------- INSERT INTO `discussshiwuxinxi` VALUES (221, '2025-01-01 16:20:00', 1, 1, '用户名1', '评论内容1', '回复内容1'); INSERT INTO `discussshiwuxinxi` VALUES (222, '2025-01-01 16:20:00', 2, 2, '用户名2', '评论内容2', '回复内容2'); INSERT INTO `discussshiwuxinxi` VALUES (223, '2025-01-01 16:20:00', 3, 3, '用户名3', '评论内容3', '回复内容3'); INSERT INTO `discussshiwuxinxi` VALUES (224, '2025-01-01 16:20:00', 4, 4, '用户名4', '评论内容4', '回复内容4'); INSERT INTO `discussshiwuxinxi` VALUES (225, '2025-01-01 16:20:00', 5, 5, '用户名5', '评论内容5', '回复内容5'); INSERT INTO `discussshiwuxinxi` VALUES (226, '2025-01-01 16:20:00', 6, 6, '用户名6', '评论内容6', '回复内容6'); INSERT INTO `discussshiwuxinxi` VALUES (227, '2025-01-01 16:20:00', 7, 7, '用户名7', '评论内容7', '回复内容7'); INSERT INTO `discussshiwuxinxi` VALUES (228, '2025-01-01 16:20:00', 8, 8, '用户名8', '评论内容8', '回复内容8'); INSERT INTO `discussshiwuxinxi` VALUES (229, '2025-01-01 16:20:00', 9, 9, '用户名9', '评论内容9', '回复内容9'); INSERT INTO `discussshiwuxinxi` VALUES (230, '2025-01-01 16:20:00', 10, 10, '用户名10', '评论内容10', '回复内容10'); -- ---------------------------- -- Table structure for discusstongzhuangshui -- ---------------------------- DROP TABLE IF EXISTS `discusstongzhuangshui`; CREATE TABLE `discusstongzhuangshui` ( `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', `nickname` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户名', `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '评论内容', `reply` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '回复内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 221 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '桶装水评论表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of discusstongzhuangshui -- ---------------------------- INSERT INTO `discusstongzhuangshui` VALUES (211, '2025-01-01 16:20:00', 1, 1, '用户名1', '评论内容1', '回复内容1'); INSERT INTO `discusstongzhuangshui` VALUES (212, '2025-01-01 16:20:00', 2, 2, '用户名2', '评论内容2', '回复内容2'); INSERT INTO `discusstongzhuangshui` VALUES (213, '2025-01-01 16:20:00', 3, 3, '用户名3', '评论内容3', '回复内容3'); INSERT INTO `discusstongzhuangshui` VALUES (214, '2025-01-01 16:20:00', 4, 4, '用户名4', '评论内容4', '回复内容4'); INSERT INTO `discusstongzhuangshui` VALUES (215, '2025-01-01 16:20:00', 5, 5, '用户名5', '评论内容5', '回复内容5'); INSERT INTO `discusstongzhuangshui` VALUES (216, '2025-01-01 16:20:00', 6, 6, '用户名6', '评论内容6', '回复内容6'); INSERT INTO `discusstongzhuangshui` VALUES (217, '2025-01-01 16:20:00', 7, 7, '用户名7', '评论内容7', '回复内容7'); INSERT INTO `discusstongzhuangshui` VALUES (218, '2025-01-01 16:20:00', 8, 8, '用户名8', '评论内容8', '回复内容8'); INSERT INTO `discusstongzhuangshui` VALUES (219, '2025-01-01 16:20:00', 9, 9, '用户名9', '评论内容9', '回复内容9'); INSERT INTO `discusstongzhuangshui` VALUES (220, '2025-01-01 16:20:00', 10, 10, '用户名10', '评论内容10', '回复内容10'); -- ---------------------------- -- Table structure for discusszhaolingxinxi -- ---------------------------- DROP TABLE IF EXISTS `discusszhaolingxinxi`; CREATE TABLE `discusszhaolingxinxi` ( `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', `nickname` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户名', `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '评论内容', `reply` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '回复内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 241 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '招领信息评论表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of discusszhaolingxinxi -- ---------------------------- INSERT INTO `discusszhaolingxinxi` VALUES (231, '2025-01-01 16:20:00', 1, 1, '用户名1', '评论内容1', '回复内容1'); INSERT INTO `discusszhaolingxinxi` VALUES (232, '2025-01-01 16:20:00', 2, 2, '用户名2', '评论内容2', '回复内容2'); INSERT INTO `discusszhaolingxinxi` VALUES (233, '2025-01-01 16:20:00', 3, 3, '用户名3', '评论内容3', '回复内容3'); INSERT INTO `discusszhaolingxinxi` VALUES (234, '2025-01-01 16:20:00', 4, 4, '用户名4', '评论内容4', '回复内容4'); INSERT INTO `discusszhaolingxinxi` VALUES (235, '2025-01-01 16:20:00', 5, 5, '用户名5', '评论内容5', '回复内容5'); INSERT INTO `discusszhaolingxinxi` VALUES (236, '2025-01-01 16:20:00', 6, 6, '用户名6', '评论内容6', '回复内容6'); INSERT INTO `discusszhaolingxinxi` VALUES (237, '2025-01-01 16:20:00', 7, 7, '用户名7', '评论内容7', '回复内容7'); INSERT INTO `discusszhaolingxinxi` VALUES (238, '2025-01-01 16:20:00', 8, 8, '用户名8', '评论内容8', '回复内容8'); INSERT INTO `discusszhaolingxinxi` VALUES (239, '2025-01-01 16:20:00', 9, 9, '用户名9', '评论内容9', '回复内容9'); INSERT INTO `discusszhaolingxinxi` VALUES (240, '2025-01-01 16:20:00', 10, 10, '用户名10', '评论内容10', '回复内容10'); -- ---------------------------- -- Table structure for jiaofeixinxi -- ---------------------------- DROP TABLE IF EXISTS `jiaofeixinxi`; CREATE TABLE `jiaofeixinxi` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号', `xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名', `banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级', `sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号', `jiaofeimingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '缴费名称', `jiaofeileixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '缴费类型', `jiaofeijine` int NOT NULL COMMENT '缴费金额', `dengjiriqi` date NULL DEFAULT NULL COMMENT '登记日期', `ispay` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '未支付' COMMENT '是否支付', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 131 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '缴费信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of jiaofeixinxi -- ---------------------------- INSERT INTO `jiaofeixinxi` VALUES (121, '2025-01-01 16:20:00', '学号1', '学生姓名1', '班级1', '宿舍号1', '缴费名称1', '水费', 1, '2025-01-01', '未支付'); INSERT INTO `jiaofeixinxi` VALUES (122, '2025-01-01 16:20:00', '学号2', '学生姓名2', '班级2', '宿舍号2', '缴费名称2', '水费', 2, '2025-01-01', '未支付'); INSERT INTO `jiaofeixinxi` VALUES (123, '2025-01-01 16:20:00', '学号3', '学生姓名3', '班级3', '宿舍号3', '缴费名称3', '水费', 3, '2025-01-01', '未支付'); INSERT INTO `jiaofeixinxi` VALUES (124, '2025-01-01 16:20:00', '学号4', '学生姓名4', '班级4', '宿舍号4', '缴费名称4', '水费', 4, '2025-01-01', '未支付'); INSERT INTO `jiaofeixinxi` VALUES (125, '2025-01-01 16:20:00', '学号5', '学生姓名5', '班级5', '宿舍号5', '缴费名称5', '水费', 5, '2025-01-01', '未支付'); INSERT INTO `jiaofeixinxi` VALUES (126, '2025-01-01 16:20:00', '学号6', '学生姓名6', '班级6', '宿舍号6', '缴费名称6', '水费', 6, '2025-01-01', '未支付'); INSERT INTO `jiaofeixinxi` VALUES (127, '2025-01-01 16:20:00', '学号7', '学生姓名7', '班级7', '宿舍号7', '缴费名称7', '水费', 7, '2025-01-01', '未支付'); INSERT INTO `jiaofeixinxi` VALUES (128, '2025-01-01 16:20:00', '学号8', '学生姓名8', '班级8', '宿舍号8', '缴费名称8', '水费', 8, '2025-01-01', '未支付'); INSERT INTO `jiaofeixinxi` VALUES (129, '2025-01-01 16:20:00', '学号9', '学生姓名9', '班级9', '宿舍号9', '缴费名称9', '水费', 9, '2025-01-01', '未支付'); INSERT INTO `jiaofeixinxi` VALUES (130, '2025-01-01 16:20:00', '学号10', '学生姓名10', '班级10', '宿舍号10', '缴费名称10', '水费', 10, '2025-01-01', '未支付'); -- ---------------------------- -- Table structure for jiaqiliusu -- ---------------------------- DROP TABLE IF EXISTS `jiaqiliusu`; CREATE TABLE `jiaqiliusu` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号', `xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名', `banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级', `sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号', `liuxiaoliyou` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '留校理由', `kaishiriqi` date NULL DEFAULT NULL COMMENT '开始日期', `liuxiaotianshu` int NULL DEFAULT NULL COMMENT '留校天数', `shenqingshijian` date NULL DEFAULT NULL COMMENT '申请时间', `sfsh` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '否' COMMENT '是否审核', `shhf` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '审核回复', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '假期留宿' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of jiaqiliusu -- ---------------------------- INSERT INTO `jiaqiliusu` VALUES (91, '2025-01-01 16:20:00', '学号1', '学生姓名1', '班级1', '宿舍号1', '留校理由1', '2025-01-01', 1, '2025-01-01', '是', ''); INSERT INTO `jiaqiliusu` VALUES (92, '2025-01-01 16:20:00', '学号2', '学生姓名2', '班级2', '宿舍号2', '留校理由2', '2025-01-01', 2, '2025-01-01', '是', ''); INSERT INTO `jiaqiliusu` VALUES (93, '2025-01-01 16:20:00', '学号3', '学生姓名3', '班级3', '宿舍号3', '留校理由3', '2025-01-01', 3, '2025-01-01', '是', ''); INSERT INTO `jiaqiliusu` VALUES (94, '2025-01-01 16:20:00', '学号4', '学生姓名4', '班级4', '宿舍号4', '留校理由4', '2025-01-01', 4, '2025-01-01', '是', ''); INSERT INTO `jiaqiliusu` VALUES (95, '2025-01-01 16:20:00', '学号5', '学生姓名5', '班级5', '宿舍号5', '留校理由5', '2025-01-01', 5, '2025-01-01', '是', ''); INSERT INTO `jiaqiliusu` VALUES (96, '2025-01-01 16:20:00', '学号6', '学生姓名6', '班级6', '宿舍号6', '留校理由6', '2025-01-01', 6, '2025-01-01', '是', ''); INSERT INTO `jiaqiliusu` VALUES (97, '2025-01-01 16:20:00', '学号7', '学生姓名7', '班级7', '宿舍号7', '留校理由7', '2025-01-01', 7, '2025-01-01', '是', ''); INSERT INTO `jiaqiliusu` VALUES (98, '2025-01-01 16:20:00', '学号8', '学生姓名8', '班级8', '宿舍号8', '留校理由8', '2025-01-01', 8, '2025-01-01', '是', ''); INSERT INTO `jiaqiliusu` VALUES (99, '2025-01-01 16:20:00', '学号9', '学生姓名9', '班级9', '宿舍号9', '留校理由9', '2025-01-01', 9, '2025-01-01', '是', ''); INSERT INTO `jiaqiliusu` VALUES (100, '2025-01-01 16:20:00', '学号10', '学生姓名10', '班级10', '宿舍号10', '留校理由10', '2025-01-01', 10, '2025-01-01', '是', ''); -- ---------------------------- -- Table structure for news -- ---------------------------- DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `title` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '标题', `introduction` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '简介', `picture` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '图片', `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 211 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '宿舍公告' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of news -- ---------------------------- INSERT INTO `news` VALUES (201, '2025-01-01 16:20:00', '标题1', '简介1', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '

内容1

'); INSERT INTO `news` VALUES (202, '2025-01-01 16:20:00', '标题2', '简介2', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容2'); INSERT INTO `news` VALUES (203, '2025-01-01 16:20:00', '标题3', '简介3', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容3'); INSERT INTO `news` VALUES (204, '2025-01-01 16:20:00', '标题4', '简介4', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容4'); INSERT INTO `news` VALUES (205, '2025-01-01 16:20:00', '标题5', '简介5', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容5'); INSERT INTO `news` VALUES (206, '2025-01-01 16:20:00', '标题6', '简介6', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容6'); INSERT INTO `news` VALUES (207, '2025-01-01 16:20:00', '标题7', '简介7', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容7'); INSERT INTO `news` VALUES (208, '2025-01-01 16:20:00', '标题8', '简介8', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容8'); INSERT INTO `news` VALUES (209, '2025-01-01 16:20:00', '标题9', '简介9', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容9'); INSERT INTO `news` VALUES (210, '2025-01-01 16:20:00', '标题10', '简介10', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容10'); -- ---------------------------- -- Table structure for shangjia -- ---------------------------- DROP TABLE IF EXISTS `shangjia`; CREATE TABLE `shangjia` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `shangjiazhanghao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '商家账号', `mima` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码', `shangjiamingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商家名称', `touxiang` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '头像', `lianxidianhua` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系电话', `dizhi` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '地址', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `shangjiazhanghao`(`shangjiazhanghao` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商家' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of shangjia -- ---------------------------- INSERT INTO `shangjia` VALUES (41, '2025-01-01 16:20:00', '商家1', '123456', '商家名称1', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888881', '地址1'); INSERT INTO `shangjia` VALUES (42, '2025-01-01 16:20:00', '商家2', '123456', '商家名称2', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888882', '地址2'); INSERT INTO `shangjia` VALUES (43, '2025-01-01 16:20:00', '商家3', '123456', '商家名称3', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888883', '地址3'); INSERT INTO `shangjia` VALUES (44, '2025-01-01 16:20:00', '商家4', '123456', '商家名称4', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888884', '地址4'); INSERT INTO `shangjia` VALUES (45, '2025-01-01 16:20:00', '商家5', '123456', '商家名称5', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888885', '地址5'); INSERT INTO `shangjia` VALUES (46, '2025-01-01 16:20:00', '商家6', '123456', '商家名称6', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888886', '地址6'); INSERT INTO `shangjia` VALUES (47, '2025-01-01 16:20:00', '商家7', '123456', '商家名称7', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888887', '地址7'); INSERT INTO `shangjia` VALUES (48, '2025-01-01 16:20:00', '商家8', '123456', '商家名称8', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888888', '地址8'); INSERT INTO `shangjia` VALUES (49, '2025-01-01 16:20:00', '商家9', '123456', '商家名称9', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888889', '地址9'); INSERT INTO `shangjia` VALUES (50, '2025-01-01 16:20:00', '商家10', '123456', '商家名称10', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888890', '地址10'); -- ---------------------------- -- Table structure for shiwuxinxi -- ---------------------------- DROP TABLE IF EXISTS `shiwuxinxi`; CREATE TABLE `shiwuxinxi` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `wupinmingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '物品名称', `tupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '图片', `wupinleibie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '物品类别', `diushididian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '丢失地点', `diushishijian` datetime NOT NULL COMMENT '丢失时间', `xunwuzhuangtai` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '寻物状态', `xiangximiaoshu` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '详细描述', `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号', `xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名', `shouji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 181 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '失物信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of shiwuxinxi -- ---------------------------- INSERT INTO `shiwuxinxi` VALUES (171, '2025-01-01 16:20:00', '物品名称1', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别1', '丢失地点1', '2025-01-01 16:20:00', '未寻回', '

详细描述1

', '学号1', '学生姓名1', '手机1'); INSERT INTO `shiwuxinxi` VALUES (172, '2025-01-01 16:20:00', '物品名称2', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别2', '丢失地点2', '2025-01-01 16:20:00', '未寻回', '详细描述2', '学号2', '学生姓名2', '手机2'); INSERT INTO `shiwuxinxi` VALUES (173, '2025-01-01 16:20:00', '物品名称3', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别3', '丢失地点3', '2025-01-01 16:20:00', '未寻回', '详细描述3', '学号3', '学生姓名3', '手机3'); INSERT INTO `shiwuxinxi` VALUES (174, '2025-01-01 16:20:00', '物品名称4', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别4', '丢失地点4', '2025-01-01 16:20:00', '未寻回', '详细描述4', '学号4', '学生姓名4', '手机4'); INSERT INTO `shiwuxinxi` VALUES (175, '2025-01-01 16:20:00', '物品名称5', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别5', '丢失地点5', '2025-01-01 16:20:00', '未寻回', '详细描述5', '学号5', '学生姓名5', '手机5'); INSERT INTO `shiwuxinxi` VALUES (176, '2025-01-01 16:20:00', '物品名称6', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别6', '丢失地点6', '2025-01-01 16:20:00', '未寻回', '详细描述6', '学号6', '学生姓名6', '手机6'); INSERT INTO `shiwuxinxi` VALUES (177, '2025-01-01 16:20:00', '物品名称7', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别7', '丢失地点7', '2025-01-01 16:20:00', '未寻回', '详细描述7', '学号7', '学生姓名7', '手机7'); INSERT INTO `shiwuxinxi` VALUES (178, '2025-01-01 16:20:00', '物品名称8', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别8', '丢失地点8', '2025-01-01 16:20:00', '未寻回', '详细描述8', '学号8', '学生姓名8', '手机8'); INSERT INTO `shiwuxinxi` VALUES (179, '2025-01-01 16:20:00', '物品名称9', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别9', '丢失地点9', '2025-01-01 16:20:00', '未寻回', '详细描述9', '学号9', '学生姓名9', '手机9'); INSERT INTO `shiwuxinxi` VALUES (180, '2025-01-01 16:20:00', '物品名称10', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别10', '丢失地点10', '2025-01-01 16:20:00', '未寻回', '详细描述10', '学号10', '学生姓名10', '手机10'); -- ---------------------------- -- Table structure for storeup -- ---------------------------- DROP TABLE IF EXISTS `storeup`; CREATE TABLE `storeup` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint NOT NULL COMMENT '用户id', `refid` bigint NULL DEFAULT NULL COMMENT '收藏id', `tablename` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '表名', `name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '收藏名称', `picture` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '收藏图片', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1707973621104 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '收藏表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of storeup -- ---------------------------- INSERT INTO `storeup` VALUES (1707973154770, '2025-01-01 16:20:00', 21, 142, 'tongzhuangshui', '名称2', '4.jpg'); INSERT INTO `storeup` VALUES (1707973621093, '2025-01-01 16:20:00', 21, 145, 'tongzhuangshui', '名称5', '5.jpg'); INSERT INTO `storeup` VALUES (1707973621094, '2025-01-01 16:20:00', 21, 146, 'tongzhuangshui', '名称6', '5.jpg'); INSERT INTO `storeup` VALUES (1707973621095, '2025-01-01 16:20:00', 22, 147, 'tongzhuangshui', '名称7', '5.jpg'); INSERT INTO `storeup` VALUES (1707973621096, '2025-01-01 16:20:00', 23, 148, 'tongzhuangshui', '名称8', '5.jpg'); INSERT INTO `storeup` VALUES (1707973621097, '2025-01-01 16:20:00', 24, 149, 'tongzhuangshui', '名称9', '5.jpg'); INSERT INTO `storeup` VALUES (1707973621098, '2025-01-01 16:20:00', 25, 150, 'tongzhuangshui', '名称10', '5.jpg'); INSERT INTO `storeup` VALUES (1707973621099, '2025-01-01 16:20:00', 26, 151, 'tongzhuangshui', '名称11', '5.jpg'); INSERT INTO `storeup` VALUES (1707973621100, '2025-01-01 16:20:00', 27, 152, 'tongzhuangshui', '名称12', '5.jpg'); INSERT INTO `storeup` VALUES (1707973621101, '2025-01-01 16:20:00', 28, 153, 'tongzhuangshui', '名称13', '5.jpg'); INSERT INTO `storeup` VALUES (1707973621102, '2025-01-01 16:20:00', 29, 154, 'tongzhuangshui', '名称14', '5.jpg'); INSERT INTO `storeup` VALUES (1707973621103, '2025-01-01 16:20:00', 30, 155, 'tongzhuangshui', '名称15', '5.jpg'); -- ---------------------------- -- Table structure for susheanpai -- ---------------------------- DROP TABLE IF EXISTS `susheanpai`; CREATE TABLE `susheanpai` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号', `susheleixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍类型', `weizhi` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '位置', `kezhurenshu` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '可住人数', `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号', `xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名', `banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级', `anpairiqi` date NULL DEFAULT NULL COMMENT '安排日期', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 71 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '宿舍安排' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of susheanpai -- ---------------------------- INSERT INTO `susheanpai` VALUES (61, '2025-01-01 16:20:00', '宿舍号1', '宿舍类型1', '位置1', '可住人数1', '学号1', '学生姓名1', '班级1', '2025-01-01'); INSERT INTO `susheanpai` VALUES (62, '2025-01-01 16:20:00', '宿舍号2', '宿舍类型2', '位置2', '可住人数2', '学号2', '学生姓名2', '班级2', '2025-01-01'); INSERT INTO `susheanpai` VALUES (63, '2025-01-01 16:20:00', '宿舍号3', '宿舍类型3', '位置3', '可住人数3', '学号3', '学生姓名3', '班级3', '2025-01-01'); INSERT INTO `susheanpai` VALUES (64, '2025-01-01 16:20:00', '宿舍号4', '宿舍类型4', '位置4', '可住人数4', '学号4', '学生姓名4', '班级4', '2025-01-01'); INSERT INTO `susheanpai` VALUES (65, '2025-01-01 16:20:00', '宿舍号5', '宿舍类型5', '位置5', '可住人数5', '学号5', '学生姓名5', '班级5', '2025-01-01'); INSERT INTO `susheanpai` VALUES (66, '2025-01-01 16:20:00', '宿舍号6', '宿舍类型6', '位置6', '可住人数6', '学号6', '学生姓名6', '班级6', '2025-01-01'); INSERT INTO `susheanpai` VALUES (67, '2025-01-01 16:20:00', '宿舍号7', '宿舍类型7', '位置7', '可住人数7', '学号7', '学生姓名7', '班级7', '2025-01-01'); INSERT INTO `susheanpai` VALUES (68, '2025-01-01 16:20:00', '宿舍号8', '宿舍类型8', '位置8', '可住人数8', '学号8', '学生姓名8', '班级8', '2025-01-01'); INSERT INTO `susheanpai` VALUES (69, '2025-01-01 16:20:00', '宿舍号9', '宿舍类型9', '位置9', '可住人数9', '学号9', '学生姓名9', '班级9', '2025-01-01'); INSERT INTO `susheanpai` VALUES (70, '2025-01-01 16:20:00', '宿舍号10', '宿舍类型10', '位置10', '可住人数10', '学号10', '学生姓名10', '班级10', '2025-01-01'); -- ---------------------------- -- Table structure for sushexinxi -- ---------------------------- DROP TABLE IF EXISTS `sushexinxi`; CREATE TABLE `sushexinxi` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '宿舍号', `susheleixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '宿舍类型', `tupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片', `loudong` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '楼栋', `weizhi` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '位置', `kezhurenshu` int NULL DEFAULT NULL COMMENT '可住人数', `beizhu` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '宿舍信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sushexinxi -- ---------------------------- INSERT INTO `sushexinxi` VALUES (51, '2025-01-01 16:20:00', '宿舍号1', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋1', '位置1', 1, '备注1'); INSERT INTO `sushexinxi` VALUES (52, '2025-01-01 16:20:00', '宿舍号2', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋2', '位置2', 2, '备注2'); INSERT INTO `sushexinxi` VALUES (53, '2025-01-01 16:20:00', '宿舍号3', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋3', '位置3', 3, '备注3'); INSERT INTO `sushexinxi` VALUES (54, '2025-01-01 16:20:00', '宿舍号4', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋4', '位置4', 4, '备注4'); INSERT INTO `sushexinxi` VALUES (55, '2025-01-01 16:20:00', '宿舍号5', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋5', '位置5', 5, '备注5'); INSERT INTO `sushexinxi` VALUES (56, '2025-01-01 16:20:00', '宿舍号6', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋6', '位置6', 6, '备注6'); INSERT INTO `sushexinxi` VALUES (57, '2025-01-01 16:20:00', '宿舍号7', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋7', '位置7', 7, '备注7'); INSERT INTO `sushexinxi` VALUES (58, '2025-01-01 16:20:00', '宿舍号8', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋8', '位置8', 8, '备注8'); INSERT INTO `sushexinxi` VALUES (59, '2025-01-01 16:20:00', '宿舍号9', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋9', '位置9', 9, '备注9'); INSERT INTO `sushexinxi` VALUES (60, '2025-01-01 16:20:00', '宿舍号10', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋10', '位置10', 10, '备注10'); -- ---------------------------- -- Table structure for token -- ---------------------------- DROP TABLE IF EXISTS `token`; CREATE TABLE `token` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `userid` bigint NOT NULL COMMENT '用户id', `username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名', `tablename` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '表名', `role` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '角色', `token` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间', `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'token表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of token -- ---------------------------- INSERT INTO `token` VALUES (1, 1, 'abo', 'users', '管理员', 'ewm2ttspu5wro33fl87m4s42797zk4o3', '2025-01-01 16:20:00', '2024-12-29 18:56:30'); INSERT INTO `token` VALUES (2, 2, '学生2', 'xuesheng', '学生', 'i1fc871uzhu25q1fv5mcrg61l22y6thz', '2025-01-01 16:20:00', '2025-01-01 16:20:00'); INSERT INTO `token` VALUES (3, 3, '维修人员3', 'weixiurenyuan', '维修人员', '2t0uvd5jgb4q9mh420lkh90rcfnulw2r', '2025-01-01 16:20:00', '2025-01-01 16:20:00'); INSERT INTO `token` VALUES (4, 4, '商家4', 'shangjia', '商家', 'hnwg6l7fimdkd47ysyf05ifcr4xa09gz', '2025-01-01 16:20:00', '2025-01-01 16:20:00'); INSERT INTO `token` VALUES (5, 5, '用户5', 'users', '用户', 'generated_token_51', '2025-01-01 16:20:00', '2025-01-01 16:20:00'); INSERT INTO `token` VALUES (6, 6, '用户6', 'users', '用户', 'generated_token_61', '2025-01-01 16:20:00', '2025-01-01 16:20:00'); INSERT INTO `token` VALUES (7, 7, '用户7', 'users', '用户', 'generated_token_71', '2025-01-01 16:20:00', '2025-01-01 16:20:00'); INSERT INTO `token` VALUES (8, 8, '用户8', 'users', '用户', 'generated_token_81', '2025-01-01 16:20:00', '2025-01-01 16:20:00'); INSERT INTO `token` VALUES (9, 9, '用户9', 'users', '用户', 'generated_token_91', '2025-01-01 16:20:00', '2025-01-01 16:20:00'); INSERT INTO `token` VALUES (10, 10, '用户10', 'users', '用户', 'generated_token_101', '2025-01-01 16:20:00', '2025-01-01 16:20:00'); -- ---------------------------- -- Table structure for tongzhuangshui -- ---------------------------- DROP TABLE IF EXISTS `tongzhuangshui`; CREATE TABLE `tongzhuangshui` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `mingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称', `tupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片', `pinpai` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '品牌', `guige` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '规格', `jiage` int NULL DEFAULT NULL COMMENT '价格', `xiangqing` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '详情', `shangjiazhanghao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商家账号', `shangjiamingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商家名称', `clicktime` datetime NULL DEFAULT NULL COMMENT '最近点击时间', `clicknum` int NULL DEFAULT 0 COMMENT '点击次数', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 151 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '桶装水' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tongzhuangshui -- ---------------------------- INSERT INTO `tongzhuangshui` VALUES (141, '2025-01-01 16:20:00', '名称1', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌1', '规格1', 1, '

详情1

', '商家账号1', '商家名称1', '2024-12-29 18:07:37', 6); INSERT INTO `tongzhuangshui` VALUES (142, '2025-01-01 16:20:00', '名称2', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌2', '规格2', 2, '

详情2

', '商家账号2', '商家名称2', '2025-01-01 16:20:00', 8); INSERT INTO `tongzhuangshui` VALUES (143, '2025-01-01 16:20:00', '名称3', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌3', '规格3', 3, '

详情3

', '商家账号3', '商家名称3', '2025-01-01 16:20:00', 5); INSERT INTO `tongzhuangshui` VALUES (144, '2025-01-01 16:20:00', '名称4', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌4', '规格4', 4, '

详情4

', '商家账号4', '商家名称4', '2025-01-01 16:20:00', 5); INSERT INTO `tongzhuangshui` VALUES (145, '2025-01-01 16:20:00', '名称5', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌5', '规格5', 5, '

详情5

', '商家账号5', '商家名称5', '2025-01-01 16:20:00', 7); INSERT INTO `tongzhuangshui` VALUES (146, '2025-01-01 16:20:00', '名称6', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌6', '规格6', 6, '

详情6

', '商家账号6', '商家名称6', '2025-01-01 16:20:00', 7); INSERT INTO `tongzhuangshui` VALUES (147, '2025-01-01 16:20:00', '名称7', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌7', '规格7', 7, '

详情7

', '商家账号7', '商家名称7', '2025-01-01 16:20:00', 2); INSERT INTO `tongzhuangshui` VALUES (148, '2025-01-01 16:20:00', '名称8', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌8', '规格8', 8, '

详情8

', '商家账号8', '商家名称8', '2025-01-01 16:20:00', 4); INSERT INTO `tongzhuangshui` VALUES (149, '2025-01-01 16:20:00', '名称9', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌9', '规格9', 9, '

详情9

', '商家账号9', '商家名称9', '2025-01-01 16:20:00', 6); INSERT INTO `tongzhuangshui` VALUES (150, '2025-01-01 16:20:00', '名称10', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌10', '规格10', 10, '

详情10

', '商家账号10', '商家名称10', '2025-01-01 16:20:00', 1); -- ---------------------------- -- Table structure for tongzhuangshuipinpai -- ---------------------------- DROP TABLE IF EXISTS `tongzhuangshuipinpai`; CREATE TABLE `tongzhuangshuipinpai` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `pinpai` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '品牌', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `pinpai`(`pinpai` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 141 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '桶装水品牌' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tongzhuangshuipinpai -- ---------------------------- INSERT INTO `tongzhuangshuipinpai` VALUES (131, '2025-01-01 16:20:00', '品牌1'); INSERT INTO `tongzhuangshuipinpai` VALUES (132, '2025-01-01 16:20:00', '品牌2'); INSERT INTO `tongzhuangshuipinpai` VALUES (133, '2025-01-01 16:20:00', '品牌3'); INSERT INTO `tongzhuangshuipinpai` VALUES (134, '2025-01-01 16:20:00', '品牌4'); INSERT INTO `tongzhuangshuipinpai` VALUES (135, '2025-01-01 16:20:00', '品牌5'); INSERT INTO `tongzhuangshuipinpai` VALUES (136, '2025-01-01 16:20:00', '品牌6'); INSERT INTO `tongzhuangshuipinpai` VALUES (137, '2025-01-01 16:20:00', '品牌7'); INSERT INTO `tongzhuangshuipinpai` VALUES (138, '2025-01-01 16:20:00', '品牌8'); INSERT INTO `tongzhuangshuipinpai` VALUES (139, '2025-01-01 16:20:00', '品牌9'); INSERT INTO `tongzhuangshuipinpai` VALUES (140, '2025-01-01 16:20:00', '品牌10'); -- ---------------------------- -- Table structure for tongzhuangshuiyuding -- ---------------------------- DROP TABLE IF EXISTS `tongzhuangshuiyuding`; CREATE TABLE `tongzhuangshuiyuding` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `mingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称', `pinpai` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '品牌', `guige` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '规格', `jiage` int NULL DEFAULT NULL COMMENT '价格', `shuliang` int NULL DEFAULT NULL COMMENT '数量', `zongjine` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '总金额', `beizhu` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', `songhuodizhi` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '送货地址', `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号', `shouji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机', `shangjiazhanghao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商家账号', `shangjiamingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商家名称', `sfsh` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '否' COMMENT '是否审核', `shhf` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '审核回复', `ispay` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '未支付' COMMENT '是否支付', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 161 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '桶装水预订' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tongzhuangshuiyuding -- ---------------------------- INSERT INTO `tongzhuangshuiyuding` VALUES (151, '2025-01-01 16:20:00', '名称1', '品牌1', '规格1', 1, 1, '总金额1', '备注1', '送货地址1', '学号1', '手机1', '商家账号1', '商家名称1', '是', '', '未支付'); INSERT INTO `tongzhuangshuiyuding` VALUES (152, '2025-01-01 16:20:00', '名称2', '品牌2', '规格2', 2, 2, '总金额2', '备注2', '送货地址2', '学号2', '手机2', '商家账号2', '商家名称2', '是', '', '未支付'); INSERT INTO `tongzhuangshuiyuding` VALUES (153, '2025-01-01 16:20:00', '名称3', '品牌3', '规格3', 3, 3, '总金额3', '备注3', '送货地址3', '学号3', '手机3', '商家账号3', '商家名称3', '是', '', '未支付'); INSERT INTO `tongzhuangshuiyuding` VALUES (154, '2025-01-01 16:20:00', '名称4', '品牌4', '规格4', 4, 4, '总金额4', '备注4', '送货地址4', '学号4', '手机4', '商家账号4', '商家名称4', '是', '', '未支付'); INSERT INTO `tongzhuangshuiyuding` VALUES (155, '2025-01-01 16:20:00', '名称5', '品牌5', '规格5', 5, 5, '总金额5', '备注5', '送货地址5', '学号5', '手机5', '商家账号5', '商家名称5', '是', '', '未支付'); INSERT INTO `tongzhuangshuiyuding` VALUES (156, '2025-01-01 16:20:00', '名称6', '品牌6', '规格6', 6, 6, '总金额6', '备注6', '送货地址6', '学号6', '手机6', '商家账号6', '商家名称6', '是', '', '未支付'); INSERT INTO `tongzhuangshuiyuding` VALUES (157, '2025-01-01 16:20:00', '名称7', '品牌7', '规格7', 7, 7, '总金额7', '备注7', '送货地址7', '学号7', '手机7', '商家账号7', '商家名称7', '是', '', '未支付'); INSERT INTO `tongzhuangshuiyuding` VALUES (158, '2025-01-01 16:20:00', '名称8', '品牌8', '规格8', 8, 8, '总金额8', '备注8', '送货地址8', '学号8', '手机8', '商家账号8', '商家名称8', '是', '', '未支付'); INSERT INTO `tongzhuangshuiyuding` VALUES (159, '2025-01-01 16:20:00', '名称9', '品牌9', '规格9', 9, 9, '总金额9', '备注9', '送货地址9', '学号9', '手机9', '商家账号9', '商家名称9', '是', '', '未支付'); INSERT INTO `tongzhuangshuiyuding` VALUES (160, '2025-01-01 16:20:00', '名称10', '品牌10', '规格10', 10, 10, '总金额10', '备注10', '送货地址10', '学号10', '手机10', '商家账号10', '商家名称10', '是', '', '未支付'); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名', `password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码', `role` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '管理员' COMMENT '角色', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES (1, 'admin', '123456', '管理员', '2025-01-01 16:20:00'); -- ---------------------------- -- Table structure for weishengjiancha -- ---------------------------- DROP TABLE IF EXISTS `weishengjiancha`; CREATE TABLE `weishengjiancha` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号', `xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名', `banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级', `sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号', `jianchaneirong` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '检查内容', `shifouzhengjie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否整洁', `shifouweigui` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否违规', `weishengpingfen` int NULL DEFAULT NULL COMMENT '卫生评分', `jianchajieguo` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '检查结果', `jianchariqi` date NULL DEFAULT NULL COMMENT '检查日期', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 111 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '卫生检查' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of weishengjiancha -- ---------------------------- INSERT INTO `weishengjiancha` VALUES (101, '2025-01-01 16:20:00', '学号1', '学生姓名1', '班级1', '宿舍号1', '检查内容1', '是', '是', 1, '合格', '2025-01-01'); INSERT INTO `weishengjiancha` VALUES (102, '2025-01-01 16:20:00', '学号2', '学生姓名2', '班级2', '宿舍号2', '检查内容2', '是', '是', 2, '合格', '2025-01-01'); INSERT INTO `weishengjiancha` VALUES (103, '2025-01-01 16:20:00', '学号3', '学生姓名3', '班级3', '宿舍号3', '检查内容3', '是', '是', 3, '合格', '2025-01-01'); INSERT INTO `weishengjiancha` VALUES (104, '2025-01-01 16:20:00', '学号4', '学生姓名4', '班级4', '宿舍号4', '检查内容4', '是', '是', 4, '合格', '2025-01-01'); INSERT INTO `weishengjiancha` VALUES (105, '2025-01-01 16:20:00', '学号5', '学生姓名5', '班级5', '宿舍号5', '检查内容5', '是', '是', 5, '合格', '2025-01-01'); INSERT INTO `weishengjiancha` VALUES (106, '2025-01-01 16:20:00', '学号6', '学生姓名6', '班级6', '宿舍号6', '检查内容6', '是', '是', 6, '合格', '2025-01-01'); INSERT INTO `weishengjiancha` VALUES (107, '2025-01-01 16:20:00', '学号7', '学生姓名7', '班级7', '宿舍号7', '检查内容7', '是', '是', 7, '合格', '2025-01-01'); INSERT INTO `weishengjiancha` VALUES (108, '2025-01-01 16:20:00', '学号8', '学生姓名8', '班级8', '宿舍号8', '检查内容8', '是', '是', 8, '合格', '2025-01-01'); INSERT INTO `weishengjiancha` VALUES (109, '2025-01-01 16:20:00', '学号9', '学生姓名9', '班级9', '宿舍号9', '检查内容9', '是', '是', 9, '合格', '2025-01-01'); INSERT INTO `weishengjiancha` VALUES (110, '2025-01-01 16:20:00', '学号10', '学生姓名10', '班级10', '宿舍号10', '检查内容10', '是', '是', 10, '合格', '2025-01-01'); -- ---------------------------- -- Table structure for weixiurenyuan -- ---------------------------- DROP TABLE IF EXISTS `weixiurenyuan`; CREATE TABLE `weixiurenyuan` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `weixiugonghao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '维修工号', `mima` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码', `xingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '姓名', `xingbie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '性别', `zhaopian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '照片', `lianxidianhua` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系电话', `shenfenzheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '身份证', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `weixiugonghao`(`weixiugonghao` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '维修人员' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of weixiurenyuan -- ---------------------------- INSERT INTO `weixiurenyuan` VALUES (31, '2025-01-01 16:20:00', '维修人员1', '123456', '姓名1', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888881', '440300199101010001'); INSERT INTO `weixiurenyuan` VALUES (32, '2025-01-01 16:20:00', '维修人员2', '123456', '姓名2', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888882', '440300199202020002'); INSERT INTO `weixiurenyuan` VALUES (33, '2025-01-01 16:20:00', '维修人员3', '123456', '姓名3', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888883', '440300199303030003'); INSERT INTO `weixiurenyuan` VALUES (34, '2025-01-01 16:20:00', '维修人员4', '123456', '姓名4', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888884', '440300199404040004'); INSERT INTO `weixiurenyuan` VALUES (35, '2025-01-01 16:20:00', '维修人员5', '123456', '姓名5', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888885', '440300199505050005'); INSERT INTO `weixiurenyuan` VALUES (36, '2025-01-01 16:20:00', '维修人员6', '123456', '姓名6', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888886', '440300199606060006'); INSERT INTO `weixiurenyuan` VALUES (37, '2025-01-01 16:20:00', '维修人员7', '123456', '姓名7', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888887', '440300199707070007'); INSERT INTO `weixiurenyuan` VALUES (38, '2025-01-01 16:20:00', '维修人员8', '123456', '姓名8', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888888', '440300199808080008'); INSERT INTO `weixiurenyuan` VALUES (39, '2025-01-01 16:20:00', '维修人员9', '123456', '姓名9', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888889', '440300199909090009'); INSERT INTO `weixiurenyuan` VALUES (40, '2025-01-01 16:20:00', '维修人员10', '123456', '姓名10', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888880', '440300200001010001'); -- ---------------------------- -- Table structure for wenmingsushe -- ---------------------------- DROP TABLE IF EXISTS `wenmingsushe`; CREATE TABLE `wenmingsushe` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号', `weishengpingfen` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '卫生评分', `pingbiriqi` date NULL DEFAULT NULL COMMENT '评比日期', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 121 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '文明宿舍' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of wenmingsushe -- ---------------------------- INSERT INTO `wenmingsushe` VALUES (111, '2025-01-01 16:20:00', '宿舍号1', '卫生评分1', '2025-01-01'); INSERT INTO `wenmingsushe` VALUES (112, '2025-01-01 16:20:00', '宿舍号2', '卫生评分2', '2025-01-01'); INSERT INTO `wenmingsushe` VALUES (113, '2025-01-01 16:20:00', '宿舍号3', '卫生评分3', '2025-01-01'); INSERT INTO `wenmingsushe` VALUES (114, '2025-01-01 16:20:00', '宿舍号4', '卫生评分4', '2025-01-01'); INSERT INTO `wenmingsushe` VALUES (115, '2025-01-01 16:20:00', '宿舍号5', '卫生评分5', '2025-01-01'); INSERT INTO `wenmingsushe` VALUES (116, '2025-01-01 16:20:00', '宿舍号6', '卫生评分6', '2025-01-01'); INSERT INTO `wenmingsushe` VALUES (117, '2025-01-01 16:20:00', '宿舍号7', '卫生评分7', '2025-01-01'); INSERT INTO `wenmingsushe` VALUES (118, '2025-01-01 16:20:00', '宿舍号8', '卫生评分8', '2025-01-01'); INSERT INTO `wenmingsushe` VALUES (119, '2025-01-01 16:20:00', '宿舍号9', '卫生评分9', '2025-01-01'); INSERT INTO `wenmingsushe` VALUES (120, '2025-01-01 16:20:00', '宿舍号10', '卫生评分10', '2025-01-01'); -- ---------------------------- -- Table structure for wupinleibie -- ---------------------------- DROP TABLE IF EXISTS `wupinleibie`; CREATE TABLE `wupinleibie` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `wupinleibie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '物品类别', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `wupinleibie`(`wupinleibie` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 171 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '物品类别' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of wupinleibie -- ---------------------------- INSERT INTO `wupinleibie` VALUES (161, '2025-01-01 16:20:00', '物品类别1'); INSERT INTO `wupinleibie` VALUES (162, '2025-01-01 16:20:00', '物品类别2'); INSERT INTO `wupinleibie` VALUES (163, '2025-01-01 16:20:00', '物品类别3'); INSERT INTO `wupinleibie` VALUES (164, '2025-01-01 16:20:00', '物品类别4'); INSERT INTO `wupinleibie` VALUES (165, '2025-01-01 16:20:00', '物品类别5'); INSERT INTO `wupinleibie` VALUES (166, '2025-01-01 16:20:00', '物品类别6'); INSERT INTO `wupinleibie` VALUES (167, '2025-01-01 16:20:00', '物品类别7'); INSERT INTO `wupinleibie` VALUES (168, '2025-01-01 16:20:00', '物品类别8'); INSERT INTO `wupinleibie` VALUES (169, '2025-01-01 16:20:00', '物品类别9'); INSERT INTO `wupinleibie` VALUES (170, '2025-01-01 16:20:00', '物品类别10'); -- ---------------------------- -- Table structure for xuesheng -- ---------------------------- DROP TABLE IF EXISTS `xuesheng`; CREATE TABLE `xuesheng` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学号', `mima` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码', `xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学生姓名', `xingbie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '性别', `touxiang` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '头像', `banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级', `shouji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机', `youxiang` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱', `sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `xuehao`(`xuehao` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '学生' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xuesheng -- ---------------------------- INSERT INTO `xuesheng` VALUES (21, '2025-01-01 16:20:00', '学生1', '123456', '学生姓名1', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级1', '13823888881', '773890001@qq.com', '宿舍号1'); INSERT INTO `xuesheng` VALUES (22, '2025-01-01 16:20:00', '学生2', '123456', '学生姓名2', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级2', '13823888882', '773890002@qq.com', '宿舍号2'); INSERT INTO `xuesheng` VALUES (23, '2025-01-01 16:20:00', '学生3', '123456', '学生姓名3', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级3', '13823888883', '773890003@qq.com', '宿舍号3'); INSERT INTO `xuesheng` VALUES (24, '2025-01-01 16:20:00', '学生4', '123456', '学生姓名4', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级4', '13823888884', '773890004@qq.com', '宿舍号4'); INSERT INTO `xuesheng` VALUES (25, '2025-01-01 16:20:00', '学生5', '123456', '学生姓名5', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级5', '13823888885', '773890005@qq.com', '宿舍号5'); INSERT INTO `xuesheng` VALUES (26, '2025-01-01 16:20:00', '学生6', '123456', '学生姓名6', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级6', '13823888886', '773890006@qq.com', '宿舍号6'); INSERT INTO `xuesheng` VALUES (27, '2025-01-01 16:20:00', '学生7', '123456', '学生姓名7', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级7', '13823888887', '773890007@qq.com', '宿舍号7'); INSERT INTO `xuesheng` VALUES (28, '2025-01-01 16:20:00', '学生8', '123456', '学生姓名8', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级8', '13823888888', '773890008@qq.com', '宿舍号8'); INSERT INTO `xuesheng` VALUES (29, '2025-01-01 16:20:00', '学生9', '123456', '学生姓名9', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级9', '13823888889', '773890009@qq.com', '宿舍号9'); INSERT INTO `xuesheng` VALUES (30, '2025-01-01 16:20:00', '学生10', '123456', '学生姓名10', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级10', '13823888880', '773890010@qq.com', '宿舍号10'); -- ---------------------------- -- Table structure for zhaolingxinxi -- ---------------------------- DROP TABLE IF EXISTS `zhaolingxinxi`; CREATE TABLE `zhaolingxinxi` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `wupinmingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '物品名称', `tupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '图片', `wupinleibie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '物品类别', `jianshididian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '捡拾地点', `jianshishijian` datetime NOT NULL COMMENT '捡拾时间', `renlingzhuangtai` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '认领状态', `xiangximiaoshu` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '详细描述', `xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号', `xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名', `shouji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 191 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '招领信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of zhaolingxinxi -- ---------------------------- INSERT INTO `zhaolingxinxi` VALUES (181, '2025-01-01 16:20:00', '物品名称1', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别1', '捡拾地点1', '2025-01-01 16:20:00', '未认领', '

这是对物品1的详细描述

', '学号001', '学生姓名1', '13800138000'); INSERT INTO `zhaolingxinxi` VALUES (182, '2025-01-01 16:20:00', '物品名称2', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别2', '捡拾地点2', '2025-01-01 16:20:00', '未认领', '这是对物品2的详细描述', '学号002', '学生姓名2', '13800138001'); INSERT INTO `zhaolingxinxi` VALUES (183, '2025-01-01 16:20:00', '物品名称3', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别3', '捡拾地点3', '2025-01-01 16:20:00', '未认领', '这是对物品3的详细描述', '学号003', '学生姓名3', '13800138002'); INSERT INTO `zhaolingxinxi` VALUES (184, '2025-01-01 16:20:00', '物品名称4', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别4', '捡拾地点4', '2025-01-01 16:20:00', '未认领', '这是对物品4的详细描述', '学号004', '学生姓名4', '13800138003'); INSERT INTO `zhaolingxinxi` VALUES (185, '2025-01-01 16:20:00', '物品名称5', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别5', '捡拾地点5', '2025-01-01 16:20:00', '未认领', '这是对物品5的详细描述', '学号005', '学生姓名5', '13800138004'); INSERT INTO `zhaolingxinxi` VALUES (186, '2025-01-01 16:20:00', '物品名称6', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别6', '捡拾地点6', '2025-01-01 16:20:00', '未认领', '这是对物品6的详细描述', '学号006', '学生姓名6', '13800138005'); INSERT INTO `zhaolingxinxi` VALUES (187, '2025-01-01 16:20:00', '物品名称7', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别7', '捡拾地点7', '2025-01-01 16:20:00', '未认领', '这是对物品7的详细描述', '学号007', '学生姓名7', '13800138006'); INSERT INTO `zhaolingxinxi` VALUES (188, '2025-01-01 16:20:00', '物品名称8', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别8', '捡拾地点8', '2025-01-01 16:20:00', '未认领', '这是对物品8的详细描述', '学号008', '学生姓名8', '13800138007'); INSERT INTO `zhaolingxinxi` VALUES (189, '2025-01-01 16:20:00', '物品名称9', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别9', '捡拾地点9', '2025-01-01 16:20:00', '未认领', '这是对物品9的详细描述', '学号009', '学生姓名9', '13800138008'); INSERT INTO `zhaolingxinxi` VALUES (190, '2025-01-01 16:20:00', '物品名称10', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别10', '捡拾地点10', '2025-01-01 16:20:00', '未认领', '这是对物品10的详细描述', '学号010', '学生姓名10', '13800138009'); SET FOREIGN_KEY_CHECKS = 1;