基于微信小程序的房屋交易平台+后台管理系统(SSM+mysql)-JAVA.VUE【毕业设计、论文、源码、开题报告】

本文链接：https://blog.csdn.net/itrjxxs_2/article/details/128436250
功能介绍

管理员：首页、个人中心、房子户型管理、门店信息管理、用户管理、经纪人管理、房源信息管理、售房订单管理、租房信息管理、租房订单管理、求购信息管理、求租信息管理、系统管理，
用户；首页、房源信息、租房信息、我的等
数据库脚本

/*
SQLyog Ultimate v9.30 
MySQL - 5.7.26 : Database - ssms5akf
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`ssms5akf` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;

USE `ssms5akf`;

/*Table structure for table `config` */

DROP TABLE IF EXISTS `config`;

CREATE TABLE `config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='配置文件';

/*Data for the table `config` */

insert  into `config`(`id`,`name`,`value`) values (1,'picture1','http://localhost:8080/ssms5akf/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/ssms5akf/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/ssms5akf/upload/picture3.jpg'),(6,'homepage','http://localhost:8080/ssms5akf/upload/1615190729864.jpg');

/*Table structure for table `fangyuanxinxi` */

DROP TABLE IF EXISTS `fangyuanxinxi`;

CREATE TABLE `fangyuanxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `fangyuanmingcheng` varchar(200) DEFAULT NULL COMMENT '房源名称',
  `fangyuanleixing` varchar(200) DEFAULT NULL COMMENT '房源类型',
  `fangzihuxing` varchar(200) DEFAULT NULL COMMENT '房子户型',
  `fangyuanquyu` varchar(200) DEFAULT NULL COMMENT '房源区域',
  `fangyuantupian` varchar(200) DEFAULT NULL COMMENT '房源图片',
  `zhuangtai` varchar(200) DEFAULT NULL COMMENT '状态',
  `jutiweizhi` varchar(200) DEFAULT NULL COMMENT '具体位置',
  `mianji` varchar(200) DEFAULT NULL COMMENT '面积',
  `meimijiage` varchar(200) DEFAULT NULL COMMENT '每米价格',
  `zongjine` varchar(200) DEFAULT NULL COMMENT '总金额',
  `jingjirenzhanghao` varchar(200) DEFAULT NULL COMMENT '经纪人账号',
  `jingjirenxingming` varchar(200) DEFAULT NULL COMMENT '经纪人姓名',
  `fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1615190981006 DEFAULT CHARSET=utf8 COMMENT='房源信息';

/*Data for the table `fangyuanxinxi` */

insert  into `fangyuanxinxi`(`id`,`addtime`,`fangyuanmingcheng`,`fangyuanleixing`,`fangzihuxing`,`fangyuanquyu`,`fangyuantupian`,`zhuangtai`,`jutiweizhi`,`mianji`,`meimijiage`,`zongjine`,`jingjirenzhanghao`,`jingjirenxingming`,`fabushijian`,`userid`) values (51,'2021-03-08 15:56:41','房源名称1','新房','房子户型1','房源区域1','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian1.jpg','待售','具体位置1','面积1','每米价格1','总金额1','经纪人账号1','经纪人姓名1','2021-03-08 15:56:41',1),(52,'2021-03-08 15:56:41','房源名称2','新房','房子户型2','房源区域2','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian2.jpg','待售','具体位置2','面积2','每米价格2','总金额2','经纪人账号2','经纪人姓名2','2021-03-08 15:56:41',2),(53,'2021-03-08 15:56:41','房源名称3','新房','房子户型3','房源区域3','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian3.jpg','待售','具体位置3','面积3','每米价格3','总金额3','经纪人账号3','经纪人姓名3','2021-03-08 15:56:41',3),(54,'2021-03-08 15:56:41','房源名称4','新房','房子户型4','房源区域4','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian4.jpg','待售','具体位置4','面积4','每米价格4','总金额4','经纪人账号4','经纪人姓名4','2021-03-08 15:56:41',4),(55,'2021-03-08 15:56:41','房源名称5','新房','房子户型5','房源区域5','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian5.jpg','待售','具体位置5','面积5','每米价格5','总金额5','经纪人账号5','经纪人姓名5','2021-03-08 15:56:41',5),(56,'2021-03-08 15:56:41','房源名称6','新房','房子户型6','房源区域6','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian6.jpg','待售','具体位置6','面积6','每米价格6','总金额6','经纪人账号6','经纪人姓名6','2021-03-08 15:56:41',6),(1615190981005,'2021-03-08 16:09:40','房源信息','新房','三房','深圳','http://localhost:8080/ssms5akf/upload/1615190968878.jpg','待售','范德萨范德萨','120','10000','1200000','123','胡继','2021-03-08 16:16:56',1615190622179);

/*Table structure for table `fangzihuxing` */

DROP TABLE IF EXISTS `fangzihuxing`;

CREATE TABLE `fangzihuxing` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `fangzihuxing` varchar(200) NOT NULL COMMENT '房子户型',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fangzihuxing` (`fangzihuxing`)
) ENGINE=InnoDB AUTO_INCREMENT=1615190571580 DEFAULT CHARSET=utf8 COMMENT='房子户型';

