/*
 Navicat Premium Data Transfer

 Source Server         : erji
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : 01_houseagency

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 27/10/2022 18:01:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for favor
-- ----------------------------
DROP TABLE IF EXISTS `favor`;
CREATE TABLE `favor`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '朝向id',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '朝向名称',
  `remake` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of favor
-- ----------------------------
INSERT INTO `favor` VALUES ('fav1001', '东', NULL);
INSERT INTO `favor` VALUES ('fav1002', '西', NULL);
INSERT INTO `favor` VALUES ('fav1004', '北', NULL);
INSERT INTO `favor` VALUES ('fav1003', '南', NULL);

-- ----------------------------
-- Table structure for fitment
-- ----------------------------
DROP TABLE IF EXISTS `fitment`;
CREATE TABLE `fitment`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '装修id',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '装修名称',
  `remake` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fitment
-- ----------------------------
INSERT INTO `fitment` VALUES ('fit1001', '很好', '有电脑');
INSERT INTO `fitment` VALUES ('fit1002', '一般', '');
INSERT INTO `fitment` VALUES ('fit1004', '不好', '');
INSERT INTO `fitment` VALUES ('fit1003', '豪华', '');

-- ----------------------------
-- Table structure for floor
-- ----------------------------
DROP TABLE IF EXISTS `floor`;
CREATE TABLE `floor`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '楼层id',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '楼层名称',
  `remake` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of floor
-- ----------------------------
INSERT INTO `floor` VALUES ('flo1001', '一层', NULL);
INSERT INTO `floor` VALUES ('flo1002', '二层', NULL);
INSERT INTO `floor` VALUES ('flo1003', '三层', NULL);
INSERT INTO `floor` VALUES ('flo1004', '四层', NULL);
INSERT INTO `floor` VALUES ('flo1005', '五层', NULL);
INSERT INTO `floor` VALUES ('flo1006', '六层', '');

-- ----------------------------
-- Table structure for house
-- ----------------------------
DROP TABLE IF EXISTS `house`;
CREATE TABLE `house`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房屋id',
  `companyName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物业名称',
  `typeID` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房型id',
  `seatID` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '幢/座id',
  `state` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
  `favorID` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '朝向id',
  `fitmentID` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '装修id',
  `mothedID` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用途id',
  `floorID` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '楼层id',
  `map` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '结构图',
  `price` decimal(18, 0) NULL DEFAULT NULL COMMENT '单价',
  `buildYear` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房屋年限',
  `area` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房屋面积',
  `remark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `userID` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of house
-- ----------------------------
INSERT INTO `house` VALUES ('hou1001', '绘制科技园', 'typ1004', 'sea1002', 'none', 'fav1002', 'fit1002', 'mot1002', 'flo1002', '', 10000, '10', '100', '一般般', 'lend1002');
INSERT INTO `house` VALUES ('hou1002', '新港科技园', 'typ1004', 'sea1002', 'none', 'fav1002', 'fit1003', 'mot1002', 'flo1003', '', 50000, '10', '200', '豪华房间', 'lend1003');
INSERT INTO `house` VALUES ('hou1003', '龙港科技园', 'typ1004', 'sea1002', 'none', 'fav1002', 'fit1004', 'mot1002', 'flo1002', '', 2000, '10', '1000', '不太行', 'lend1004');

-- ----------------------------
-- Table structure for login
-- ----------------------------
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login`  (
  `login_id` int(11) NOT NULL COMMENT '主键id',
  `employee_ID` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '员工id',
  `login_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `login_pwd` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `login_power` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登陆权限',
  PRIMARY KEY (`login_id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of login
-- ----------------------------
INSERT INTO `login` VALUES (1, '1001', 'admin', 'admin', '1');
INSERT INTO `login` VALUES (2, '1002', 'user', '123', '0');

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu`  (
  `id` int(11) NOT NULL DEFAULT 0 COMMENT '菜单id',
  `pid` int(11) NOT NULL DEFAULT 0 COMMENT '菜单的父级id',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单名',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路径',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES (1, 0, '用户信息管理', NULL);
INSERT INTO `menu` VALUES (2, 0, '求租管理', NULL);
INSERT INTO `menu` VALUES (3, 0, '员工信息', NULL);
INSERT INTO `menu` VALUES (4, 0, '出租管理', NULL);
INSERT INTO `menu` VALUES (5, 0, '交费管理', NULL);
INSERT INTO `menu` VALUES (6, 0, '业务统计', NULL);
INSERT INTO `menu` VALUES (7, 0, '常用工具', NULL);
INSERT INTO `menu` VALUES (8, 0, '系统管理', NULL);
INSERT INTO `menu` VALUES (9, 0, '帮助', NULL);
INSERT INTO `menu` VALUES (10, 1, '求租人员信息设置', 'PeopleInfo');
INSERT INTO `menu` VALUES (11, 1, '出租人员信息设置', 'PeopleInfo');
INSERT INTO `menu` VALUES (12, 1, '人员信息控制', 'PeopleList');
INSERT INTO `menu` VALUES (13, 2, '房源查询设置', 'Select');
INSERT INTO `menu` VALUES (14, 2, '房源状态浏览', NULL);
INSERT INTO `menu` VALUES (15, 2, '求租意向设置', NULL);
INSERT INTO `menu` VALUES (16, 3, '录入员工信息', NULL);
INSERT INTO `menu` VALUES (17, 3, '所有员工信息', NULL);
INSERT INTO `menu` VALUES (18, 4, '房型信息设置', 'TypeWindow');
INSERT INTO `menu` VALUES (19, 4, '楼层设置', 'FloorWindow');
INSERT INTO `menu` VALUES (20, 4, '幢/座设置', 'SeatWindow');
INSERT INTO `menu` VALUES (21, 4, '装修程度设置', 'FitmentWindow');
INSERT INTO `menu` VALUES (22, 4, '朝向设置', 'FavorWindow');
INSERT INTO `menu` VALUES (23, 4, '用途设置', 'MothedWindow');
INSERT INTO `menu` VALUES (24, 5, '收费设置', NULL);
INSERT INTO `menu` VALUES (25, 5, '收费记录', NULL);
INSERT INTO `menu` VALUES (26, 6, '成交业务量统计', NULL);
INSERT INTO `menu` VALUES (27, 7, '记事本', NULL);
INSERT INTO `menu` VALUES (28, 7, '计算器', NULL);
INSERT INTO `menu` VALUES (29, 7, 'WORD', NULL);
INSERT INTO `menu` VALUES (30, 7, 'EXCEL', NULL);
INSERT INTO `menu` VALUES (31, 8, '口令设置', NULL);
INSERT INTO `menu` VALUES (32, 8, '退出系统', NULL);
INSERT INTO `menu` VALUES (33, 8, '清理无效信息', NULL);
INSERT INTO `menu` VALUES (34, 9, '帮助文件', NULL);

-- ----------------------------
-- Table structure for mothed
-- ----------------------------
DROP TABLE IF EXISTS `mothed`;
CREATE TABLE `mothed`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用途id',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用途名称',
  `remake` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of mothed
-- ----------------------------
INSERT INTO `mothed` VALUES ('mot1001', '民用', NULL);
INSERT INTO `mothed` VALUES ('mot1002', '商用', NULL);
INSERT INTO `mothed` VALUES ('mot1003', '自用', NULL);

-- ----------------------------
-- Table structure for seat
-- ----------------------------
DROP TABLE IF EXISTS `seat`;
CREATE TABLE `seat`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '幢/座id',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '幢/座名称',
  `remake` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of seat
-- ----------------------------
INSERT INTO `seat` VALUES ('sea1001', 'A座', NULL);
INSERT INTO `seat` VALUES ('sea1002', 'B座', NULL);
INSERT INTO `seat` VALUES ('sea1003', 'C座', NULL);

-- ----------------------------
-- Table structure for type
-- ----------------------------
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房型id',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房型名称',
  `remake` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of type
-- ----------------------------
INSERT INTO `type` VALUES ('typ1001', '一室一厅', NULL);
INSERT INTO `type` VALUES ('typ1002', '两室一厅', NULL);
INSERT INTO `type` VALUES ('typ1006', '四室二厅', '');
INSERT INTO `type` VALUES ('typ1005', '四室一厅', '');
INSERT INTO `type` VALUES ('typ1004', '三室两厅', '');
INSERT INTO `type` VALUES ('typ1003', '三室一厅', '');
INSERT INTO `type` VALUES ('typ1007', '五室一厅', '');
INSERT INTO `type` VALUES ('typ1008', '五室二厅', '');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `sex` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别',
  `birthday` datetime NULL DEFAULT NULL COMMENT '出生日期',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号码',
  `homePhone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '家庭电话',
  `email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `cardID` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证号码',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
  `houseID` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房屋编号',
  `recordDate` datetime NULL DEFAULT NULL COMMENT '记录时间'
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('lend1003', '王五', '男', '1999-06-03 00:00:00', '18834172334', '0357-4585-063', '1092794806@qq.com', '123456789012345678', 'lend', NULL, '2022-10-22 17:57:36');
INSERT INTO `user` VALUES ('want1001', '李四', '男', '1999-06-03 00:00:00', '18834172334', '0357-4585-063', '1092794806@qq.com', '123456789012345678', 'want', NULL, '2022-10-22 17:55:53');
INSERT INTO `user` VALUES ('lend1001', '张三', '男', '1999-06-03 00:00:00', '18834172334', '0357-4585-063', '1092794806@qq.com', '123456789012345678', 'lend', NULL, '2022-10-22 17:51:11');
INSERT INTO `user` VALUES ('lend1004', '赵六', '男', '1999-06-03 00:00:00', '18834172334', '0357-4585-063', '1092794806@qq.com', '123456789012345678', 'lend', NULL, '2022-10-25 15:55:41');

SET FOREIGN_KEY_CHECKS = 1;