基于Nodejs+TypeScript+Koa+MySQL实现的宿舍管理系统源码(前端+后端)+使用说明+sql数据库.zip

/* Navicat Premium Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 50740 Source Host : localhost:3306 Source Schema : dormitory Target Server Type : MySQL Target Server Version : 50740 File Encoding : 65001 Date: 09/03/2023 13:48:38 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for authority -- ---------------------------- DROP TABLE IF EXISTS `authority`; CREATE TABLE `authority` ( `authority_id` int(10) NOT NULL COMMENT '权限ID', `authority_pid` int(10) NULL DEFAULT NULL COMMENT '父权限ID', `authority_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限中文名', `authority_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限名', `authority_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限路由', `authority_type` int(10) NOT NULL COMMENT '权限类型 0:路由权限 1:操作权限', PRIMARY KEY (`authority_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of authority -- ---------------------------- INSERT INTO `authority` VALUES (1, 0, '常规路由', 'Common', '/common', 0); INSERT INTO `authority` VALUES (3, 0, '宿舍管理', 'DormManage', '/dorm-manage', 0); INSERT INTO `authority` VALUES (4, 0, '用户信息管理', 'UserInfoManage', '/userInfo-manage', 0); INSERT INTO `authority` VALUES (5, 0, '后勤服务', 'LogisticsService', '/logistics-service', 0); INSERT INTO `authority` VALUES (6, 0, '权限管理', 'AuthorityManage', '/authority-manage', 0); INSERT INTO `authority` VALUES (101, 1, '欢迎', 'Welcome', '/welcome', 0); INSERT INTO `authority` VALUES (102, 1, '个人中心', 'PersonalCenter', '/personal-center', 0); INSERT INTO `authority` VALUES (301, 3, '宿舍楼管理', 'BuildManage', '/build-manage', 0); INSERT INTO `authority` VALUES (302, 3, '宿舍房间管理', 'RoomManage', '/room-Manage', 0); INSERT INTO `authority` VALUES (401, 4, '职工信息管理', 'EmployeeManage', '/employee-manage', 0); INSERT INTO `authority` VALUES (402, 4, '学生信息管理', 'StudentManage', '/student-manage', 0); INSERT INTO `authority` VALUES (501, 5, '后勤报修', 'LogisticsRepair', '/logistics-repair', 0); INSERT INTO `authority` VALUES (502, 5, '报修列表', 'LogisticsList', '/logistics-list', 0); INSERT INTO `authority` VALUES (601, 6, '权限列表', 'AuthorityList', '/authority-list', 0); INSERT INTO `authority` VALUES (602, 6, '角色权限管理', 'RoleAuthority', '/role-authority', 0); INSERT INTO `authority` VALUES (603, 6, '用户权限管理', 'UserAuthority', '/user-authority', 0); INSERT INTO `authority` VALUES (3011, 301, '浏览宿舍楼信息', 'BrowseDormBuildInfo', '', 1); INSERT INTO `authority` VALUES (3012, 301, '添加宿舍楼信息', 'AddDormBuildInfo', '', 1); INSERT INTO `authority` VALUES (3013, 301, '编辑宿舍楼信息', 'EditDormBuildInfo', '', 1); INSERT INTO `authority` VALUES (3014, 301, '删除宿舍楼信息', 'DeleteDormBuildInfo', '', 1); INSERT INTO `authority` VALUES (3021, 302, '浏览宿舍列表', 'BrowseDormList', '', 1); INSERT INTO `authority` VALUES (3022, 302, '添加宿舍', 'AddDorm', '', 1); INSERT INTO `authority` VALUES (3023, 302, '添加宿舍人员', 'AddDormStaff', '', 1); INSERT INTO `authority` VALUES (3034, 302, '换宿', 'ChangeDorm', '', 1); INSERT INTO `authority` VALUES (3035, 302, '退宿', 'CheckOut', '', 1); INSERT INTO `authority` VALUES (4011, 401, '浏览职工信息', 'BrowseEmployeeInfo', '', 1); INSERT INTO `authority` VALUES (4012, 401, '添加职工信息', 'AddEmployeeInfo', NULL, 1); INSERT INTO `authority` VALUES (4013, 401, '删除职工信息', 'DeleteEmployeeInfo', NULL, 1); INSERT INTO `authority` VALUES (4014, 401, '编辑职工信息', 'EditEmployeeInfo', NULL, 1); INSERT INTO `authority` VALUES (4021, 402, '浏览学生信息', 'BrowseStudentInfo', '', 1); INSERT INTO `authority` VALUES (4022, 402, '添加学生信息', 'AddStudentInfo', NULL, 1); INSERT INTO `authority` VALUES (4023, 402, '删除学生信息', 'DeleteStudentInfo', NULL, 1); INSERT INTO `authority` VALUES (4024, 402, '编辑学生信息', 'EditStudentInfo', NULL, 1); INSERT INTO `authority` VALUES (5021, 502, '以楼栋搜索', 'SearchByDormBuild', '', 1); INSERT INTO `authority` VALUES (5022, 502, '浏览报修列表', 'BrowseRepairList', '', 1); INSERT INTO `authority` VALUES (5023, 502, '编辑报修单', 'EditRepairBill', '', 1); INSERT INTO `authority` VALUES (5024, 502, '删除报修单', 'DeleteRepairBill', '', 1); INSERT INTO `authority` VALUES (5025, 502, '改变报修单状态', 'ChangeRepairStatus', '', 1); INSERT INTO `authority` VALUES (6011, 601, '浏览权限列表', 'BrowseAuthorityList', '', 1); INSERT INTO `authority` VALUES (6012, 601, '添加权限', 'AddAuthority', '', 1); INSERT INTO `authority` VALUES (6013, 601, '删除权限', 'DeleteAuthority', '', 1); INSERT INTO `authority` VALUES (6014, 601, '编辑权限', 'EditAuthority', '', 1); INSERT INTO `authority` VALUES (6021, 602, '添加角色', 'AddRole', '', 1); INSERT INTO `authority` VALUES (6022, 602, '编辑角色', 'EditRole', '', 1); INSERT INTO `authority` VALUES (6023, 602, '删除角色', 'DeleteRole', '', 1); INSERT INTO `authority` VALUES (6024, 602, '更改角色权限', 'UpdateRoleAuthority', '', 1); INSERT INTO `authority` VALUES (6031, 603, '更改职工权限', 'UpdateEmployeeAuthority', '', 1); INSERT INTO `authority` VALUES (6032, 603, '更改学生权限', 'UpdateStudentAuthority', '', 1); -- ---------------------------- -- Table structure for college -- ---------------------------- DROP TABLE IF EXISTS `college`; CREATE TABLE `college` ( `college_id` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT '学院ID', `college_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学院名', PRIMARY KEY (`college_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of college -- ---------------------------- INSERT INTO `college` VALUES (1, '马克思主义学院'); INSERT INTO `college` VALUES (2, '文学与传媒学院'); INSERT INTO `college` VALUES (3, '化学与材料工程学院'); INSERT INTO `college` VALUES (4, '计算机科学与工程学院'); INSERT INTO `college` VALUES (5, '电子信息与电气工程学院'); INSERT INTO `college` VALUES (6, '外国语学院'); INSERT INTO `college` VALUES (7, '生命科学学院'); INSERT INTO `college` VALUES (8, '旭日广东服装学院'); INSERT INTO `college` VALUES (9, '地理与旅游学院'); INSERT INTO `college` VALUES (10, '体育学院'); INSERT INTO `college` VALUES (11, '经济管理学院'); INSERT INTO `college` VALUES (12, '美术与设计学院'); INSERT INTO `college` VALUES (13, '建筑与土木工程学院'); INSERT INTO `college` VALUES (14, '音乐学院'); INSERT INTO `college` VALUES (15, '政法学院'); INSERT INTO `college` VALUES (16, '教育科学学院'); INSERT INTO `college` VALUES (17, '数学与统计学院'); -- ---------------------------- -- Table structure for dorm -- ---------------------------- DROP TABLE IF EXISTS `dorm`; CREATE TABLE `dorm` ( `id` int(255) NOT NULL AUTO_INCREMENT, `dorm_build_id` int(10) NOT NULL, `dorm_number` int(10) NOT NULL COMMENT '宿舍号', `dorm_population` int(10) NOT NULL COMMENT '宿舍人数', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8801 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of dorm -- ---------------------------- INSERT INTO `dorm` VALUES (1, 1, 101, 5); INSERT INTO `dorm` VALUES (2, 1, 102, 6); INSERT INTO `dorm` VALUES (3