/*Data for the table `fangzihuxing` */

insert  into `fangzihuxing`(`id`,`addtime`,`fangzihuxing`) values (11,'2021-03-08 15:56:41','房子户型1'),(12,'2021-03-08 15:56:41','房子户型2'),(13,'2021-03-08 15:56:41','房子户型3'),(14,'2021-03-08 15:56:41','房子户型4'),(15,'2021-03-08 15:56:41','房子户型5'),(16,'2021-03-08 15:56:41','房子户型6'),(1615190571579,'2021-03-08 16:02:50','三房');

/*Table structure for table `jingjiren` */

DROP TABLE IF EXISTS `jingjiren`;

CREATE TABLE `jingjiren` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingjirenzhanghao` varchar(200) NOT NULL COMMENT '经纪人账号',
  `jingjirenxingming` varchar(200) NOT NULL COMMENT '经纪人姓名',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `nianling` int(11) DEFAULT NULL COMMENT '年龄',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
  `dianziyouxiang` varchar(200) DEFAULT NULL COMMENT '电子邮箱',
  `mendianmingcheng` varchar(200) DEFAULT NULL COMMENT '门店名称',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  PRIMARY KEY (`id`),
  UNIQUE KEY `jingjirenzhanghao` (`jingjirenzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1615190622180 DEFAULT CHARSET=utf8 COMMENT='经纪人';

/*Data for the table `jingjiren` */

insert  into `jingjiren`(`id`,`addtime`,`jingjirenzhanghao`,`jingjirenxingming`,`mima`,`xingbie`,`nianling`,`lianxidianhua`,`dianziyouxiang`,`mendianmingcheng`,`touxiang`) values (41,'2021-03-08 15:56:41','经纪人1','经纪人姓名1','123456','男',1,'13823888881','773890001@qq.com','门店名称1','http://localhost:8080/ssms5akf/upload/jingjiren_touxiang1.jpg'),(42,'2021-03-08 15:56:41','经纪人2','经纪人姓名2','123456','男',2,'13823888882','773890002@qq.com','门店名称2','http://localhost:8080/ssms5akf/upload/jingjiren_touxiang2.jpg'),(43,'2021-03-08 15:56:41','经纪人3','经纪人姓名3','123456','男',3,'13823888883','773890003@qq.com','门店名称3','http://localhost:8080/ssms5akf/upload/jingjiren_touxiang3.jpg'),(44,'2021-03-08 15:56:41','经纪人4','经纪人姓名4','123456','男',4,'13823888884','773890004@qq.com','门店名称4','http://localhost:8080/ssms5akf/upload/jingjiren_touxiang4.jpg'),(45,'2021-03-08 15:56:41','经纪人5','经纪人姓名5','123456','男',5,'13823888885','773890005@qq.com','门店名称5','http://localhost:8080/ssms5akf/upload/jingjiren_touxiang5.jpg'),(46,'2021-03-08 15:56:41','经纪人6','经纪人姓名6','123456','男',6,'13823888886','773890006@qq.com','门店名称6','http://localhost:8080/ssms5akf/upload/jingjiren_touxiang6.jpg'),(1615190622179,'2021-03-08 16:03:42','123','胡继','123','男',23,'13513613636','265565@qq.com','美达','http://localhost:8080/ssms5akf/upload/1615190609026.jpg');

/*Table structure for table `mendianxinxi` */

DROP TABLE IF EXISTS `mendianxinxi`;

CREATE TABLE `mendianxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `mendianmingcheng` varchar(200) NOT NULL COMMENT '门店名称',
  `mendiantupian` varchar(200) DEFAULT NULL COMMENT '门店图片',
  `mendiandizhi` varchar(200) DEFAULT NULL COMMENT '门店地址',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
  `jingyingfanwei` longtext COMMENT '经营范围',
  `jianzhumianji` varchar(200) DEFAULT NULL COMMENT '建筑面积',
  `mendianjieshao` longtext COMMENT '门店介绍',
  `clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1615190671450 DEFAULT CHARSET=utf8 COMMENT='门店信息';

