基于Vue.js的高校宿舍调配管理系统

-- 第五小组宿舍管理系统源代码(表) CREATE DATABASE dorm_mar_db; USE dorm_mar_db; -- 班级表 drop TABLE IF EXISTS class; CREATE TABLE class ( `class_name` varchar(10) NOT NULL COMMENT '班级名', `id` int NOT NULL AUTO_INCREMENT COMMENT '班级编号', PRIMARY KEY (`id`) ); -- 班主任表 drop TABLE IF EXISTS class_advisor; CREATE TABLE class_advisor ( `id` int NOT NULL COMMENT '班主任编号', `advisor_name` varchar(10) NOT NULL COMMENT '班主任姓名', `gender` enum('F','M') NULL DEFAULT 'M' COMMENT '班主任性别', `contact` varchar(12) NOT NULL COMMENT '联系方式', `password` varchar(20) NOT NULL DEFAULT 123456 COMMENT '密码', `class_id` int NOT NULL COMMENT '班级编号', PRIMARY KEY (`id`), CONSTRAINT `class_id_advisor` FOREIGN KEY (`class_id`) REFERENCES `class` (`id`) # 小心外键索引重复 ); -- 楼栋表 drop TABLE IF EXISTS building; CREATE TABLE building ( `id` int NOT NULL COMMENT '楼栋编号', `building_name` varchar(10) NULL COMMENT '楼栋名', `address` json NOT NULL COMMENT '楼栋地址', PRIMARY KEY (`id`) ); -- 宿管表 drop TABLE IF EXISTS dorm_supervisor; CREATE TABLE dorm_supervisor ( `id` int NOT NULL COMMENT '宿管编号', `supervisor_name` varchar(10) NOT NULL COMMENT '宿管姓名', `gender` enum('F','M') NULL DEFAULT 'M' COMMENT '宿管性别', `contact` varchar(12) NOT NULL COMMENT '联系方式', `password` varchar(20) NOT NULL DEFAULT 123456 COMMENT '密码', `building_id` int NOT NULL COMMENT '所属楼栋编号', PRIMARY KEY (`id`), CONSTRAINT `supervisor_id` FOREIGN KEY (`building_id`) REFERENCES `building` (`id`) ) ; -- 宿舍表 DROP TABLE IF EXISTS dormitory; CREATE TABLE dormitory ( `id` int NOT NULL COMMENT '宿舍编号', `type` enum('男生宿舍','女生宿舍') NOT NULL COMMENT '宿舍类型', PRIMARY KEY (`id`) ); -- 学生表 DROP TABLE IF EXISTS student; CREATE TABLE student ( `id` int COMMENT '学号', `stu_name` varchar(10) NOT NULL COMMENT '学生姓名', `gender` enum('F','M') NOT NULL COMMENT '学生性别', `contact` varchar(12) NOT NULL COMMENT '联系方式', `password` varchar(20) NOT NULL DEFAULT 123456 COMMENT '学生密码', `class_id` int NOT NULL COMMENT '班级编号', `dor_id` int NOT NULL COMMENT '宿舍编号', PRIMARY KEY (`id`), CONSTRAINT `class_id_student` FOREIGN KEY (`class_id`) REFERENCES`class` (`id`), CONSTRAINT `dor_id_student` FOREIGN KEY (`dor_id`) REFERENCES`dormitory` (`id`) ); -- 宿舍电量表 DROP TABLE IF EXISTS electricity; CREATE TABLE electricity ( `id` int NOT NULL COMMENT '编号', `dor_id` int NOT NULL COMMENT '宿舍编号', `battery` double NOT NULL DEFAULT 150 COMMENT '剩余电量', `used_elect` double NOT NULL DEFAULT 0, PRIMARY KEY (`id`), CONSTRAINT `dor_elect` FOREIGN KEY (`dor_id`) REFERENCES `dormitory` (`id`) ); -- 外来人员表 DROP TABLE IF EXISTS external_visitor; CREATE TABLE external_visitor ( `id` int NOT NULL COMMENT '外来人员编号', `visitor_name` varchar(10) NOT NULL COMMENT '外来人员姓名\r\n', `gender` enum('F','M') NOT NULL DEFAULT 'M' COMMENT '外来人员性别', `contact` varchar(12) NOT NULL COMMENT '联系方式', `supervisor_id` int NOT NULL COMMENT '宿管编号', `visit_start` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '来访时间', `vist_end` datetime NULL DEFAULT NULL COMMENT '离开时间', `reason` varchar(50) NOT NULL COMMENT '来访事由', PRIMARY KEY (`id`), CONSTRAINT `supervisor_id_visitor` FOREIGN KEY (`supervisor_id`) REFERENCES `dorm_supervisor` (`id`) ); -- 物品表 DROP TABLE IF EXISTS asset; CREATE TABLE asset ( `id` int NOT NULL AUTO_INCREMENT COMMENT '物品编号', `name` varchar(20) NOT NULL COMMENT '物品名称', `type` enum('电器','家具','其他') NOT NULL DEFAULT '其他' COMMENT '物品类别', `state` enum('正常','损坏') NOT NULL DEFAULT '正常' COMMENT '物品状态', `dor_id` int NULL COMMENT '宿舍号', PRIMARY KEY (`id`), CONSTRAINT `dor_id_asset` FOREIGN KEY (`dor_id`) REFERENCES `dorm_mar_db`.`dormitory` (`id`) ); -- 投诉表 DROP TABLE IF EXISTS complaint; CREATE TABLE complaint ( `id` int NOT NULL COMMENT '编号', `student_id` int COMMENT '投诉者编号', `type` enum('学生间纠纷','其他纠纷') NOT NULL DEFAULT '学生间纠纷' COMMENT '投诉类型', `describe` varchar(50) NULL COMMENT '描述', `address` json NOT NULL COMMENT '事发地点', PRIMARY KEY (`id`), CONSTRAINT `stu_id_comp` FOREIGN KEY (`student_id`) REFERENCES `student` (`id`) );