/*
|
Navicat Premium Data Transfer
|
|
Source Server : 127.0.0.1
|
Source Server Type : MySQL
|
Source Server Version : 50637
|
Source Host : localhost:3306
|
Source Schema : rental_house_applet
|
|
Target Server Type : MySQL
|
Target Server Version : 50637
|
File Encoding : 65001
|
|
Date: 28/11/2023 09:11:46
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for sys_dept
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_dept`;
|
CREATE TABLE `sys_dept` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
`num` int(11) NULL DEFAULT NULL COMMENT '排序',
|
`pid` int(11) NULL DEFAULT NULL COMMENT '父部门id',
|
`pids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级ids',
|
`simplename` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
|
`fullname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全称',
|
`tips` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提示',
|
`version` int(11) NULL DEFAULT NULL COMMENT '版本（乐观锁保留字段）',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表' ROW_FORMAT = COMPACT;
|
|
-- ----------------------------
|
-- Records of sys_dept
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for sys_dict
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_dict`;
|
CREATE TABLE `sys_dict` (
|
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
`num` int(11) NULL DEFAULT NULL COMMENT '排序',
|
`pid` int(11) NULL DEFAULT NULL COMMENT '父级字典',
|
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
|
`tips` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提示',
|
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '值',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of sys_dict
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for sys_expense
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_expense`;
|
CREATE TABLE `sys_expense` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`money` decimal(20, 2) NULL DEFAULT NULL COMMENT '报销金额',
|
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '描述',
|
`createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
|
`state` int(11) NULL DEFAULT NULL COMMENT '状态: 1.待提交 2:待审核 3.审核通过 4:驳回',
|
`userid` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
`processId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '报销表' ROW_FORMAT = COMPACT;
|
|
-- ----------------------------
|
-- Records of sys_expense
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for sys_login_log
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_login_log`;
|
CREATE TABLE `sys_login_log` (
|
`id` int(65) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`logname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志名称',
|
`userid` int(65) NULL DEFAULT NULL COMMENT '管理员id',
|
`createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
|
`succeed` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否执行成功',
|
`message` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '具体消息',
|
`ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录ip',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '登录记录' ROW_FORMAT = COMPACT;
|
|
-- ----------------------------
|
-- Records of sys_login_log
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for sys_menu
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_menu`;
|
CREATE TABLE `sys_menu` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单编号',
|
`pcode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单父编号',
|
`pcodes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前菜单的所有父菜单编号',
|
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
|
`icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
|
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'url地址',
|
`num` int(65) NULL DEFAULT NULL COMMENT '菜单排序号',
|
`levels` int(65) NULL DEFAULT NULL COMMENT '菜单层级',
|
`ismenu` int(11) NULL DEFAULT NULL COMMENT '是否是菜单（1：是 0：不是）',
|
`tips` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
|
`status` int(65) NULL DEFAULT NULL COMMENT '菜单状态 : 1:启用 0:不启用',
|
`isopen` int(11) NULL DEFAULT NULL COMMENT '是否打开: 1:打开 0:不打开',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = COMPACT;
|
|
-- ----------------------------
|
-- Records of sys_menu
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for sys_notice
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_notice`;
|
CREATE TABLE `sys_notice` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
|
`type` int(11) NULL DEFAULT NULL COMMENT '类型',
|
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
|
`createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
|
`creater` int(11) NULL DEFAULT NULL COMMENT '创建人',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知表' ROW_FORMAT = COMPACT;
|
|
-- ----------------------------
|
-- Records of sys_notice
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for sys_operation_log
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_operation_log`;
|
CREATE TABLE `sys_operation_log` (
|
`id` int(65) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`logtype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志类型',
|
`logname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志名称',
|
`userid` int(65) NULL DEFAULT NULL COMMENT '用户id',
|
`classname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类名称',
|
`method` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '方法名称',
|
`createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
|
`succeed` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否成功',
|
`message` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志' ROW_FORMAT = COMPACT;
|
|
-- ----------------------------
|
-- Records of sys_operation_log
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for sys_relation
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_relation`;
|
CREATE TABLE `sys_relation` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`menuid` bigint(11) NULL DEFAULT NULL COMMENT '菜单id',
|
`roleid` int(11) NULL DEFAULT NULL COMMENT '角色id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = COMPACT;
|
|
-- ----------------------------
|
-- Records of sys_relation
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for sys_role
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_role`;
|
CREATE TABLE `sys_role` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
`num` int(11) NULL DEFAULT NULL COMMENT '序号',
|
`pid` int(11) NULL DEFAULT NULL COMMENT '父角色id',
|
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
|
`deptid` int(11) NULL DEFAULT NULL COMMENT '部门名称',
|
`tips` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提示',
|
`version` int(11) NULL DEFAULT NULL COMMENT '保留字段(暂时没用）',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = COMPACT;
|
|
-- ----------------------------
|
-- Records of sys_role
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for sys_user
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_user`;
|
CREATE TABLE `sys_user` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
`avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
|
`account` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
|
`password` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
|
`salt` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'md5密码盐',
|
`name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名字',
|
`birthday` datetime(0) NULL DEFAULT NULL COMMENT '生日',
|
`sex` int(11) NULL DEFAULT NULL COMMENT '性别（1：男 2：女）',
|
`email` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮件',
|
`phone` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
|
`roleid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色id',
|
`deptid` int(11) NULL DEFAULT NULL COMMENT '部门id',
|
`status` int(11) NULL DEFAULT NULL COMMENT '状态(1：启用 2：冻结 3：删除）',
|
`createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
|
`version` int(11) NULL DEFAULT NULL COMMENT '保留字段',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表' ROW_FORMAT = COMPACT;
|
|
-- ----------------------------
|
-- Records of sys_user
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user`;
|
CREATE TABLE `t_app_user` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '编号',
|
`profile_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '昵称',
|
`user_type` int(1) NULL DEFAULT NULL COMMENT '用户类型（1=普通，2=房东，3=中介）',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`wechat_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信小程序openid',
|
`wechat_qr_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信二维码',
|
`watch_app` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'WatchApp',
|
`agent_licence_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '代理人牌照号',
|
`company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司名称',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`business_card_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名片照',
|
`audit_status` int(1) NULL DEFAULT NULL COMMENT '审核状态（1=待审核，2=审核通过，3=审核拒绝）',
|
`audit_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核注释',
|
`status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
|
`insert_time` datetime(0) NULL DEFAULT NULL COMMENT '注册时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户信息' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_app_user
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_audit_record
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_audit_record`;
|
CREATE TABLE `t_app_user_audit_record` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`app_user_id` int(11) NULL DEFAULT NULL COMMENT '中介id',
|
`audit_status` int(1) NULL DEFAULT NULL COMMENT '审核状态（1=待审核，2=审核通过，3=审核拒绝）',
|
`audit_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核注释',
|
`audit_user_id` int(11) NULL DEFAULT NULL COMMENT '审核人员id',
|
`insert_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '中介审核记录' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_app_user_audit_record
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_banner
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_banner`;
|
CREATE TABLE `t_banner` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`position` int(1) NULL DEFAULT NULL COMMENT '位置（1=首页，2=详情）',
|
`img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '图片地址',
|
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '富文本内容',
|
`sort` int(5) NULL DEFAULT NULL COMMENT '排序',
|
`insert_user_id` int(11) NULL DEFAULT NULL COMMENT '添加人id',
|
`insert_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统banner' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_banner
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_collection_house_resource
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_collection_house_resource`;
|
CREATE TABLE `t_collection_house_resource` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`app_user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
`house_resource_id` int(11) NULL DEFAULT NULL COMMENT '房源id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收藏房源记录' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_collection_house_resource
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_collection_housing_demand
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_collection_housing_demand`;
|
CREATE TABLE `t_collection_housing_demand` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`app_user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
`housing_demand_id` int(11) NULL DEFAULT NULL COMMENT '房源id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收藏求房源记录' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_collection_housing_demand
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_encyclopedic_knowledge
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_encyclopedic_knowledge`;
|
CREATE TABLE `t_encyclopedic_knowledge` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`sys_data_type_id` int(11) NULL DEFAULT NULL COMMENT '数据类型id',
|
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '标题',
|
`img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '列表图片路径',
|
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '富文本内容',
|
`content_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '纯文本内容',
|
`views_number` int(11) NULL DEFAULT NULL COMMENT '浏览数',
|
`insert_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '知识百科' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_encyclopedic_knowledge
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_encyclopedic_knowledge_upvote
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_encyclopedic_knowledge_upvote`;
|
CREATE TABLE `t_encyclopedic_knowledge_upvote` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`encyclopedic_knowledge_id` int(11) NULL DEFAULT NULL COMMENT '知识百科id',
|
`app_user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '知识百科点赞记录' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_encyclopedic_knowledge_upvote
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_feedback
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_feedback`;
|
CREATE TABLE `t_feedback` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`app_user_id` int(11) NULL DEFAULT NULL COMMENT '反馈用户id',
|
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '反馈内容',
|
`insert_time` datetime(0) NULL DEFAULT NULL COMMENT '反馈时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '意见反馈' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_feedback
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_house_resource
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_house_resource`;
|
CREATE TABLE `t_house_resource` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '编号',
|
`data_type` int(1) NULL DEFAULT NULL COMMENT '房源类型（1=出租，2=卖房）',
|
`house_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '房源户型',
|
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '标题',
|
`cell_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '小区名字',
|
`floor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '楼层',
|
`sale_date` datetime(0) NULL DEFAULT NULL COMMENT '售卖日期',
|
`sale_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '售卖金额',
|
`rental_duration` int(1) NULL DEFAULT NULL COMMENT '租期时长（1=一年以下，2=一年以上）',
|
`building_orientation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '房屋朝向',
|
`house_type_id` int(11) NULL DEFAULT NULL COMMENT '房屋类型id',
|
`firm_house` int(1) NULL DEFAULT NULL COMMENT '公司盘（0=否，1=是）',
|
`house_photo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '房源照片',
|
`house_video` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '房源视频',
|
`elevator` int(1) NULL DEFAULT NULL COMMENT '是否有电梯（0=否，1=是）',
|
`drying_area` int(1) NULL DEFAULT NULL COMMENT '是否有晾晒区（0=否，1=是）',
|
`garden` int(1) NULL DEFAULT NULL COMMENT '是否有花园（0=否，1=是）',
|
`carport` int(1) NULL DEFAULT NULL COMMENT '是否有车位（0=否，1=是）',
|
`balcony` int(1) NULL DEFAULT NULL COMMENT '是否有平台（0=否，1=是）',
|
`keep_pet` int(1) NULL DEFAULT NULL COMMENT '是否可养宠物（0=否，1=是）',
|
`house_area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '房屋面积',
|
`city_id` int(11) NULL DEFAULT NULL COMMENT '市id',
|
`district_id` int(11) NULL DEFAULT NULL COMMENT '区id',
|
`house_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '房屋地址',
|
`longitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`latitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`more_introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '更多介绍',
|
`good_house` int(1) NULL DEFAULT NULL COMMENT '必看好房（0=否，1=是）',
|
`wechat_qr_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信二维码',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '电话号码',
|
`watch_app` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'WatchApp',
|
`app_user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
`views_number` int(11) NULL DEFAULT NULL COMMENT '浏览次数',
|
`status` int(1) NULL DEFAULT NULL COMMENT '状态（0=下架，1=上架）',
|
`is_delete` int(1) NULL DEFAULT NULL COMMENT '删除标识（0=否，1=是）',
|
`insert_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`insert_user_id` int(11) NULL DEFAULT NULL COMMENT '添加人id',
|
`auth_user_id` int(11) NULL DEFAULT NULL COMMENT '审核人id',
|
`auth_status` int(1) NULL DEFAULT NULL COMMENT '审核状态（1=待审核，2=已通过，3=已拒绝）',
|
`auth_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
|
`update_user_id` int(11) NULL DEFAULT NULL COMMENT '修改人id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '房源' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_house_resource
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_house_type
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_house_type`;
|
CREATE TABLE `t_house_type` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '类型名称',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '房屋类型' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_house_type
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_housing_demand
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_housing_demand`;
|
CREATE TABLE `t_housing_demand` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '编号',
|
`app_user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
`data_type` int(1) NULL DEFAULT NULL COMMENT '房源类型（1=出租，2=卖房）',
|
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '标题',
|
`district` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '房源区域',
|
`sale_amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '价格区间',
|
`house_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '房源户型',
|
`house_area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '面积区间',
|
`rental_duration` int(11) NULL DEFAULT NULL COMMENT '租期（月）',
|
`sale_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '起租时间',
|
`house_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '房屋类型id',
|
`floor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '所在楼层',
|
`elevator` int(1) NULL DEFAULT NULL COMMENT '是否有电梯（0=否，1=是）',
|
`drying_area` int(1) NULL DEFAULT NULL COMMENT '是否有晾晒区（0=否，1=是）',
|
`garden` int(1) NULL DEFAULT NULL COMMENT '是否有花园（0=否，1=是）',
|
`carport` int(1) NULL DEFAULT NULL COMMENT '是否有车位（0=否，1=是）',
|
`balcony` int(1) NULL DEFAULT NULL COMMENT '是否有平台（0=否，1=是）',
|
`keep_pet` int(1) NULL DEFAULT NULL COMMENT '是否可养宠物（0=否，1=是）',
|
`more_introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '更多介绍',
|
`views_number` int(11) NULL DEFAULT NULL COMMENT '浏览次数',
|
`status` int(1) NULL DEFAULT NULL COMMENT '状态（0=下架，1=上架）',
|
`is_delete` int(1) NULL DEFAULT NULL COMMENT '删除标识（0=否，1=是）',
|
`insert_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`insert_user_id` int(11) NULL DEFAULT NULL COMMENT '添加人id',
|
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
|
`update_user_id` int(11) NULL DEFAULT NULL COMMENT '修改人id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户房源需求' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_housing_demand
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_housing_demand_district
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_housing_demand_district`;
|
CREATE TABLE `t_housing_demand_district` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`housing_demand_id` int(11) NULL DEFAULT NULL COMMENT '房源id',
|
`city_id` int(11) NULL DEFAULT NULL COMMENT '城市id',
|
`district_id` int(11) NULL DEFAULT NULL COMMENT '区域id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '求房源区域数据' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_housing_demand_district
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_region
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_region`;
|
CREATE TABLE `t_region` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市名称',
|
`code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
`parent_id` int(11) NULL DEFAULT NULL COMMENT '父级ID',
|
`longitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经度',
|
`latitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纬度',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '省市区三级联动' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_region
|
-- ----------------------------
|
INSERT INTO `t_region` VALUES (1, '香港岛', NULL, 0, NULL, NULL);
|
INSERT INTO `t_region` VALUES (2, '九龙', NULL, 0, NULL, NULL);
|
INSERT INTO `t_region` VALUES (3, '新界', NULL, 0, NULL, NULL);
|
INSERT INTO `t_region` VALUES (4, '中西区', '810001', 1, '114.154373', '22.281981');
|
INSERT INTO `t_region` VALUES (5, '湾仔', '810002', 1, '114.182915', '22.276389');
|
INSERT INTO `t_region` VALUES (6, '东区', '810003', 1, '114.226003', '22.279693');
|
INSERT INTO `t_region` VALUES (7, '南区', '810004', 1, '114.160011', '22.245897');
|
INSERT INTO `t_region` VALUES (8, '九龙城', '810007', 2, '114.192846', '22.312510');
|
INSERT INTO `t_region` VALUES (9, '观塘', '810009', 2, '114.214054', '22.320838');
|
INSERT INTO `t_region` VALUES (10, '深水埗', '810006', 2, '114.163670', '22.333217');
|
INSERT INTO `t_region` VALUES (11, '黄大仙', '810008', 2, '114.203097', '22.335912');
|
INSERT INTO `t_region` VALUES (12, '油尖旺', '810005', 2, '114.172646', '22.312263');
|
INSERT INTO `t_region` VALUES (13, '离岛', '810018', 3, '113.946708', '22.285933');
|
INSERT INTO `t_region` VALUES (14, '北区', '810013', 3, '114.147962', '22.495549');
|
INSERT INTO `t_region` VALUES (15, '西贡', '810015', 3, '114.265087', '22.314900');
|
INSERT INTO `t_region` VALUES (16, '沙田', '810016', 3, '114.196108', '22.380076');
|
INSERT INTO `t_region` VALUES (17, '大浦', '810014', 3, '114.171398', '22.446215');
|
INSERT INTO `t_region` VALUES (18, '荃湾', '810010', 3, '114.121688', '22.369053');
|
INSERT INTO `t_region` VALUES (19, '葵青', '810017', 3, '114.140014', '22.363560');
|
INSERT INTO `t_region` VALUES (20, '屯门', '810011', 3, '113.976949', '22.394625');
|
INSERT INTO `t_region` VALUES (21, '元朗', '810012', 3, '114.033433', '22.442005');
|
|
-- ----------------------------
|
-- Table structure for t_report_house_resource
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_report_house_resource`;
|
CREATE TABLE `t_report_house_resource` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`app_user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
`house_resource_id` int(11) NULL DEFAULT NULL COMMENT '房源id',
|
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '举报内容',
|
`insert_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '举报房源' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_report_house_resource
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_report_housing_demand
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_report_housing_demand`;
|
CREATE TABLE `t_report_housing_demand` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`app_user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
`housing_demand_id` int(11) NULL DEFAULT NULL COMMENT '房源id',
|
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '举报内容',
|
`insert_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '举报房源' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_report_housing_demand
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_rich_text
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_rich_text`;
|
CREATE TABLE `t_rich_text` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`type` int(1) NULL DEFAULT NULL COMMENT '类型（1=推广中心，2=隐私政策，3=用户协议，4=注销账号）',
|
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '富文本内容',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '富文本内容' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_rich_text
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_search_history_condition
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_search_history_condition`;
|
CREATE TABLE `t_search_history_condition` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`app_user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
`district` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '区域code',
|
`price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '价格区间',
|
`house_models` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '户型',
|
`elevator` int(1) NULL DEFAULT NULL COMMENT '是否有电梯（0=否，1=是）',
|
`house_type_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '房屋类型id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户搜索房源历史条件记录' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_search_history_condition
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_sys_data_type
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_sys_data_type`;
|
CREATE TABLE `t_sys_data_type` (
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`type` int(1) NULL DEFAULT NULL COMMENT '类型（1=知识百科）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '类别名称',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统数据类型' ROW_FORMAT = Compact;
|
|
-- ----------------------------
|
-- Records of t_sys_data_type
|
-- ----------------------------
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