/*Data for the table `mendianxinxi` */

insert  into `mendianxinxi`(`id`,`addtime`,`mendianmingcheng`,`mendiantupian`,`mendiandizhi`,`lianxidianhua`,`jingyingfanwei`,`jianzhumianji`,`mendianjieshao`,`clicknum`) values (21,'2021-03-08 15:56:41','门店名称1','http://localhost:8080/ssms5akf/upload/mendianxinxi_mendiantupian1.jpg','门店地址1','13823888881','经营范围1','建筑面积1','门店介绍1',3),(22,'2021-03-08 15:56:41','门店名称2','http://localhost:8080/ssms5akf/upload/mendianxinxi_mendiantupian2.jpg','门店地址2','13823888882','经营范围2','建筑面积2','门店介绍2',2),(23,'2021-03-08 15:56:41','门店名称3','http://localhost:8080/ssms5akf/upload/mendianxinxi_mendiantupian3.jpg','门店地址3','13823888883','经营范围3','建筑面积3','门店介绍3',3),(24,'2021-03-08 15:56:41','门店名称4','http://localhost:8080/ssms5akf/upload/mendianxinxi_mendiantupian4.jpg','门店地址4','13823888884','经营范围4','建筑面积4','门店介绍4',4),(25,'2021-03-08 15:56:41','门店名称5','http://localhost:8080/ssms5akf/upload/mendianxinxi_mendiantupian5.jpg','门店地址5','13823888885','经营范围5','建筑面积5','门店介绍5',5),(26,'2021-03-08 15:56:41','门店名称6','http://localhost:8080/ssms5akf/upload/mendianxinxi_mendiantupian6.jpg','门店地址6','13823888886','经营范围6','建筑面积6','门店介绍6',6),(1615190671449,'2021-03-08 16:04:30','美达','http://localhost:8080/ssms5akf/upload/1615190646185.jpg','范德萨范德萨','13513613636','发反对反对马萨卡附近的刷卡房价肯定啥夫卡的数据库但是','100平方米','<p><strong style=\"background-color: rgb(244, 238, 238);\">基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台</strong></p>',4);

/*Table structure for table `news` */

DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `title` varchar(200) NOT NULL COMMENT '标题',
  `introduction` longtext COMMENT '简介',
  `picture` varchar(200) NOT NULL COMMENT '图片',
  `content` longtext NOT NULL COMMENT '内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1615190747318 DEFAULT CHARSET=utf8 COMMENT='系统公告';

/*Data for the table `news` */

insert  into `news`(`id`,`addtime`,`title`,`introduction`,`picture`,`content`) values (121,'2021-03-08 15:56:41','标题1','简介1','http://localhost:8080/ssms5akf/upload/news_picture1.jpg','内容1'),(122,'2021-03-08 15:56:41','标题2','简介2','http://localhost:8080/ssms5akf/upload/news_picture2.jpg','内容2'),(123,'2021-03-08 15:56:41','标题3','简介3','http://localhost:8080/ssms5akf/upload/news_picture3.jpg','内容3'),(124,'2021-03-08 15:56:41','标题4','简介4','http://localhost:8080/ssms5akf/upload/news_picture4.jpg','内容4'),(125,'2021-03-08 15:56:41','标题5','简介5','http://localhost:8080/ssms5akf/upload/news_picture5.jpg','内容5'),(126,'2021-03-08 15:56:41','标题6','简介6','http://localhost:8080/ssms5akf/upload/news_picture6.jpg','内容6'),(1615190747317,'2021-03-08 16:05:46','系统公告','基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台','http://localhost:8080/ssms5akf/upload/1615190741573.jpg','<p><strong style=\"background-color: rgb(244, 238, 238);\">基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台基于微信小程序的房屋交易平台屋交易平台</strong></p>');

/*Table structure for table `qiugouxinxi` */

DROP TABLE IF EXISTS `qiugouxinxi`;

CREATE TABLE `qiugouxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `fangzihuxing` varchar(200) DEFAULT NULL COMMENT '房子户型',
  `quyufanwei` varchar(200) DEFAULT NULL COMMENT '区域范围',
  `yusuanjiage` varchar(200) DEFAULT NULL COMMENT '预算价格',
  `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
  `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
  `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
  `fangyuanyaoqiu` longtext COMMENT '房源要求',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1615191163795 DEFAULT CHARSET=utf8 COMMENT='求购信息';

