功能介绍
管理员:首页、个人中心、房子户型管理、门店信息管理、用户管理、经纪人管理、房源信息管理、售房订单管理、 租房信息管理、租房订单管理、求购信息管理、求租信息管理、系统管理,
用户;首页、房源信息、租房信息、我的等
数据库脚本
/*
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'