/*
Navicat MySQL Data Transfer
Source Server : xing
Source Server Type : MySQL
Source Server Version : 80031
Source Host : localhost:3306
Source Schema : db_house
Target Server Type : MySQL
Target Server Version : 80031
File Encoding : 65001
Date: 17/12/2022 23:07:09
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for houselist
-- ----------------------------
DROP TABLE IF EXISTS `houselist`;
CREATE TABLE `houselist` (
`houseid` int(0) NOT NULL AUTO_INCREMENT,
`address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`price` double(10, 2) NULL DEFAULT NULL,
`status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`detail` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`userlist_id` int(0) NULL DEFAULT NULL,
`userlist_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`houseid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of houselist
-- ----------------------------
INSERT INTO `houselist` VALUES (23, '山东省济南市历城区凤河南路765号天福名家6栋2单元0703房', 1800.00, '未出租', '无', NULL, NULL);
INSERT INTO `houselist` VALUES (26, '江西省上饶市横峰县德江乡济林村九安组2号', 900.00, '已出租', '家电齐全,拎包入住。', 33, 'xing');
INSERT INTO `houselist` VALUES (28, '新疆维吾尔自治区伊犁自治州巩留县锦洋镇乐翔村清新组25号', 1300.00, '已出租', '精装修', 33, 'xing');
INSERT INTO `houselist` VALUES (29, '广东省云浮市云安区苑民北路282号左岸公馆4栋4单元1702房', 500.00, '未出租', '拎包入住', NULL, NULL);
-- ----------------------------
-- Table structure for paid
-- ----------------------------
DROP TABLE IF EXISTS `paid`;
CREATE TABLE `paid` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`price` double(10, 2) NULL DEFAULT NULL,
`date` date NULL DEFAULT NULL,
`paydate` date NULL DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`userlist_id` int(0) NULL DEFAULT NULL,
`status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`houseid` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of paid
-- ----------------------------
INSERT INTO `paid` VALUES (33, '新疆维吾尔自治区伊犁自治州巩留县锦洋镇乐翔村清新组25号', 1300.00, '2022-12-20', NULL, 'xing', 33, '未缴', 28);
INSERT INTO `paid` VALUES (34, '江西省上饶市横峰县德江乡济林村九安组2号', 900.00, '2022-12-17', '2022-12-17', 'xing', 33, '已缴', 26);
-- ----------------------------
-- Table structure for schedule
-- ----------------------------
DROP TABLE IF EXISTS `schedule`;
CREATE TABLE `schedule` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`date` date NULL DEFAULT NULL,
`content` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`time` int(0) NULL DEFAULT NULL COMMENT '公告持续天数',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of schedule
-- ----------------------------
INSERT INTO `schedule` VALUES (6, '2022-12-07', '注意及时缴纳本月房租', 7);
INSERT INTO `schedule` VALUES (8, '2022-11-28', '电梯停止使用一周,敬请见谅。', 7);
INSERT INTO `schedule` VALUES (9, '2022-11-30', '本月还未缴纳月租的租客请注意及时缴纳月租。', 7);
-- ----------------------------
-- Table structure for solve
-- ----------------------------
DROP TABLE IF EXISTS `solve`;
CREATE TABLE `solve` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`date` date NULL DEFAULT NULL,
`detail` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`userlist_id` int(0) NULL DEFAULT NULL,
`status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`houseid` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of solve
-- ----------------------------
INSERT INTO `solve` VALUES (12, '新疆维吾尔自治区伊犁自治州巩留县锦洋镇乐翔村清新组25号', '2022-12-17', '水管堵住', 'xing', 33, '未处理', 28);
INSERT INTO `solve` VALUES (13, '新疆维吾尔自治区伊犁自治州巩留县锦洋镇乐翔村清新组25号', '2022-12-17', '冰箱损坏', 'xing', 33, '未处理', 28);
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`username` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`type` int(0) NULL DEFAULT NULL COMMENT '1为管理员,2为普通用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'admin', 'admin', 1);
INSERT INTO `user` VALUES (23, '0158915894155', '0158915894155', 2);
-- ----------------------------
-- Table structure for userlist
-- ----------------------------
DROP TABLE IF EXISTS `userlist`;
CREATE TABLE `userlist` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`idcard` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
`userid` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of userlist
-- ----------------------------
INSERT INTO `userlist` VALUES (27, '王二麻子', '440582199712267459', '13199772826', 1);
INSERT INTO `userlist` VALUES (33, 'xing', '61052419976454', '0158915894155', 23);
SET FOREIGN_KEY_CHECKS = 1;