/*Data for the table `qiugouxinxi` */

insert  into `qiugouxinxi`(`id`,`addtime`,`fangzihuxing`,`quyufanwei`,`yusuanjiage`,`yonghuzhanghao`,`yonghuxingming`,`lianxidianhua`,`fengmian`,`fangyuanyaoqiu`,`userid`) values (91,'2021-03-08 15:56:41','房子户型1','区域范围1','预算价格1','用户账号1','用户姓名1','联系电话1','http://localhost:8080/ssms5akf/upload/qiugouxinxi_fengmian1.jpg','房源要求1',1),(92,'2021-03-08 15:56:41','房子户型2','区域范围2','预算价格2','用户账号2','用户姓名2','联系电话2','http://localhost:8080/ssms5akf/upload/qiugouxinxi_fengmian2.jpg','房源要求2',2),(93,'2021-03-08 15:56:41','房子户型3','区域范围3','预算价格3','用户账号3','用户姓名3','联系电话3','http://localhost:8080/ssms5akf/upload/qiugouxinxi_fengmian3.jpg','房源要求3',3),(94,'2021-03-08 15:56:41','房子户型4','区域范围4','预算价格4','用户账号4','用户姓名4','联系电话4','http://localhost:8080/ssms5akf/upload/qiugouxinxi_fengmian4.jpg','房源要求4',4),(95,'2021-03-08 15:56:41','房子户型5','区域范围5','预算价格5','用户账号5','用户姓名5','联系电话5','http://localhost:8080/ssms5akf/upload/qiugouxinxi_fengmian5.jpg','房源要求5',5),(96,'2021-03-08 15:56:41','房子户型6','区域范围6','预算价格6','用户账号6','用户姓名6','联系电话6','http://localhost:8080/ssms5akf/upload/qiugouxinxi_fengmian6.jpg','房源要求6',6),(1615191163794,'2021-03-08 16:12:43','三房','fdsa ','250000','111','胡玉','13513513525','http://localhost:8080/ssms5akf/upload/1615191160945.jpg','dfsa fdsa fds fds ',1615190910725);

/*Table structure for table `qiuzuxinxi` */

DROP TABLE IF EXISTS `qiuzuxinxi`;

CREATE TABLE `qiuzuxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `fangzihuxing` varchar(200) DEFAULT NULL COMMENT '房子户型',
  `quyufanwei` varchar(200) DEFAULT NULL COMMENT '区域范围',
  `yusuanjiage` varchar(200) DEFAULT NULL COMMENT '预算价格',
  `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
  `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
  `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
  `fangyuanyaoqiu` longtext COMMENT '房源要求',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1615191189848 DEFAULT CHARSET=utf8 COMMENT='求租信息';

/*Data for the table `qiuzuxinxi` */

insert  into `qiuzuxinxi`(`id`,`addtime`,`fangzihuxing`,`quyufanwei`,`yusuanjiage`,`yonghuzhanghao`,`yonghuxingming`,`lianxidianhua`,`fengmian`,`fangyuanyaoqiu`,`userid`) values (101,'2021-03-08 15:56:41','房子户型1','区域范围1','预算价格1','用户账号1','用户姓名1','联系电话1','http://localhost:8080/ssms5akf/upload/qiuzuxinxi_fengmian1.jpg','房源要求1',1),(102,'2021-03-08 15:56:41','房子户型2','区域范围2','预算价格2','用户账号2','用户姓名2','联系电话2','http://localhost:8080/ssms5akf/upload/qiuzuxinxi_fengmian2.jpg','房源要求2',2),(103,'2021-03-08 15:56:41','房子户型3','区域范围3','预算价格3','用户账号3','用户姓名3','联系电话3','http://localhost:8080/ssms5akf/upload/qiuzuxinxi_fengmian3.jpg','房源要求3',3),(104,'2021-03-08 15:56:41','房子户型4','区域范围4','预算价格4','用户账号4','用户姓名4','联系电话4','http://localhost:8080/ssms5akf/upload/qiuzuxinxi_fengmian4.jpg','房源要求4',4),(105,'2021-03-08 15:56:41','房子户型5','区域范围5','预算价格5','用户账号5','用户姓名5','联系电话5','http://localhost:8080/ssms5akf/upload/qiuzuxinxi_fengmian5.jpg','房源要求5',5),(106,'2021-03-08 15:56:41','房子户型6','区域范围6','预算价格6','用户账号6','用户姓名6','联系电话6','http://localhost:8080/ssms5akf/upload/qiuzuxinxi_fengmian6.jpg','房源要求6',6),(1615191189847,'2021-03-08 16:13:09','三房','是否是大范德萨','2000','111','胡玉','13513513525','http://localhost:8080/ssms5akf/upload/1615191185777.jpg','dd撒法第三发你觉得撒谎比附近的啥叫发货的撒娇开发金葵花金葵花地方色彩',1615190910725);

