Vue+Spring boot的智慧物业管理系统的设计与实现

-- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(10) NOT NULL COMMENT '管理员', `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码', `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机', `sex` int(10) NULL DEFAULT NULL COMMENT '性别', `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES (1, 'admin', '123456', '17805054371', 0, '744621980@qq.com'); -- ---------------------------- -- Table structure for building -- ---------------------------- DROP TABLE IF EXISTS `building`; CREATE TABLE `building` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `type` int(10) NULL DEFAULT NULL COMMENT '0：电梯；1：楼梯', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of building -- ---------------------------- INSERT INTO `building` VALUES (1, 'A', 0); INSERT INTO `building` VALUES (2, 'B', 0); INSERT INTO `building` VALUES (3, 'C', 1); INSERT INTO `building` VALUES (4, 'D', 1); -- ---------------------------- -- Table structure for car -- ---------------------------- DROP TABLE IF EXISTS `car`; CREATE TABLE `car` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '停车位名称', `type` int(10) NULL DEFAULT NULL COMMENT '地面或者地下', `status` int(10) NULL DEFAULT NULL COMMENT '是否为空', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of car -- ---------------------------- INSERT INTO `car` VALUES (1, '车位1', 0, 1); INSERT INTO `car` VALUES (2, '车位2', 0, 0); INSERT INTO `car` VALUES (3, '车位3', 0, 1); INSERT INTO `car` VALUES (4, '车位4', 0, 0); INSERT INTO `car` VALUES (5, '车位5', 0, 0); INSERT INTO `car` VALUES (6, '车位6', 0, 0); INSERT INTO `car` VALUES (7, '车位7', 0, 0); INSERT INTO `car` VALUES (8, '车位8', 0, 0); INSERT INTO `car` VALUES (9, '车位9', 0, 0); INSERT INTO `car` VALUES (10, '车位10', 0, 0); INSERT INTO `car` VALUES (11, '车位11', 0, 0); INSERT INTO `car` VALUES (12, '车位12', 0, 0); INSERT INTO `car` VALUES (13, '车位13', 0, 0); INSERT INTO `car` VALUES (14, '车位14', 0, 0); INSERT INTO `car` VALUES (15, '车位15', 0, 0); INSERT INTO `car` VALUES (16, '车位16', 0, 0); INSERT INTO `car` VALUES (17, '车位17', 0, 0); INSERT INTO `car` VALUES (18, '车位18', 0, 0); INSERT INTO `car` VALUES (19, '车位19', 0, 0); INSERT INTO `car` VALUES (20, '车位20', 1, 1); INSERT INTO `car` VALUES (21, '车位21', 1, 0); INSERT INTO `car` VALUES (22, '车位22', 1, 0); INSERT INTO `car` VALUES (23, '车位23', 1, 0); INSERT INTO `car` VALUES (24, '车位24', 1, 0); INSERT INTO `car` VALUES (25, '车位25', 1, 0); INSERT INTO `car` VALUES (26, '车位26', 1, 0); INSERT INTO `car` VALUES (27, '车位27', 1, 0); INSERT INTO `car` VALUES (28, '车位28', 1, 0); INSERT INTO `car` VALUES (29, '车位29', 1, 0); INSERT INTO `car` VALUES (30, '车位30', 1, 0); INSERT INTO `car` VALUES (31, '车位31', 1, 0); INSERT INTO `car` VALUES (32, '车位32', 1, 0); INSERT INTO `car` VALUES (33, '车位33', 1, 0); INSERT INTO `car` VALUES (34, '车位34', 1, 0); INSERT INTO `car` VALUES (35, '车位35', 1, 0); INSERT INTO `car` VALUES (36, '车位36', 1, 0); INSERT INTO `car` VALUES (37, '车位37', 1, 0); INSERT INTO `car` VALUES (38, '车位38', 1, 0); INSERT INTO `car` VALUES (39, '车位39', 1, 0); INSERT INTO `car` VALUES (40, '车位40', 1, 0); INSERT INTO `car` VALUES (41, '车位41', 1, 0); INSERT INTO `car` VALUES (42, '车位42', 1, 0); INSERT INTO `car` VALUES (43, '车位43', 1, 0); INSERT INTO `car` VALUES (44, '车位44', 1, 0); INSERT INTO `car` VALUES (45, '车位45', 1, 0); INSERT INTO `car` VALUES (46, '车位46', 1, 0); INSERT INTO `car` VALUES (47, '车位47', 1, 0); INSERT INTO `car` VALUES (48, '车位48', 1, 0); INSERT INTO `car` VALUES (49, '车位49', 1, 0); INSERT INTO `car` VALUES (50, '车位50', 1, 0); INSERT INTO `car` VALUES (51, '车位51', 1, 0); INSERT INTO `car` VALUES (52, '车位52', 1, 0); INSERT INTO `car` VALUES (53, '车位53', 1, 0); INSERT INTO `car` VALUES (54, '车位54', 1, 0); INSERT INTO `car` VALUES (55, '车位55', 1, 0); INSERT INTO `car` VALUES (56, '车位56', 1, 0); INSERT INTO `car` VALUES (57, '车位57', 1, 0); INSERT INTO `car` VALUES (58, '车位58', 1, 0); INSERT INTO `car` VALUES (59, '车位59', 1, 0); INSERT INTO `car` VALUES (60, '车位60', 1, 0); -- ---------------------------- -- Table structure for danyuan -- ---------------------------- DROP TABLE IF EXISTS `danyuan`; CREATE TABLE `danyuan` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `building_id` int(10) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `building`(`building_id`) USING BTREE, CONSTRAINT `building` FOREIGN KEY (`building_id`) REFERENCES `building` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of danyuan -- ---------------------------- INSERT INTO `danyuan` VALUES (1, 'A1单元', 1); INSERT INTO `danyuan` VALUES (2, 'A2单元', 1); INSERT INTO `danyuan` VALUES (3, 'B1单元', 2); INSERT INTO `danyuan` VALUES (4, 'B2单元', 2); INSERT INTO `danyuan` VALUES (5, 'C1单元', 3); INSERT INTO `danyuan` VALUES (6, 'C2单元', 3); INSERT INTO `danyuan` VALUES (7, 'D1单元', 4); INSERT INTO `danyuan` VALUES (8, 'D2单元', 4); -- ---------------------------- -- Table structure for gonggao -- ---------------------------- DROP TABLE IF EXISTS `gonggao`; CREATE TABLE `gonggao` ( `id` int(10) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '公告标题', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '公告内容', `createBy` int(10) NULL DEFAULT NULL COMMENT '创建者', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateBy` int(10) NULL DEFAULT NULL COMMENT '修改者', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间', `status` int(10) NULL DEFAULT NULL COMMENT '是否展示', PRIMARY KEY (`id`) USING BTREE, INDEX `create`(`createBy`) USING BTREE, INDEX `update`(`updateBy`) USING BTREE, CONSTRAINT `create` FOREIGN KEY (`createBy`) REFERENCES `admin` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `update` FOREIGN KEY (`updateBy`) REFERENCES `admin` (`id`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of gonggao -- ---------------------------- INSERT INTO `gonggao` VALUES (1, '公告一', '测试一下', 1, '2020-03-03 09:39:46', 1, '2020-03-03 06:11:25', 0); INSERT INTO `gonggao` VALUES (2, '公告二', '再测试以下', 1, '2020-03-03 09:40:06', 1, '2020-03-03 01:59:44', 1); -- ---------------------------- -- Table