登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
2 Star 0 Fork 0

温文尔雅的小坏蛋/house-sys

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
houses_db.sql 15.63 KB
一键复制 编辑 原始数据 按行查看 历史
Qurumei 提交于 2024-05-17 08:54 . 建筑类型
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285
/*

 Navicat Premium Data Transfer



 Source Server         : localhost

 Source Server Type    : MySQL

 Source Server Version : 80028

 Source Host           : localhost:3306

 Source Schema         : houses_db



 Target Server Type    : MySQL

 Target Server Version : 80028

 File Encoding         : 65001



 Date: 10/05/2024 09:01:58

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for admin

-- ----------------------------

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin`  (

  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',

  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',

  `full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名',

  `telephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系方式',

  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '管理员表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of admin

-- ----------------------------

INSERT INTO `admin` VALUES (1, 'admin', '123456', '管理员1', '13412344321', '2024-04-24 21:12:02', 'admin');



-- ----------------------------

-- Table structure for building

-- ----------------------------

DROP TABLE IF EXISTS `building`;

CREATE TABLE `building`  (

  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '楼盘名称',

  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '楼盘位置',

  `community` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '小区名称',

  `propertyManage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物业公司名称',

  `developersName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '楼盘表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of building

-- ----------------------------

INSERT INTO `building` VALUES (1, '楼盘2', '北京', '凤凰花园', '万科', '开发商1');

INSERT INTO `building` VALUES (3, '楼盘1', '天津', '华润置地', '华润', '开发商2');

INSERT INTO `building` VALUES (4, '楼盘1', '天津', '华润置地', '华润', '开发商2');

INSERT INTO `building` VALUES (5, '111', '123', '123', '123', NULL);



-- ----------------------------

-- Table structure for buyed

-- ----------------------------

DROP TABLE IF EXISTS `buyed`;

CREATE TABLE `buyed`  (

  `id` int(0) NOT NULL AUTO_INCREMENT,

  `user_id` int(0) NULL DEFAULT NULL,

  `home_id` int(0) NULL DEFAULT NULL,

  `buy_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

  `price` double(10, 2) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of buyed

-- ----------------------------

INSERT INTO `buyed` VALUES (4, 1, 1, '2024-05-08 22:23:33', 4353436.00);

INSERT INTO `buyed` VALUES (5, 1, 1, '2024-05-08 22:23:38', 4353436.00);

INSERT INTO `buyed` VALUES (6, 1, 2, '2024-05-10 02:59:01', 345345.98);



-- ----------------------------

-- Table structure for counselor

-- ----------------------------

DROP TABLE IF EXISTS `counselor`;

CREATE TABLE `counselor`  (

  `id` int(0) NOT NULL AUTO_INCREMENT,

  `counselor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

  `age` int(0) NULL DEFAULT NULL,

  `work_years` int(0) NULL DEFAULT NULL,

  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

  `satisfaction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,

  PRIMARY KEY (`id`, `satisfaction`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of counselor

-- ----------------------------

INSERT INTO `counselor` VALUES (1, '随便', 26, 7, '178627348213', '非常满意');



-- ----------------------------

-- Table structure for homebuy

-- ----------------------------

DROP TABLE IF EXISTS `homebuy`;

CREATE TABLE `homebuy`  (

  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',

  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',

  `full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名',

  `telephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系方式',

  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

  `counselor_id` int(0) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '购房者表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of homebuy

-- ----------------------------

INSERT INTO `homebuy` VALUES (1, 'test06', '11111111', '张三丰2', '15612344321', NULL, 'buyer', NULL);

INSERT INTO `homebuy` VALUES (2, 'test10', '123456', '猪八戒', '13712341234', NULL, 'buyer', NULL);

INSERT INTO `homebuy` VALUES (3, 'test03', '123456', '王五', '15612345678', NULL, 'buyer', NULL);



-- ----------------------------

-- Table structure for house_resources

-- ----------------------------

DROP TABLE IF EXISTS `house_resources`;

CREATE TABLE `house_resources`  (

  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '位置',

  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '建筑类型',

  `style` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '装修风格',

  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '价格',

  `img` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图片',

  `seller_id` int(0) NULL DEFAULT NULL COMMENT '卖房者',

  `building_id` int(0) NULL DEFAULT NULL COMMENT '楼盘',

  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '上架时间',

  `status` int(0) NULL DEFAULT NULL COMMENT '状态(0-未定购 1-已订购 2-已付款)',

  `homeType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '户型',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '房源表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of house_resources

-- ----------------------------

INSERT INTO `house_resources` VALUES (1, '北京', '欧式', '欧式', 4353436.00, 'http://xixii.oss-cn-hangzhou.aliyuncs.com/2024-04-25/%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE%202024-04-25%200002453deeef3121dd45a88050e2a19ffcab30.png?Expires=4867594067&OSSAccessKeyId=LTAI5tFE57VfGMrVXkk1RdPq&Signature=QmQZF7%2FYrWpdxUcWdsviPcXNZWg%3D', 2, 1, NULL, 1, '复式');

INSERT INTO `house_resources` VALUES (2, '北京', '公寓', '欧式', 345345.98, 'http://xixii.oss-cn-hangzhou.aliyuncs.com/2024-04-25/%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE%202024-04-25%2000021273669fe462ac46cca314293db9f0e565.png?Expires=4867594054&OSSAccessKeyId=LTAI5tFE57VfGMrVXkk1RdPq&Signature=yp6uVGi9tXFjStQlr7%2FsYMYLMi0%3D', 1, 3, NULL, 1, '两室一厅');

INSERT INTO `house_resources` VALUES (3, '体育场', '独栋别墅', '简易平淡', 1200.00, 'http://xixii.oss-cn-hangzhou.aliyuncs.com/2024-05-08/57607515d6d8441a3974194f558988ff9.png?Expires=4868763733&OSSAccessKeyId=LTAI5tFE57VfGMrVXkk1RdPq&Signature=0X0jX7vCTnkiFDzjsN0m3w3tSuM%3D', 1, 1, NULL, 0, '三室一厅');

INSERT INTO `house_resources` VALUES (4, '体育场', '花园洋房', '豪华中式', 1200.00, 'http://xixii.oss-cn-hangzhou.aliyuncs.com/2024-05-08/57607515d6d8441a3974194f558988ff9.png?Expires=4868763733&OSSAccessKeyId=LTAI5tFE57VfGMrVXkk1RdPq&Signature=0X0jX7vCTnkiFDzjsN0m3w3tSuM%3D', 1, 4, NULL, 0, '其他');

INSERT INTO `house_resources` VALUES (5, '体育场', '花园洋房', '欧式风格', 1200.00, 'http://xixii.oss-cn-hangzhou.aliyuncs.com/2024-05-08/57607515d6d8441a3974194f558988ff9.png?Expires=4868763733&OSSAccessKeyId=LTAI5tFE57VfGMrVXkk1RdPq&Signature=0X0jX7vCTnkiFDzjsN0m3w3tSuM%3D', 1, 4, NULL, 0, '其他');

INSERT INTO `house_resources` VALUES (6, '1', '花园洋房', '豪华中式', 1.00, 'http://xixii.oss-cn-hangzhou.aliyuncs.com/2024-05-09/69256dd5b05aa479aa4005f744fa215a4.png?Expires=4868855590&OSSAccessKeyId=LTAI5tFE57VfGMrVXkk1RdPq&Signature=wRwbpvPwFMwPc1S3Ef0CxF%2Bs3x4%3D', 1, 1, NULL, 0, '复式');



-- ----------------------------

-- Table structure for order

-- ----------------------------

DROP TABLE IF EXISTS `order`;

CREATE TABLE `order`  (

  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '成交时间',

  `status` int(0) NULL DEFAULT NULL COMMENT '状态(0-预定 1-成交)',

  `house_id` int(0) NULL DEFAULT NULL COMMENT '房源',

  `total_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '成交价',

  `homebuy_id` int(0) NULL DEFAULT NULL COMMENT '购房者',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '订购表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of order

-- ----------------------------

INSERT INTO `order` VALUES (3, '2024-04-25 18:33:17', 0, 1, 546456.00, 2);

INSERT INTO `order` VALUES (4, '2024-04-25 18:34:03', 0, 2, 54364364.00, 2);



-- ----------------------------

-- Table structure for plot

-- ----------------------------

DROP TABLE IF EXISTS `plot`;

CREATE TABLE `plot`  (

  `id` int(0) NOT NULL AUTO_INCREMENT,

  `plotName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of plot

-- ----------------------------



-- ----------------------------

-- Table structure for purchase

-- ----------------------------

DROP TABLE IF EXISTS `purchase`;

CREATE TABLE `purchase`  (

  `id` int(0) NOT NULL AUTO_INCREMENT,

  `user_id` int(0) NULL DEFAULT NULL COMMENT '用户id',

  `home_id` int(0) NULL DEFAULT NULL COMMENT '房源id\r\n',

  `buy_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '购买时间',

  `price` double(10, 2) NULL DEFAULT NULL COMMENT '价格\r\n',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of purchase

-- ----------------------------

INSERT INTO `purchase` VALUES (6, 1, 1, '2024-05-10 03:00:32', 4353436.00);

INSERT INTO `purchase` VALUES (7, 1, 2, '2024-05-10 03:01:00', 345345.98);

INSERT INTO `purchase` VALUES (8, 1, 3, '2024-05-10 03:34:31', 1200.00);



-- ----------------------------

-- Table structure for sell_record

-- ----------------------------

DROP TABLE IF EXISTS `sell_record`;

CREATE TABLE `sell_record`  (

  `id` int(0) NOT NULL AUTO_INCREMENT,

  `user_id` int(0) NULL DEFAULT NULL,

  `home_id` int(0) NULL DEFAULT NULL,

  `buy_time` datetime(0) NULL DEFAULT NULL,

  `price` double(10, 2) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sell_record

-- ----------------------------

INSERT INTO `sell_record` VALUES (1, 1, 1, '2024-05-08 21:46:02', 4353436.00);

INSERT INTO `sell_record` VALUES (2, 1, 1, '2024-05-08 21:46:07', 4353436.00);



-- ----------------------------

-- Table structure for seller

-- ----------------------------

DROP TABLE IF EXISTS `seller`;

CREATE TABLE `seller`  (

  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',

  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',

  `full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名',

  `telephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系方式',

  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '卖房者表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of seller

-- ----------------------------

INSERT INTO `seller` VALUES (1, 'test04', '11111111', '小强', '13412341238', NULL, 'seller');

INSERT INTO `seller` VALUES (2, 'test05', '123456', '小猪2', '13412341234', NULL, 'seller');



-- ----------------------------

-- Table structure for tenement

-- ----------------------------

DROP TABLE IF EXISTS `tenement`;

CREATE TABLE `tenement`  (

  `id` int(0) NOT NULL AUTO_INCREMENT,

  `tenementName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物业名',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of tenement

-- ----------------------------



-- ----------------------------

-- Table structure for workers

-- ----------------------------

DROP TABLE IF EXISTS `workers`;

CREATE TABLE `workers`  (

  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',

  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',

  `full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名',

  `telephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系方式',

  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

  `create_time` datetime(0) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '员工表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of workers

-- ----------------------------

INSERT INTO `workers` VALUES (1, 'test01', '11111111', '李四', '13409871234', 'worker', NULL);

INSERT INTO `workers` VALUES (2, 'test02', '123456', '小明', '15612341234', 'worker', NULL);

INSERT INTO `workers` VALUES (4, 'test08', '123456', '张无忌', '13612344321', 'worker', NULL);

INSERT INTO `workers` VALUES (5, 'test09', '123456', '张翠山', '13212341234', 'worker', NULL);

INSERT INTO `workers` VALUES (6, 'djn', '123456', '董俊楠', '17624563454', 'worker', NULL);



SET FOREIGN_KEY_CHECKS = 1;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/PearlRoseMilkTea/house-sys.git
git@gitee.com:PearlRoseMilkTea/house-sys.git
PearlRoseMilkTea
house-sys
house-sys
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部