/*Table structure for table `shoufangdingdan` */

DROP TABLE IF EXISTS `shoufangdingdan`;

CREATE TABLE `shoufangdingdan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
  `fangyuanmingcheng` varchar(200) DEFAULT NULL COMMENT '房源名称',
  `fangyuanleixing` varchar(200) DEFAULT NULL COMMENT '房源类型',
  `fangzihuxing` varchar(200) DEFAULT NULL COMMENT '房子户型',
  `fangyuanquyu` varchar(200) DEFAULT NULL COMMENT '房源区域',
  `fangyuantupian` varchar(200) DEFAULT NULL COMMENT '房源图片',
  `jutiweizhi` varchar(200) DEFAULT NULL COMMENT '具体位置',
  `mianji` varchar(200) DEFAULT NULL COMMENT '面积',
  `meimijiage` varchar(200) DEFAULT NULL COMMENT '每米价格',
  `zongjine` varchar(200) DEFAULT NULL COMMENT '总金额',
  `jingjirenzhanghao` varchar(200) DEFAULT NULL COMMENT '经纪人账号',
  `jingjirenxingming` varchar(200) DEFAULT NULL COMMENT '经纪人姓名',
  `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
  `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
  `goumaishijian` datetime DEFAULT NULL COMMENT '购买时间',
  `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1615191091018 DEFAULT CHARSET=utf8 COMMENT='售房订单';

/*Data for the table `shoufangdingdan` */

insert  into `shoufangdingdan`(`id`,`addtime`,`dingdanbianhao`,`fangyuanmingcheng`,`fangyuanleixing`,`fangzihuxing`,`fangyuanquyu`,`fangyuantupian`,`jutiweizhi`,`mianji`,`meimijiage`,`zongjine`,`jingjirenzhanghao`,`jingjirenxingming`,`yonghuzhanghao`,`yonghuxingming`,`goumaishijian`,`ispay`,`userid`) values (61,'2021-03-08 15:56:41','订单编号1','房源名称1','房源类型1','房子户型1','房源区域1','http://localhost:8080/ssms5akf/upload/shoufangdingdan_fangyuantupian1.jpg','具体位置1','面积1','每米价格1','总金额1','经纪人账号1','经纪人姓名1','用户账号1','用户姓名1','2021-03-08 15:56:41','未支付',1),(62,'2021-03-08 15:56:41','订单编号2','房源名称2','房源类型2','房子户型2','房源区域2','http://localhost:8080/ssms5akf/upload/shoufangdingdan_fangyuantupian2.jpg','具体位置2','面积2','每米价格2','总金额2','经纪人账号2','经纪人姓名2','用户账号2','用户姓名2','2021-03-08 15:56:41','未支付',2),(63,'2021-03-08 15:56:41','订单编号3','房源名称3','房源类型3','房子户型3','房源区域3','http://localhost:8080/ssms5akf/upload/shoufangdingdan_fangyuantupian3.jpg','具体位置3','面积3','每米价格3','总金额3','经纪人账号3','经纪人姓名3','用户账号3','用户姓名3','2021-03-08 15:56:41','未支付',3),(64,'2021-03-08 15:56:41','订单编号4','房源名称4','房源类型4','房子户型4','房源区域4','http://localhost:8080/ssms5akf/upload/shoufangdingdan_fangyuantupian4.jpg','具体位置4','面积4','每米价格4','总金额4','经纪人账号4','经纪人姓名4','用户账号4','用户姓名4','2021-03-08 15:56:41','未支付',4),(65,'2021-03-08 15:56:41','订单编号5','房源名称5','房源类型5','房子户型5','房源区域5','http://localhost:8080/ssms5akf/upload/shoufangdingdan_fangyuantupian5.jpg','具体位置5','面积5','每米价格5','总金额5','经纪人账号5','经纪人姓名5','用户账号5','用户姓名5','2021-03-08 15:56:41','未支付',5),(66,'2021-03-08 15:56:41','订单编号6','房源名称6','房源类型6','房子户型6','房源区域6','http://localhost:8080/ssms5akf/upload/shoufangdingdan_fangyuantupian6.jpg','具体位置6','面积6','每米价格6','总金额6','经纪人账号6','经纪人姓名6','用户账号6','用户姓名6','2021-03-08 15:56:41','未支付',6),(1615191091017,'2021-03-08 16:11:30','1615191568501','房源信息','新房','三房','深圳','http://localhost:8080/ssms5akf/upload/1615190968878.jpg','范德萨范德萨','120','10000','1200000','123','胡继','111','胡玉','2021-03-08 16:19:28','已支付',1615190910725);

