基于springboot+vue的物业缴费、停车管理系统

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: springboot10262 -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `springboot10262` -- /*!40000 DROP DATABASE IF EXISTS `springboot10262`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springboot10262` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `springboot10262`; -- -- Table structure for table `aboutus` -- DROP TABLE IF EXISTS `aboutus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `aboutus` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `title` varchar(200) NOT NULL COMMENT '标题', `subtitle` varchar(200) DEFAULT NULL COMMENT '副标题', `content` longtext NOT NULL COMMENT '内容', `picture1` longtext COMMENT '图片1', `picture2` longtext COMMENT '图片2', `picture3` longtext COMMENT '图片3', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='关于我们'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `aboutus` -- LOCK TABLES `aboutus` WRITE; /*!40000 ALTER TABLE `aboutus` DISABLE KEYS */; INSERT INTO `aboutus` VALUES (1,'2023-01-09 12:23:27','关于我们','ABOUT US','不管你想要怎样的生活，你都要去努力争取，不多尝试一些事情怎么知道自己适合什么、不适合什么呢?\n你说你喜欢读书，让我给你列书单，你还问我哪里有那么多时间看书;你说自己梦想的职业是广告文案，问我如何成为一个文案，应该具备哪些素质;你说你计划晨跑，但总是因为学习、工作辛苦或者身体不舒服第二天起不了床;你说你一直梦想一个人去长途旅行，但是没钱，父母觉得危险。其实，我已经厌倦了你这样说说而已的把戏，我觉得就算我告诉你如何去做，你也不会照做，因为你根本什么都不做。','upload/aboutus_picture1.jpg','upload/aboutus_picture2.jpg','upload/aboutus_picture3.jpg'); /*!40000 ALTER TABLE `aboutus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cheweigoumai` -- DROP TABLE IF EXISTS `cheweigoumai`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cheweigoumai` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `goumaibianhao` varchar(200) DEFAULT NULL COMMENT '购买编号', `cheweileibie` varchar(200) DEFAULT NULL COMMENT '车位类别', `cheweimingcheng` varchar(200) DEFAULT NULL COMMENT '车位名称', `shoujia` int(11) DEFAULT NULL COMMENT '售价', `goumaishijian` date DEFAULT NULL COMMENT '购买时间', `yezhuzhanghao` varchar(200) DEFAULT NULL COMMENT '业主账号', `yezhuxingming` varchar(200) DEFAULT NULL COMMENT '业主姓名', `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核', `shhf` longtext COMMENT '审核回复', `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付', PRIMARY KEY (`id`), UNIQUE KEY `goumaibianhao` (`goumaibianhao`) ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='车位购买'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cheweigoumai` -- LOCK TABLES `cheweigoumai` WRITE; /*!40000 ALTER TABLE `cheweigoumai` DISABLE KEYS */; INSERT INTO `cheweigoumai` VALUES (71,'2023-01-09 12:23:26','1111111111','车位类别1','车位名称1',1,'2023-01-09','业主账号1','业主姓名1','是','','未支付'),(72,'2023-01-09 12:23:26','2222222222','车位类别2','车位名称2',2,'2023-01-09','业主账号2','业主姓名2','是','','未支付'),(73,'2023-01-09 12:23:26','3333333333','车位类别3','车位名称3',3,'2023-01-09','业主账号3','业主姓名3','是','','未支付'),(74,'2023-01-09 12:23:26','4444444444','车位类别4','车位名称4',4,'2023-01-09','业主账号4','业主姓名4','是','','未支付'),(75,'2023-01-09 12:23:26','5555555555','车位类别5','车位名称5',5,'2023-01-09','业主账号5','业主姓名5','是','','未支付'),(76,'2023-01-09 12:23:26','6666666666','车位类别6','车位名称6',6,'2023-01-09','业主账号6','业主姓名6','是','','未支付'),(77,'2023-01-09 12:23:26','7777777777','车位类别7','车位名称7',7,'2023-01-09','业主账号7','业主姓名7','是','','未支付'),(78,'2023-01-09 12:23:26','8888888888','车位类别8','车位名称8',8,'2023-01-09','业主账号8','业主姓名8','是','','未支付'); /*!40000 ALTER TABLE `cheweigoumai` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cheweileibie` -- DROP TABLE IF EXISTS `cheweileibie`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cheweileibie` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `cheweileibie` varchar(200) NOT NULL COMMENT '车位类别', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='车位类别'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cheweileibie` -- LOCK TABLES `cheweileibie` WRITE; /*!40000 ALTER TABLE `cheweileibie` DISABLE KEYS */; INSERT INTO `cheweileibie` VALUES (41,'2023-01-09 12:23:26','车位类别1'),(42,'2023-01-09 12:23:26','车位类别2'),(43,'2023-01-09 12:23:26','车位类别3'),(44,'2023-01-09 12:23:26','车位类别4'),(45,'2023-01-09 12:23:26','车位类别5'),(46,'2023-01-09 12:23:26','车位类别6'),(47,'2023-01-09 12:23:26','车位类别7'),(48,'2023-01-09 12:23:26','车位类别8'); /*!40000 ALTER TABLE `cheweileibie` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cheweixinxi` -- DROP TABLE IF EXISTS `cheweixinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cheweixinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `cheweibianhao` varchar(200) DEFAULT NULL COMMENT '车位编号', `cheweimingcheng` varchar(200) NOT NULL COMMENT '车位名称', `cheweileibie` varchar(200) DEFAULT NULL COMMENT '车位类别', `cheweishuliang` int(11) DEFAULT NULL COMMENT '车位数量', `tupian` longtext COMMENT '图片', `weizhi` varchar(200) DEFAULT NULL COMMENT '位置', `cheweizhuangtai` varchar(200) DEFAULT NULL COMMENT '车位状态', `yuezujiage` int(11) DEFAULT NULL COMMENT '月租价格', `shoujia` int(11) DEFAULT NULL COMMENT '售价', `beizhu` longtext COMMENT '备注', PRIMARY KEY (`id`), UNIQUE KEY `cheweibianhao` (`cheweibianhao`) ) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='车位信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cheweixinxi` -- LOCK TABLES `cheweixinxi` WRITE; /*!40000 ALTER TABLE `cheweixinxi` DISABLE KEYS */; INSERT INTO `cheweixinxi` VALUES (51,'2023-01-09 12:23:26','1111111111','车位名称1','车位类别1',1,'upload/cheweixinxi_tupian1.jpg,upload/cheweixinxi_