master

分支 (1)

管理

管理

master

open-source-real-estate-applet
/
house.sql

# Host: localhost  (Version: 5.7.26)
# Date: 2022-07-21 16:00:51
# Generator: MySQL-Front 5.3  (Build 4.234)

/*!40101 SET NAMES utf8 */;

#
# Structure for table "yq_admins"
#

DROP TABLE IF EXISTS `yq_admins`;
CREATE TABLE `yq_admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL COMMENT '用户密码',
  `login_time` int(11) NOT NULL DEFAULT '0' COMMENT '登录时间',
  `login_ip` varchar(255) DEFAULT NULL COMMENT '登录ip',
  `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

#
# Data for table "yq_admins"
#

INSERT INTO `yq_admins` VALUES (1,'admin','e10adc3949ba59abbe56e057f20f883e',0,NULL,0,0);

#
# Structure for table "yq_articles"
#

DROP TABLE IF EXISTS `yq_articles`;
CREATE TABLE `yq_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL COMMENT '文章名称',
  `content` text COMMENT '文章内容',
  `hidden` int(11) NOT NULL DEFAULT '0' COMMENT '0显示1隐藏',
  `read` int(11) NOT NULL DEFAULT '0' COMMENT '阅读',
  `create_time` int(11) NOT NULL DEFAULT '0',
  `update_time` int(11) NOT NULL DEFAULT '0',
  `img` int(11) NOT NULL DEFAULT '0' COMMENT '图片id',
  `bind_house` int(11) NOT NULL DEFAULT '0' COMMENT '绑定房屋',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章表';

#
# Data for table "yq_articles"
#


#
# Structure for table "yq_banners"
#

DROP TABLE IF EXISTS `yq_banners`;
CREATE TABLE `yq_banners` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '广告名称',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `img_id` int(11) NOT NULL DEFAULT '0' COMMENT '图片id',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '0不跳转1跳转到文章2跳转到房屋',
  `value` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '跳转参数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='广告表';

#
# Data for table "yq_banners"
#


#
# Structure for table "yq_collections"
#

DROP TABLE IF EXISTS `yq_collections`;
CREATE TABLE `yq_collections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `hid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';

#
# Data for table "yq_collections"
#


#
# Structure for table "yq_fx_logs"
#

DROP TABLE IF EXISTS `yq_fx_logs`;
CREATE TABLE `yq_fx_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '邀请用户',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '0新用户2号码绑定3预约看房成功',
  `agent` int(11) NOT NULL DEFAULT '0' COMMENT '邀请人',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  `price` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='分销记录表';

#
# Data for table "yq_fx_logs"
#

/*!40000 ALTER TABLE `yq_fx_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `yq_fx_logs` ENABLE KEYS */;

#
# Structure for table "yq_house_types"
#

DROP TABLE IF EXISTS `yq_house_types`;
CREATE TABLE `yq_house_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='房屋类型表';

#
# Data for table "yq_house_types"
#


#
# Structure for table "yq_houses"
#

DROP TABLE IF EXISTS `yq_houses`;
CREATE TABLE `yq_houses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '房屋名称',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '房屋类型',
  `area` float NOT NULL DEFAULT '0' COMMENT '建筑面积',
  `price` float NOT NULL DEFAULT '0' COMMENT '价格',
  `project` int(11) NOT NULL DEFAULT '0' COMMENT '所属楼栋',
  `fenbu` varchar(255) DEFAULT NULL COMMENT '户型分布',
  `explain` varchar(255) DEFAULT NULL COMMENT '户型解析',
  `img` text COMMENT '户型图片',
  `banner` text COMMENT '项目广告图',
  `wy_type` varchar(11) DEFAULT '0' COMMENT '物业类别',
  `characteristic` varchar(255) DEFAULT NULL COMMENT '项目特色',
  `jz_type` varchar(11) DEFAULT '0' COMMENT '建筑类别',
  `zx_state` varchar(255) DEFAULT NULL COMMENT '装修状态',
  `years` int(11) NOT NULL DEFAULT '0' COMMENT '产权年限',
  `developers` varchar(255) DEFAULT NULL COMMENT '开发商',
  `address` varchar(255) DEFAULT NULL COMMENT '项目地址',
  `sale_address` varchar(255) DEFAULT NULL COMMENT '售楼地址',
  `phone` varchar(255) DEFAULT NULL COMMENT '咨询电话',
  `state` int(11) NOT NULL DEFAULT '0' COMMENT '0待发布1在售2已售出',
  `infor` text COMMENT '详细信息',
  `position` text COMMENT '项目位置',
  `around` text COMMENT '周边环境',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='房屋表';