/*Table structure for table `storeup` */

DROP TABLE IF EXISTS `storeup`;

CREATE TABLE `storeup` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `refid` bigint(20) DEFAULT NULL COMMENT '收藏id',
  `tablename` varchar(200) DEFAULT NULL COMMENT '表名',
  `name` varchar(200) NOT NULL COMMENT '收藏名称',
  `picture` varchar(200) NOT NULL COMMENT '收藏图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1643104872341 DEFAULT CHARSET=utf8 COMMENT='收藏表';

/*Data for the table `storeup` */

insert  into `storeup`(`id`,`addtime`,`userid`,`refid`,`tablename`,`name`,`picture`) values (1615190925036,'2021-03-08 16:08:44',1615190622179,1615190671449,'mendianxinxi','美达','http://localhost:8080/ssms5akf/upload/1615190646185.jpg'),(1615191080107,'2021-03-08 16:11:19',1615190910725,1615190671449,'mendianxinxi','美达','http://localhost:8080/ssms5akf/upload/1615190646185.jpg'),(1615191117484,'2021-03-08 16:11:56',1615190910725,1615190671449,'mendianxinxi','美达','http://localhost:8080/ssms5akf/upload/1615190646185.jpg'),(1643104872340,'2022-01-25 18:01:12',31,21,'mendianxinxi','门店名称1','http://localhost:8080/ssms5akf/upload/mendianxinxi_mendiantupian1.jpg');

/*Table structure for table `token` */

DROP TABLE IF EXISTS `token`;

CREATE TABLE `token` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
  `role` varchar(100) DEFAULT NULL COMMENT '角色',
  `token` varchar(200) NOT NULL COMMENT '密码',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '新增时间',
  `expiratedtime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '过期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='token表';

/*Data for the table `token` */

insert  into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (1,1,'abo','users','管理员','qkcsu4r961hwoj39cl1nfpw5ysja4nih','2021-03-08 16:02:31','2022-01-25 19:02:18'),(2,1615190622179,'123','jingjiren','经纪人','bl05cuxx4ssgiq8e20s5zmwkryck3d47','2021-03-08 16:08:39','2021-03-08 17:13:26'),(3,1615190910725,'111','yonghu','用户','l9doihhwfl27mg1vf0oaxciszqlzgmky','2021-03-08 16:11:14','2021-03-08 17:11:14'),(4,31,'用户1','yonghu','用户','61k30ajle9h8i01hg0pbk3h8sasqnm15','2022-01-25 17:54:03','2022-01-25 19:00:40');

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

/*Data for the table `users` */

insert  into `users`(`id`,`username`,`password`,`role`,`addtime`) values (1,'itrjxxs','itrjxxs','管理员','2021-03-08 15:56:41');

/*Table structure for table `yonghu` */

DROP TABLE IF EXISTS `yonghu`;

CREATE TABLE `yonghu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yonghuzhanghao` varchar(200) NOT NULL COMMENT '用户账号',
  `yonghuxingming` varchar(200) NOT NULL COMMENT '用户姓名',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `nianling` int(11) DEFAULT NULL COMMENT '年龄',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
  `dianziyouxiang` varchar(200) DEFAULT NULL COMMENT '电子邮箱',
  `shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份证号',
  `jiatingdizhi` varchar(200) DEFAULT NULL COMMENT '家庭地址',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1615190910726 DEFAULT CHARSET=utf8 COMMENT='用户';

/*Data for the table `yonghu` */

insert  into `yonghu`(`id`,`addtime`,`yonghuzhanghao`,`yonghuxingming`,`mima`,`xingbie`,`nianling`,`lianxidianhua`,`dianziyouxiang`,`shenfenzhenghao`,`jiatingdizhi`) values (31,'2021-03-08 15:56:41','用户1','用户姓名1','123456','男',1,'13823888881','773890001@qq.com','440300199101010001','家庭地址1'),(32,'2021-03-08 15:56:41','用户2','用户姓名2','123456','男',2,'13823888882','773890002@qq.com','440300199202020002','家庭地址2'),(33,'2021-03-08 15:56:41','用户3','用户姓名3','123456','男',3,'13823888883','773890003@qq.com','440300199303030003','家庭地址3'),(34,'2021-03-08 15:56:41','用户4','用户姓名4','123456','男',4,'13823888884','773890004@qq.com','440300199404040004','家庭地址4'),(35,'2021-03-08 15:56:41','用户5','用户姓名5','123456','男',5,'13823888885','773890005@qq.com','440300199505050005','家庭地址5'),(36,'2021-03-08 15:56:41','用户6','用户姓名6','123456','男',6,'13823888886','773890006@qq.com','440300199606060006','家庭地址6'),(1615190910725,'2021-03-08 16:08:30','111','胡玉','111','女',23,'13513513525','26656@qq.com','123123123123123123','阳光胡玉');

/*Table structure for table `zufangdingdan` */

DROP TABLE IF EXISTS `zufangdingdan`;

CREATE TABLE `zufangdingdan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
  `fangyuanmingcheng` varchar(200) DEFAULT NULL COMMENT '房源名称',
  `fangyuanleixing` varchar(200) DEFAULT NULL COMMENT '房源类型',
  `fangzihuxing` varchar(200) DEFAULT NULL COMMENT '房子户型',
  `fangyuanquyu` varchar(200) DEFAULT NULL COMMENT '房源区域',
  `fangyuantupian` varchar(200) DEFAULT NULL COMMENT '房源图片',
  `jutiweizhi` varchar(200) DEFAULT NULL COMMENT '具体位置',
  `mianji` varchar(200) DEFAULT NULL COMMENT '面积',
  `zujin` varchar(200) DEFAULT NULL COMMENT '租金',
  `jingjirenzhanghao` varchar(200) DEFAULT NULL COMMENT '经纪人账号',
  `jingjirenxingming` varchar(200) DEFAULT NULL COMMENT '经纪人姓名',
  `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
  `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
  `zulinshijian` datetime DEFAULT NULL COMMENT '租赁时间',
  `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1615191100538 DEFAULT CHARSET=utf8 COMMENT='租房订单';

/*Data for the table `zufangdingdan` */

insert  into `zufangdingdan`(`id`,`addtime`,`dingdanbianhao`,`fangyuanmingcheng`,`fangyuanleixing`,`fangzihuxing`,`fangyuanquyu`,`fangyuantupian`,`jutiweizhi`,`mianji`,`zujin`,`jingjirenzhanghao`,`jingjirenxingming`,`yonghuzhanghao`,`yonghuxingming`,`zulinshijian`,`ispay`,`userid`) values (81,'2021-03-08 15:56:41','订单编号1','房源名称1','房源类型1','房子户型1','房源区域1','http://localhost:8080/ssms5akf/upload/zufangdingdan_fangyuantupian1.jpg','具体位置1','面积1','租金1','经纪人账号1','经纪人姓名1','用户账号1','用户姓名1','2021-03-08 15:56:41','未支付',1),(82,'2021-03-08 15:56:41','订单编号2','房源名称2','房源类型2','房子户型2','房源区域2','http://localhost:8080/ssms5akf/upload/zufangdingdan_fangyuantupian2.jpg','具体位置2','面积2','租金2','经纪人账号2','经纪人姓名2','用户账号2','用户姓名2','2021-03-08 15:56:41','未支付',2),(83,'2021-03-08 15:56:41','订单编号3','房源名称3','房源类型3','房子户型3','房源区域3','http://localhost:8080/ssms5akf/upload/zufangdingdan_fangyuantupian3.jpg','具体位置3','面积3','租金3','经纪人账号3','经纪人姓名3','用户账号3','用户姓名3','2021-03-08 15:56:41','未支付',3),(84,'2021-03-08 15:56:41','订单编号4','房源名称4','房源类型4','房子户型4','房源区域4','http://localhost:8080/ssms5akf/upload/zufangdingdan_fangyuantupian4.jpg','具体位置4','面积4','租金4','经纪人账号4','经纪人姓名4','用户账号4','用户姓名4','2021-03-08 15:56:41','未支付',4),(85,'2021-03-08 15:56:41','订单编号5','房源名称5','房源类型5','房子户型5','房源区域5','http://localhost:8080/ssms5akf/upload/zufangdingdan_fangyuantupian5.jpg','具体位置5','面积5','租金5','经纪人账号5','经纪人姓名5','用户账号5','用户姓名5','2021-03-08 15:56:41','未支付',5),(86,'2021-03-08 15:56:41','订单编号6','房源名称6','房源类型6','房子户型6','房源区域6','http://localhost:8080/ssms5akf/upload/zufangdingdan_fangyuantupian6.jpg','具体位置6','面积6','租金6','经纪人账号6','经纪人姓名6','用户账号6','用户姓名6','2021-03-08 15:56:41','未支付',6),(1615191100537,'2021-03-08 16:11:40','1615191578214','讲义','单身公寓','房子户型1','深圳','http://localhost:8080/ssms5akf/upload/1615191024985.jpg','范德萨范德萨','120','3000','123','胡继','111','胡玉','2021-03-08 16:19:38','已支付',1615190910725);