#
# Data for table "yq_houses"
#


#
# Structure for table "yq_image_categories"
#

DROP TABLE IF EXISTS `yq_image_categories`;
CREATE TABLE `yq_image_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '分类名称',
  `dir_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='图片分类表';

#
# Data for table "yq_image_categories"
#


#
# Structure for table "yq_images"
#

DROP TABLE IF EXISTS `yq_images`;
CREATE TABLE `yq_images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '图片地址',
  `category` int(11) NOT NULL DEFAULT '0' COMMENT '图片分类',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='图片表';

#
# Data for table "yq_images"
#


#
# Structure for table "yq_invite_records"
#

DROP TABLE IF EXISTS `yq_invite_records`;
CREATE TABLE `yq_invite_records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '邀请人',
  `agent_id` int(11) NOT NULL DEFAULT '0',
  `money` float NOT NULL DEFAULT '0' COMMENT '邀请佣金',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邀请记录表';

#
# Data for table "yq_invite_records"
#


#
# Structure for table "yq_projects"
#

DROP TABLE IF EXISTS `yq_projects`;
CREATE TABLE `yq_projects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '项目类型',
  `img` int(11) NOT NULL DEFAULT '0' COMMENT '图片',
  `create_time` int(11) NOT NULL DEFAULT '0',
  `update_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='楼栋表';

#
# Data for table "yq_projects"
#


#
# Structure for table "yq_sys"
#

DROP TABLE IF EXISTS `yq_sys`;
CREATE TABLE `yq_sys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '0基本信息1后台配置2微信配置3阿里云',
  `switch` int(11) NOT NULL DEFAULT '0' COMMENT '0文本1开关2下拉3多选4图片5文本域',
  `content` varchar(255) DEFAULT NULL COMMENT '说明',
  `other` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='配置表';

#
# Data for table "yq_sys"
#

INSERT INTO `yq_sys` VALUES (1,'wx_appid','',2,0,'微信appid',NULL),(2,'wx_secret','',2,0,'微信秘钥',NULL),(3,'invite_money','2',0,0,'邀请佣金',NULL),(4,'bind_mobile_money','2',0,0,'绑定号码佣金',NULL),(5,'yuyue_money','2',0,0,'预约看房佣金',NULL),(6,'mobile','',0,0,'联系电话',NULL),(7,'map_key','',0,0,'地图key',NULL),(8,'api_url','',0,0,'入口',NULL);

#
# Structure for table "yq_tx_recourds"
#

DROP TABLE IF EXISTS `yq_tx_recourds`;
CREATE TABLE `yq_tx_recourds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
  `price` float NOT NULL DEFAULT '0' COMMENT '提现金额',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='体现记录';

#
# Data for table "yq_tx_recourds"
#

/*!40000 ALTER TABLE `yq_tx_recourds` DISABLE KEYS */;
/*!40000 ALTER TABLE `yq_tx_recourds` ENABLE KEYS */;

#
# Structure for table "yq_users"
#

DROP TABLE IF EXISTS `yq_users`;
CREATE TABLE `yq_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `openid` varchar(255) DEFAULT NULL,
  `headpic` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `nickname` varchar(255) DEFAULT NULL COMMENT '用户昵称',
  `session_key` varchar(255) DEFAULT NULL,
  `login_time` int(11) NOT NULL DEFAULT '0' COMMENT '登录时间',
  `login_ip` varchar(255) DEFAULT NULL COMMENT '登录ip',
  `mobile` varchar(20) DEFAULT NULL COMMENT '电话号码',
  `money` float NOT NULL DEFAULT '0' COMMENT '账户余额',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  `invite_id` int(11) NOT NULL DEFAULT '0' COMMENT '邀请人id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

#
# Data for table "yq_users"
#


#
# Structure for table "yq_yuyues"
#

DROP TABLE IF EXISTS `yq_yuyues`;
CREATE TABLE `yq_yuyues` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '绑定用户',
  `name` varchar(255) DEFAULT NULL COMMENT '姓名',
  `mobile` varchar(255) DEFAULT NULL COMMENT '电话',
  `time` int(11) NOT NULL DEFAULT '0' COMMENT '预约时间',
  `state` int(11) NOT NULL DEFAULT '0' COMMENT '0待处理1已处理2一取消',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预约表';

#
# Data for table "yq_yuyues"
#