/*Table structure for table `zufangxinxi` */

DROP TABLE IF EXISTS `zufangxinxi`;

CREATE TABLE `zufangxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `fangyuanmingcheng` varchar(200) DEFAULT NULL COMMENT '房源名称',
  `fangyuanleixing` varchar(200) DEFAULT NULL COMMENT '房源类型',
  `fangzihuxing` varchar(200) DEFAULT NULL COMMENT '房子户型',
  `fangyuanquyu` varchar(200) DEFAULT NULL COMMENT '房源区域',
  `fangyuantupian` varchar(200) DEFAULT NULL COMMENT '房源图片',
  `zhuangtai` varchar(200) DEFAULT NULL COMMENT '状态',
  `jutiweizhi` varchar(200) DEFAULT NULL COMMENT '具体位置',
  `mianji` varchar(200) DEFAULT NULL COMMENT '面积',
  `zujin` varchar(200) DEFAULT NULL COMMENT '租金',
  `jingjirenzhanghao` varchar(200) DEFAULT NULL COMMENT '经纪人账号',
  `jingjirenxingming` varchar(200) DEFAULT NULL COMMENT '经纪人姓名',
  `fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1615191043563 DEFAULT CHARSET=utf8 COMMENT='租房信息';

/*Data for the table `zufangxinxi` */

insert  into `zufangxinxi`(`id`,`addtime`,`fangyuanmingcheng`,`fangyuanleixing`,`fangzihuxing`,`fangyuanquyu`,`fangyuantupian`,`zhuangtai`,`jutiweizhi`,`mianji`,`zujin`,`jingjirenzhanghao`,`jingjirenxingming`,`fabushijian`,`userid`) values (71,'2021-03-08 15:56:41','房源名称1','房源类型1','房子户型1','房源区域1','http://localhost:8080/ssms5akf/upload/zufangxinxi_fangyuantupian1.jpg','待租','具体位置1','面积1','租金1','经纪人账号1','经纪人姓名1','2021-03-08 15:56:41',1),(72,'2021-03-08 15:56:41','房源名称2','房源类型2','房子户型2','房源区域2','http://localhost:8080/ssms5akf/upload/zufangxinxi_fangyuantupian2.jpg','待租','具体位置2','面积2','租金2','经纪人账号2','经纪人姓名2','2021-03-08 15:56:41',2),(73,'2021-03-08 15:56:41','房源名称3','房源类型3','房子户型3','房源区域3','http://localhost:8080/ssms5akf/upload/zufangxinxi_fangyuantupian3.jpg','待租','具体位置3','面积3','租金3','经纪人账号3','经纪人姓名3','2021-03-08 15:56:41',3),(74,'2021-03-08 15:56:41','房源名称4','房源类型4','房子户型4','房源区域4','http://localhost:8080/ssms5akf/upload/zufangxinxi_fangyuantupian4.jpg','待租','具体位置4','面积4','租金4','经纪人账号4','经纪人姓名4','2021-03-08 15:56:41',4),(75,'2021-03-08 15:56:41','房源名称5','房源类型5','房子户型5','房源区域5','http://localhost:8080/ssms5akf/upload/zufangxinxi_fangyuantupian5.jpg','待租','具体位置5','面积5','租金5','经纪人账号5','经纪人姓名5','2021-03-08 15:56:41',5),(76,'2021-03-08 15:56:41','房源名称6','房源类型6','房子户型6','房源区域6','http://localhost:8080/ssms5akf/upload/zufangxinxi_fangyuantupian6.jpg','待租','具体位置6','面积6','租金6','经纪人账号6','经纪人姓名6','2021-03-08 15:56:41',6),(1615191043562,'2021-03-08 16:10:43','讲义','单身公寓','房子户型1','深圳','http://localhost:8080/ssms5akf/upload/1615191024985.jpg','待租','范德萨范德萨','120','3000','123','胡继','2021-03-08 16:17:47',1615190622179);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;