最新要闻

广告

手机

iphone11大小尺寸是多少?苹果iPhone11和iPhone13的区别是什么?

iphone11大小尺寸是多少?苹果iPhone11和iPhone13的区别是什么?

警方通报辅警执法直播中被撞飞:犯罪嫌疑人已投案

警方通报辅警执法直播中被撞飞:犯罪嫌疑人已投案

家电

环球新资讯:学习笔记——尚好房项目的数据库建表文件

来源:博客园


(资料图片仅供参考)

2023-02-18

一、尚好房项目的数据库建表文件

建立一个“db_house.sql”文件,将下述代码添加即可。

与idea连接的步骤:

(1)与idea与数据库连接,之后,新建一个数据库,重命名

(2)选中刚刚的数据库,右击,点击执行SQL语句

找到该db_house.sql文件的位置,导入即可。

# Host: r2czkq1vewxat78mnyg60oisurj5h4dp.mysql.qingcloud.link  (Version 5.7.29-32-log)# Date: 2022-02-15 09:34:45# Generator: MySQL-Front 6.1  (Build 1.26)## Structure for table "acl_admin"#CREATE TABLE `acl_admin` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "会员id",  `username` varchar(20) NOT NULL DEFAULT "" COMMENT "用户名",  `password` varchar(100) NOT NULL DEFAULT "" COMMENT "密码",  `name` varchar(50) DEFAULT NULL COMMENT "姓名",  `phone` varchar(11) DEFAULT NULL COMMENT "手机",  `head_url` varchar(200) DEFAULT NULL COMMENT "头像地址",  `description` varchar(255) DEFAULT NULL COMMENT "描述",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "删除标记(0:不可用 1:可用)",  PRIMARY KEY (`id`),  UNIQUE KEY `idx_username` (`username`)) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT="用户表";## Data for table "acl_admin"#INSERT INTO `acl_admin` VALUES (1,"admin","$2a$10$pK6CFWA.UWlDQyX4oR4gx.nVmafK9OjevKIu2VX0cDaJUQ8gpYhz.","admin","15099909888","http://r61cnlsfq.hn-bkt.clouddn.com/7daa4595-dfde-45da-8513-c5c2b81d20cc",NULL,"2021-05-31 18:08:43","2022-02-09 15:45:34",0),(2,"user1","$2a$10$pK6CFWA.UWlDQyX4oR4gx.nVmafK9OjevKIu2VX0cDaJUQ8gpYhz.","user1","13444654654","http://r61cnlsfq.hn-bkt.clouddn.com/fc277aec-0007-4aac-89e2-ced86b131f6b",NULL,"2021-06-01 08:46:22","2022-02-09 15:46:34",0),(3,"user2","$2a$10$pK6CFWA.UWlDQyX4oR4gx.nVmafK9OjevKIu2VX0cDaJUQ8gpYhz.","user2","17434343433","http://47.93.148.192:8080/group1/M00/03/F0/rBHu8mHqbpSAU0jVAAAgiJmKg0o148.jpg",NULL,"2021-06-18 17:18:29","2022-02-15 09:34:32",0),(6,"house1","$2a$10$pK6CFWA.UWlDQyX4oR4gx.nVmafK9OjevKIu2VX0cDaJUQ8gpYhz.","house1","18745354545","http://r61cnlsfq.hn-bkt.clouddn.com/23ebd355-1e6a-4eea-b5a8-f9b112971e5c",NULL,"2022-01-20 20:43:01","2022-02-15 09:34:32",0),(7,"house2","$2a$10$pK6CFWA.UWlDQyX4oR4gx.nVmafK9OjevKIu2VX0cDaJUQ8gpYhz.","house2","18034545345","http://r61cnlsfq.hn-bkt.clouddn.com/b681bc79-b5c1-4acf-9982-0fc68bc7e61f",NULL,"2022-01-20 20:43:07","2022-02-15 09:34:33",0),(8,"user","$2a$10$CUQYEOr7eU4O.aDkZ0Iv0OF/is8sACu0nxOn3NsJ/OppPbWC0qz.u","user","15010546381","http://r61cnlsfq.hn-bkt.clouddn.com/b09b3467-3d99-437a-bd2e-dd8c9be92bb8",NULL,"2022-02-08 10:35:38","2022-02-15 09:34:33",0);## Structure for table "acl_admin_role"#CREATE TABLE `acl_admin_role` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "主键id",  `role_id` bigint(20) NOT NULL DEFAULT "0" COMMENT "角色id",  `admin_id` bigint(20) NOT NULL DEFAULT "0" COMMENT "用户id",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "删除标记(0:不可用 1:可用)",  PRIMARY KEY (`id`),  KEY `idx_role_id` (`role_id`),  KEY `idx_admin_id` (`admin_id`)) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT="用户角色";## Data for table "acl_admin_role"#INSERT INTO `acl_admin_role` VALUES (1,1,1,"2021-05-31 18:09:02","2022-01-23 15:58:57",0),(2,3,2,"2022-01-20 20:49:37","2022-01-20 20:49:37",0),(3,2,3,"2022-01-20 20:49:46","2022-01-20 20:49:46",0),(4,5,6,"2022-01-20 20:49:54","2022-01-20 20:49:54",0),(5,4,7,"2022-01-20 20:50:01","2022-01-20 20:50:01",0),(6,8,8,"2022-02-08 10:48:44","2022-02-09 20:16:13",1),(7,8,8,"2022-02-09 19:48:22","2022-02-09 20:16:13",1),(8,1,8,"2022-02-09 19:48:22","2022-02-09 20:16:13",1),(9,1,8,"2022-02-09 19:48:56","2022-02-09 20:16:13",1),(10,8,8,"2022-02-09 20:16:13","2022-02-09 20:16:13",0);## Structure for table "acl_permission"#CREATE TABLE `acl_permission` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "编号",  `parent_id` bigint(20) NOT NULL DEFAULT "0" COMMENT "所属上级",  `name` varchar(20) NOT NULL DEFAULT "" COMMENT "权限名称",  `url` varchar(50) DEFAULT NULL COMMENT "菜单路径",  `code` varchar(100) DEFAULT NULL COMMENT "权限标识",  `type` tinyint(3) NOT NULL DEFAULT "0" COMMENT "类型(1:菜单,2:按钮)",  `sort` tinyint(3) DEFAULT NULL COMMENT "排序",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "删除标记(0:不可用 1:可用)",  PRIMARY KEY (`id`),  KEY `idx_parent_id` (`parent_id`)) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COMMENT="权限";## Data for table "acl_permission"#INSERT INTO `acl_permission` VALUES (2,0,"权限管理","",NULL,1,1,"2021-05-31 18:05:37","2022-01-20 15:01:10",0),(3,2,"用户管理","/admin",NULL,1,1,"2021-05-31 18:05:37","2022-01-20 20:18:06",0),(4,2,"角色管理","/role",NULL,1,2,"2021-05-31 18:05:37","2022-01-20 20:18:07",0),(5,2,"菜单管理","/permission",NULL,1,3,"2021-05-31 18:05:37","2022-01-20 20:18:10",0),(6,3,"分配角色","","admin.assgin",2,5,"2021-05-31 18:05:37","2022-01-20 15:32:15",0),(7,3,"添加","","admin.create",2,2,"2021-05-31 18:05:37","2022-01-20 15:27:42",0),(8,3,"修改","","admin.edit",2,3,"2021-05-31 18:05:37","2022-01-20 20:31:29",0),(9,4,"查看","","role.show",2,1,"2021-05-31 18:05:37","2022-01-20 15:01:13",0),(10,4,"修改","","role.edit",2,3,"2021-05-31 18:05:37","2022-01-20 15:18:40",0),(11,4,"分配权限","","role.assgin",2,5,"2021-05-31 18:05:37","2022-01-20 15:33:41",0),(12,4,"添加","","role.create",2,2,"2021-05-31 18:05:37","2022-01-20 15:18:36",0),(13,4,"删除","","role.delete",2,4,"2021-05-31 18:05:37","2022-01-20 15:18:43",0),(14,4,"分配权限","","role.assgin",2,5,"2021-05-31 18:05:37","2022-01-20 15:18:45",1),(15,5,"查看","","permission.show",2,1,"2021-05-31 18:05:37","2022-01-20 15:18:29",0),(16,5,"添加","","permission.create",2,2,"2021-05-31 18:05:37","2022-01-20 20:31:15",0),(17,5,"修改","","permission.edit",2,3,"2021-05-31 18:05:37","2022-01-20 20:31:20",0),(18,5,"删除","","permission.delete",2,4,"2021-05-31 18:05:37","2022-01-20 15:18:55",0),(23,0,"二手房管理"," ",NULL,1,2,"2022-01-13 18:36:35","2022-01-20 20:18:16",0),(24,23,"小区管理","/community?areaId=",NULL,1,2,"2022-01-13 18:37:26","2022-01-21 14:01:24",0),(26,23,"房源管理","/house",NULL,1,3,"2022-01-13 18:41:16","2022-01-20 20:18:27",0),(28,23,"数据字典","/dict",NULL,1,1,"2022-01-20 12:00:19","2022-01-20 20:18:25",0),(29,28,"查看",NULL,"dict.show",2,1,"2022-01-20 12:00:38","2022-01-20 15:19:15",0),(30,3,"查看",NULL,"admin.show",2,1,"2022-01-20 14:35:09","2022-01-20 15:01:23",0),(31,3,"删除",NULL,"admin.delete",2,4,"2022-01-20 15:32:34","2022-01-20 15:32:34",0),(32,24,"查看","","community.show",2,1,"2021-05-31 18:05:37","2022-01-20 15:18:29",0),(33,24,"添加","","community.create",2,2,"2021-05-31 18:05:37","2022-01-20 15:27:52",0),(34,24,"修改","","community.edit",2,3,"2021-05-31 18:05:37","2022-01-20 20:31:36",0),(35,24,"删除","","community.delete",2,4,"2021-05-31 18:05:37","2022-01-20 15:18:55",0),(36,26,"查看","","house.show",2,1,"2021-05-31 18:05:37","2022-01-20 15:18:29",0),(37,26,"添加","","house.create",2,2,"2021-05-31 18:05:37","2022-01-20 15:27:52",0),(38,26,"修改","","house.edit",2,3,"2021-05-31 18:05:37","2022-01-20 20:31:39",0),(39,26,"删除","","house.delete",2,4,"2021-05-31 18:05:37","2022-01-20 15:18:55",0),(40,26,"编辑图片",NULL,"house.editImage",2,6,"2022-01-20 20:16:04","2022-01-20 20:21:54",0),(41,26,"编辑经纪人",NULL,"house.editBroker",2,7,"2022-01-20 20:16:56","2022-01-20 20:21:55",0),(42,26,"编辑房东",NULL,"house.editUser",2,8,"2022-01-20 20:17:31","2022-01-20 20:21:56",0),(43,26,"审核发布",NULL,"house.publish",2,5,"2022-01-20 20:21:40","2022-01-20 20:21:40",0),(44,0,"会员管理",NULL,NULL,1,3,"2022-01-21 11:33:54","2022-01-21 11:33:54",0),(45,44,"会员列表","/userInfo",NULL,1,1,"2022-01-21 11:34:27","2022-01-21 11:34:27",0),(46,45,"查看",NULL,"userInfo.show",2,1,"2022-01-21 11:35:04","2022-01-21 11:38:49",0),(47,45,"锁定",NULL,"userInfo.lock",2,2,"2022-01-21 11:35:29","2022-01-21 11:35:46",0);## Structure for table "acl_role"#CREATE TABLE `acl_role` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "角色id",  `role_name` varchar(20) NOT NULL DEFAULT "" COMMENT "角色名称",  `role_code` varchar(20) DEFAULT NULL COMMENT "角色编码",  `description` varchar(255) DEFAULT NULL COMMENT "描述",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "删除标记(0:不可用 1:可用)",  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT="角色";## Data for table "acl_role"#INSERT INTO `acl_role` VALUES (1,"系统管理员","SYSTEM","系统管理员","2021-05-31 18:09:18","2022-01-20 20:37:52",0),(2,"权限浏览","","权限浏览","2021-06-01 08:38:40","2022-01-20 20:40:09",0),(3,"权限编辑",NULL,"权限编辑","2021-06-18 17:12:21","2022-01-20 20:40:27",0),(4,"房源浏览",NULL,"房源浏览","2021-09-27 09:37:13","2022-01-21 15:34:38",0),(5,"房源编辑",NULL,"房源编辑","2022-01-10 21:57:32","2022-01-21 15:40:45",0),(8,"普通管理员","","普通管理员","2022-02-08 10:46:29","2022-02-11 14:41:54",0);## Structure for table "acl_role_permission"#CREATE TABLE `acl_role_permission` (  `id` bigint(20) NOT NULL AUTO_INCREMENT,  `role_id` bigint(20) NOT NULL DEFAULT "0",  `permission_id` bigint(11) NOT NULL DEFAULT "0",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "删除标记(0:不可用 1:可用)",  PRIMARY KEY (`id`),  KEY `idx_role_id` (`role_id`),  KEY `idx_permission_id` (`permission_id`)) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8 COMMENT="角色权限";## Data for table "acl_role_permission"#INSERT INTO `acl_role_permission` VALUES (1,2,2,"2022-01-20 20:52:44","2022-01-20 20:52:44",0),(2,2,3,"2022-01-20 20:52:44","2022-01-20 20:52:44",0),(3,2,30,"2022-01-20 20:52:44","2022-01-20 20:52:44",0),(4,2,4,"2022-01-20 20:52:44","2022-01-20 20:52:44",0),(5,2,9,"2022-01-20 20:52:44","2022-01-20 20:52:44",0),(6,2,5,"2022-01-20 20:52:44","2022-01-20 20:52:44",0),(7,2,15,"2022-01-20 20:52:44","2022-01-20 20:52:44",0),(8,3,2,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(9,3,3,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(10,3,30,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(11,3,7,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(12,3,8,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(13,3,31,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(14,3,6,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(15,3,4,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(16,3,9,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(17,3,12,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(18,3,10,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(19,3,13,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(20,3,11,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(21,3,5,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(22,3,15,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(23,3,16,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(24,3,17,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(25,3,18,"2022-01-20 20:52:54","2022-01-20 20:52:54",0),(26,4,23,"2022-01-20 20:53:05","2022-01-20 20:53:05",0),(27,4,28,"2022-01-20 20:53:05","2022-01-20 20:53:05",0),(28,4,29,"2022-01-20 20:53:05","2022-01-20 20:53:05",0),(29,4,24,"2022-01-20 20:53:05","2022-01-20 20:53:05",0),(30,4,32,"2022-01-20 20:53:05","2022-01-20 20:53:05",0),(31,4,26,"2022-01-20 20:53:05","2022-01-20 20:53:05",0),(32,4,36,"2022-01-20 20:53:05","2022-01-20 20:53:05",0),(33,5,23,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(34,5,28,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(35,5,29,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(36,5,24,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(37,5,32,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(38,5,33,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(39,5,34,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(40,5,35,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(41,5,26,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(42,5,36,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(43,5,37,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(44,5,38,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(45,5,39,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(46,5,43,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(47,5,40,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(48,5,41,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(49,5,42,"2022-01-20 20:53:13","2022-01-20 20:53:13",0),(50,8,2,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(51,8,3,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(52,8,30,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(53,8,4,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(54,8,9,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(55,8,5,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(56,8,15,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(57,8,23,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(58,8,28,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(59,8,29,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(60,8,24,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(61,8,32,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(62,8,26,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(63,8,36,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(64,8,44,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(65,8,45,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(66,8,46,"2022-02-08 10:48:19","2022-02-09 20:18:36",1),(67,8,2,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(68,8,3,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(69,8,30,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(70,8,4,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(71,8,9,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(72,8,5,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(73,8,15,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(74,8,23,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(75,8,28,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(76,8,29,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(77,8,24,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(78,8,32,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(79,8,26,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(80,8,36,"2022-02-09 20:16:48","2022-02-09 20:18:36",1),(81,8,2,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(82,8,3,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(83,8,30,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(84,8,7,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(85,8,31,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(86,8,4,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(87,8,9,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(88,8,12,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(89,8,5,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(90,8,15,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(91,8,23,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(92,8,28,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(93,8,29,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(94,8,24,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(95,8,32,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(96,8,26,"2022-02-09 20:18:36","2022-02-09 20:18:36",0),(97,8,36,"2022-02-09 20:18:36","2022-02-09 20:18:36",0);## Structure for table "hse_community"#CREATE TABLE `hse_community` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "id",  `name` varchar(20) NOT NULL DEFAULT "" COMMENT "小区名称",  `description` text COMMENT "描述",  `province_id` bigint(20) DEFAULT NULL COMMENT "省id:(字典id) 预留字段",  `city_id` bigint(20) DEFAULT NULL COMMENT "城市id:(字典id)预留字段",  `area_id` bigint(20) DEFAULT NULL COMMENT "区域id:(字典id)",  `plate_id` bigint(20) DEFAULT NULL COMMENT "板块id:(字典id)",  `address` varchar(100) DEFAULT NULL COMMENT "详细地址",  `longitude` decimal(10,2) DEFAULT NULL COMMENT "经度(预留字段)",  `latitude` decimal(10,2) DEFAULT NULL COMMENT "纬度(预留字段)",  `build_years` varchar(20) DEFAULT NULL COMMENT "建筑年代",  `property_price` varchar(20) DEFAULT NULL COMMENT "物业价格",  `property_company` varchar(100) DEFAULT NULL COMMENT "物业公司",  `developer` varchar(100) DEFAULT NULL COMMENT "开发商",  `build_num` int(11) DEFAULT NULL COMMENT "楼栋数",  `house_num` int(11) DEFAULT NULL COMMENT "房屋数",  `average_price` decimal(10,2) DEFAULT NULL COMMENT "均价",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "删除标记(0:不可用 1:可用)",  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT="小区信息";## Data for table "hse_community"#INSERT INTO `hse_community` VALUES (1,"奥北南区","奥北南区",NULL,NULL,110234,110243,"立水桥奥北南区",NULL,NULL,"2005年","2.3","奥北物业","奥北建筑公司",5,3000,1.60,"2022-01-12 14:26:55","2022-02-08 14:37:16",0);## Structure for table "hse_dict"#CREATE TABLE `hse_dict` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "id",  `parent_id` bigint(20) NOT NULL DEFAULT "0" COMMENT "上级id",  `name` varchar(100) NOT NULL DEFAULT "" COMMENT "名称",  `dict_code` varchar(20) DEFAULT NULL COMMENT "编码",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "删除标记(0:不可用 1:可用)",  PRIMARY KEY (`id`),  KEY `parent_id` (`parent_id`),  KEY `dict_code` (`dict_code`)) ENGINE=InnoDB AUTO_INCREMENT=110338 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT="组织架构表";## Data for table "hse_dict"#INSERT INTO `hse_dict` VALUES (1,0,"全部分类","ROOT","2019-06-10 10:43:31","2022-01-12 14:56:13",0),(10000,1,"户型","houseType","2022-01-20 13:46:55","2022-01-20 13:47:57",0),(10001,10000,"一室","","2022-01-20 13:46:55","2022-01-20 13:50:51",0),(10002,10000,"两室","","2022-01-20 13:46:55","2022-01-20 13:50:56",0),(10003,10000,"三室","","2022-01-20 13:46:55","2022-01-20 13:50:59",0),(10004,10000,"四室","","2022-01-20 13:46:55","2022-01-20 13:51:11",0),(10005,10000,"四室以上","","2022-01-20 13:46:55","2022-01-20 13:51:20",0),(20000,1,"楼层","floor","2022-01-20 13:46:55","2022-01-20 13:48:19",0),(20001,20000,"低楼层","","2022-01-20 13:46:55","2022-01-20 13:51:45",0),(20002,20000,"中楼层","","2022-01-20 13:46:55","2022-01-20 13:51:50",0),(20003,20000,"高楼层","","2022-01-20 13:46:55","2022-01-20 13:51:51",0),(30000,1,"建筑结构","buildStructure","2022-01-20 13:46:55","2022-01-20 13:49:44",0),(30001,30000,"塔楼","","2022-01-20 13:46:55","2022-01-20 13:52:09",0),(30002,30000,"板楼","","2022-01-20 13:46:55","2022-01-20 13:52:16",0),(30003,30000,"板塔结合","","2022-01-20 13:46:55","2022-01-20 13:52:17",0),(40000,1,"装修情况","decoration","2022-01-20 13:46:55","2022-01-20 13:49:59",0),(40001,40000,"精装修","","2022-01-20 13:46:55","2022-01-20 13:52:36",0),(40002,40000,"普通装修","","2022-01-20 13:46:55","2022-01-20 13:52:43",0),(40003,40000,"毛坯房","","2022-01-20 13:46:55","2022-01-20 13:52:49",0),(40004,40000,"豪华装修","","2022-01-20 13:46:55","2022-01-20 13:53:01",0),(50000,1,"朝向","direction","2022-01-20 13:46:55","2022-01-20 13:50:06",0),(50001,50000,"南北","","2022-01-20 13:46:55","2022-01-20 13:53:14",0),(50002,50000,"朝南","","2022-01-20 13:46:55","2022-01-20 13:53:19",0),(50003,50000,"朝东","","2022-01-20 13:46:55","2022-01-20 13:53:21",0),(50004,50000,"朝北",NULL,"2022-01-20 13:53:34","2022-01-20 13:54:05",0),(50005,50000,"朝西",NULL,"2022-01-20 13:53:41","2022-01-20 13:54:07",0),(60000,1,"房屋用途","houseUse","2022-01-20 13:46:55","2022-01-20 13:50:37",0),(60001,60000,"普通住宅","","2022-01-20 13:46:55","2022-01-20 13:54:22",0),(60002,60000,"商业类","","2022-01-20 13:46:55","2022-01-20 13:54:28",0),(60003,60000,"别墅","","2022-01-20 13:46:55","2022-01-20 13:54:34",0),(60004,60000,"四合院","","2022-01-20 13:46:55","2022-01-20 13:54:41",0),(60005,60000,"公寓",NULL,"2022-01-20 13:54:45","2022-01-20 13:55:32",0),(60006,60000,"其他",NULL,"2022-01-20 13:55:15","2022-01-20 13:55:27",0),(100000,1,"省","province","2019-06-10 10:43:35","2022-01-12 14:56:59",0),(110000,100000,"北京","beijing","2019-06-10 10:43:35","2022-02-08 14:32:38",0),(110001,110000,"东城",NULL,"2022-01-20 20:10:41","2022-01-20 20:10:41",0),(110002,110001,"安定门",NULL,"2022-01-20 20:11:04","2022-01-20 20:11:04",0),(110003,110001,"安贞",NULL,"2022-01-20 20:11:04","2022-01-20 20:11:04",0),(110004,110001,"朝阳门内",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110005,110001,"朝阳门外",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110006,110001,"崇文门",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110007,110001,"灯市口",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110008,110001,"地安门",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110009,110001,"东单",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110010,110001,"东花市",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110011,110001,"东四",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110012,110001,"东直门",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110013,110001,"工体",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110014,110001,"广渠门",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110015,110001,"和平里",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110016,110001,"建国门内",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110017,110001,"建国门外",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110018,110001,"交道口",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110019,110001,"金宝街",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110020,110001,"六铺炕",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110021,110001,"蒲黄榆",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110022,110001,"前门",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110023,110001,"陶然亭",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110024,110001,"天坛",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110025,110001,"西单",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110026,110001,"西罗园",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110027,110001,"洋桥",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110028,110001,"永定门",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110029,110001,"左安门",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110030,110000,"西城",NULL,"2022-01-20 20:11:05","2022-01-20 20:11:05",0),(110031,110030,"白纸坊",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110032,110030,"菜户营",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110033,110030,"长椿街",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110034,110030,"车公庄",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110035,110030,"德胜门",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110036,110030,"地安门",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110037,110030,"阜成门",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110038,110030,"广安门",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110039,110030,"官园",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110040,110030,"金融街",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110041,110030,"六铺炕",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110042,110030,"马甸",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110043,110030,"马连道",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110044,110030,"木樨地",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110045,110030,"牛街",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110046,110030,"太平桥",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110047,110030,"陶然亭",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110048,110030,"天宁寺",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110049,110030,"西单",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110050,110030,"新街口",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110051,110030,"西四",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110052,110030,"西直门",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110053,110030,"宣武门",NULL,"2022-01-20 20:11:08","2022-01-20 20:11:08",0),(110054,110030,"右安门",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110055,110030,"内月坛",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110056,110000,"朝阳",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110057,110056,"安定门",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110058,110056,"安贞",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110059,110056,"奥林匹克公园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110060,110056,"百子湾",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110061,110056,"北工大",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110062,110056,"北苑CCBD",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110063,110056,"常营",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110064,110056,"朝青",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110065,110056,"朝阳公园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110066,110056,"朝阳门外",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110067,110056,"成寿寺",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110068,110056,"大山子",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110069,110056,"大望路",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110070,110056,"定福庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110071,110056,"东坝",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110072,110056,"东大桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110073,110056,"东直门",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110074,110056,"豆各庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110075,110056,"方庄垡头",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110076,110056,"甘露园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110077,110056,"高碑店",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110078,110056,"工体",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110079,110056,"广渠门",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110080,110056,"管庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110081,110056,"国展",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110082,110056,"和平里",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110083,110056,"红庙",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110084,110056,"欢乐谷",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110085,110056,"华威桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110086,110056,"惠新西街",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110087,110056,"建国门外",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110088,110056,"健翔桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110089,110056,"劲松",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110090,110056,"酒仙桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110091,110056,"亮马桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110092,110056,"立水桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110093,110056,"马甸",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110094,110056,"牡丹园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110095,110056,"南沙滩",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110096,110056,"农展馆",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110097,110056,"潘家园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110098,110056,"三里屯",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110099,110056,"三元桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110100,110056,"芍药居",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110101,110056,"十八里店",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110102,110056,"石佛营",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110103,110056,"十里堡",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110104,110056,"十里河",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110105,110056,"首都机场",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110106,110056,"双井",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110107,110056,"双桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110108,110056,"四惠",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110109,110056,"宋家庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110110,110056,"太阳宫",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110111,110056,"甜水园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110112,110056,"通州北苑",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110113,110056,"团结湖",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110114,110056,"望京",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110115,110056,"西坝河",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110116,110056,"燕莎",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110117,110056,"亚运村",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110118,110056,"亚运村",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110119,110056,"小营",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110120,110056,"朝阳其它",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110121,110056,"中央别墅区",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110122,110000,"海淀",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110123,110122,"安宁庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110124,110122,"奥林匹克公园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110125,110122,"白石桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110126,110122,"北太平庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110127,110122,"厂洼",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110128,110122,"定慧寺",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110129,110122,"二里庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110130,110122,"甘家口",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110131,110122,"公主坟",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110132,110122,"海淀北部新区",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110133,110122,"海淀其它",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110134,110122,"军博",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110135,110122,"六里桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110136,110122,"马甸",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110137,110122,"马连洼",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110138,110122,"牡丹园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110139,110122,"清河",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110140,110122,"上地",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110141,110122,"世纪城",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110142,110122,"双榆树",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110143,110122,"四季青",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110144,110122,"苏州桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110145,110122,"田村",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110146,110122,"万柳",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110147,110122,"万寿路",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110148,110122,"魏公村",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110149,110122,"五道口",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110150,110122,"五棵松",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110151,110122,"小西天",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110152,110122,"西北旺",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110153,110122,"西二旗",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110154,110122,"新街口",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110155,110122,"西三旗",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110156,110122,"西山",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110157,110122,"西直门",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110158,110122,"学院路",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110159,110122,"颐和园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110160,110122,"圆明园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110161,110122,"玉泉路",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110162,110122,"皂君庙",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110163,110122,"知春路",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110164,110122,"中关村",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110165,110122,"紫竹桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110166,110000,"丰台",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110167,110166,"北大地",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110168,110166,"北京南站",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110169,110166,"菜户营",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110170,110166,"草桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110171,110166,"成寿寺",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110172,110166,"大红门",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110173,110166,"方庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110174,110166,"丰台其它",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110175,110166,"广安门",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110176,110166,"和义",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110177,110166,"花乡",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110178,110166,"角门",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110179,110166,"旧宫",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110180,110166,"看丹桥科技园区",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110181,110166,"刘家窑",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110182,110166,"六里桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110183,110166,"丽泽",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110184,110166,"卢沟桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110185,110166,"马家堡",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110186,110166,"马连道",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110187,110166,"木樨园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110188,110166,"蒲黄榆",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110189,110166,"七里庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110190,110166,"青塔",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110191,110166,"十里河",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110192,110166,"宋家庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110193,110166,"太平桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110194,110166,"陶然亭",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110195,110166,"万源",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110196,110166,"五棵松",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110197,110166,"五里店",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110198,110166,"西红门",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110199,110166,"西罗园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110200,110166,"新宫",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110201,110166,"洋桥",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110202,110166,"永定门",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110203,110166,"右安门外",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110204,110166,"岳各庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110205,110166,"玉泉营",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110206,110166,"赵公口",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110207,110000,"石景山",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110208,110207,"八角",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110209,110207,"城子",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110210,110207,"古城",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110211,110207,"老山",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110212,110207,"鲁谷",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110213,110207,"苹果园",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110214,110207,"石景山其它",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110215,110207,"杨庄",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110216,110207,"玉泉路",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110217,110000,"通州",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110218,110217,"北关",NULL,"2022-01-20 20:11:09","2022-01-20 20:11:09",0),(110219,110217,"大兴新机场洋房别墅区",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110220,110217,"果园",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110221,110217,"九棵树(家乐福)",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110222,110217,"临河里",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110223,110217,"梨园",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110224,110217,"潞苑",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110225,110217,"马驹桥",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110226,110217,"乔庄",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110227,110217,"首都机场",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110228,110217,"通州北苑",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110229,110217,"通州其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110230,110217,"万达",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110231,110217,"武夷花园",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110232,110217,"亦庄",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110233,110217,"玉桥",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110234,110000,"昌平",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110235,110234,"奥林匹克公园",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110236,110234,"百善镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110237,110234,"北七家",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110238,110234,"昌平其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110239,110234,"东关",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110240,110234,"鼓楼大街",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110241,110234,"回龙观",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110242,110234,"霍营",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110243,110234,"立水桥",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110244,110234,"南口南邵",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110245,110234,"沙河",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110246,110234,"天通苑",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110247,110234,"小汤山",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110248,110234,"西关环岛",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110249,110234,"西三旗",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110250,110000,"大兴",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110251,110250,"大兴其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110252,110250,"大兴新机场",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110253,110250,"大兴新机场洋房别墅区",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110254,110250,"高米店",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110255,110250,"观音寺",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110256,110250,"和义",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110257,110250,"黄村火车站",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110258,110250,"黄村中",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110259,110250,"旧宫",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110260,110250,"科技园区",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110261,110250,"马驹桥",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110262,110250,"南中轴机场商务区",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110263,110250,"天宫院",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110264,110250,"天宫院南",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110265,110250,"通州其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110266,110250,"万源",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110267,110250,"西红门",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110268,110250,"义和庄",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110269,110250,"瀛海",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110270,110250,"亦庄",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110271,110250,"亦庄开发区其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110272,110250,"枣园",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110273,110000,"亦庄开发区",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110274,110273,"马驹桥",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110275,110273,"通州其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110276,110273,"亦庄",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110277,110273,"亦庄开发区",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110278,110273,"其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110279,110000,"顺义",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110280,110279,"后沙峪",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110281,110279,"李桥",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110282,110279,"马坡",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110283,110279,"首都机场",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110284,110279,"顺义城",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110285,110279,"顺义其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110286,110279,"天竺",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110287,110279,"杨镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110288,110279,"中央别墅区",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110289,110000,"房山",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110290,110289,"长阳",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110291,110289,"城关",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110292,110289,"窦店",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110293,110289,"房山其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110294,110289,"韩村河",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110295,110289,"良乡",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110296,110289,"琉璃河",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110297,110289,"阎村",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110298,110289,"燕山",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110299,110000,"门头沟",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110300,110299,"滨河西区",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110301,110299,"城子",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110302,110299,"大峪",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110303,110299,"冯村",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110304,110299,"门头沟其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110305,110299,"上岸地铁",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110306,110299,"石门营",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110307,110000,"平谷",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110308,110307,"平谷",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110309,110307,"平谷其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110310,110000,"怀柔",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110311,110310,"怀柔",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110312,110310,"怀柔其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110313,110000,"密云",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110314,110313,"北庄镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110315,110313,"不老屯镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110316,110313,"大城子镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110317,110313,"东邵渠镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110318,110313,"冯家峪镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110319,110313,"高岭镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110320,110313,"古北口镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110321,110313,"鼓楼街道",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110322,110313,"果园街道",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110323,110313,"河南寨镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110324,110313,"巨各庄镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110325,110313,"密云其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110326,110313,"密云镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110327,110313,"穆家峪镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110328,110313,"石城镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110329,110313,"十里堡镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110330,110313,"太师屯镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110331,110313,"檀营",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110332,110313,"新城子镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110333,110313,"西田各庄镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110334,110313,"溪翁庄镇",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110335,110000,"延庆",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110336,110335,"延庆",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0),(110337,110335,"延庆其它",NULL,"2022-01-20 20:11:10","2022-01-20 20:11:10",0);## Structure for table "hse_house"#CREATE TABLE `hse_house` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "id",  `community_id` bigint(20) DEFAULT NULL COMMENT "小区id",  `name` varchar(20) DEFAULT "" COMMENT "房源名称",  `description` varchar(200) DEFAULT NULL COMMENT "描述",  `total_price` decimal(10,2) DEFAULT NULL COMMENT "总价:万元",  `unit_price` decimal(10,2) DEFAULT NULL COMMENT "单位价格",  `build_area` decimal(10,2) DEFAULT NULL COMMENT "建筑面积",  `inside_area` decimal(10,2) DEFAULT NULL COMMENT "套内面积",  `house_type_id` varchar(20) DEFAULT NULL COMMENT "户型:(字典id)",  `floor_id` bigint(20) DEFAULT NULL COMMENT "楼层(字典id)",  `build_structure_id` bigint(20) DEFAULT NULL COMMENT "建筑结构:(字典id)",  `direction_id` bigint(20) DEFAULT NULL COMMENT "朝向:(字典id)",  `decoration_id` bigint(20) DEFAULT NULL COMMENT "装修情况:(字典id)",  `house_use_id` bigint(20) DEFAULT NULL COMMENT "房屋用途:(字典id)",  `elevator_ratio` varchar(20) DEFAULT NULL COMMENT "电梯比例",  `listing_date` date DEFAULT NULL COMMENT "挂牌日期",  `last_trade_date` date DEFAULT NULL COMMENT "上次交易日期",  `default_image_url` varchar(255) DEFAULT NULL COMMENT "默认图片",  `status` tinyint(3) NOT NULL DEFAULT "0" COMMENT "状态",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "删除标记(0:不可用 1:可用)",  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT="房源表";## Data for table "hse_house"#INSERT INTO `hse_house` VALUES (1,1," 仁恒滨河湾 4室2厅 东南","房子是套四改成了套三带书房,,客厅正带阳台,位置安静不临.",250.00,25000.00,100.00,98.00,"10004",20001,30002,50001,40002,60002,"2梯5户","2022-01-21","2022-01-03","http://139.198.127.41:9000/sph/20220117/pc1_HOkXp6Dq7_1.jpg",1,"2022-01-12 18:46:12","2022-02-09 14:02:40",0),(2,1," 中粮鸿云 2室1厅 南","总价低,位置安静,屋内干净整洁,标准套二,户型方正",150.00,21000.00,100.00,60.00,"10002",20003,30002,50002,40001,60001,"2梯5户","2022-01-20","2022-01-21","http://139.198.127.41:9000/sph/20220117/apc_9FMIBMHM9_1.jpg",1,"2022-01-17 11:18:56","2022-02-09 14:02:42",0),(3,1," 奥北南区 2室1厅 南","总价低,位置安静,屋内干净整洁,标准套二,户型方正",190.00,21000.00,100.00,60.00,"10002",20003,30002,50002,40001,60001,"2梯5户","2022-01-20","2022-01-21","http://139.198.127.41:9000/sph/20220117/apc_9FMIBMHM9_1.jpg",1,"2022-01-22 15:36:43","2022-02-09 15:54:21",0);## Structure for table "hse_house_broker"#CREATE TABLE `hse_house_broker` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "id",  `house_id` bigint(20) DEFAULT NULL COMMENT "房源id",  `broker_id` bigint(20) NOT NULL DEFAULT "0" COMMENT "经纪人id",  `broker_name` varchar(10) DEFAULT NULL COMMENT "经纪人名称",  `broker_head_url` varchar(255) DEFAULT NULL COMMENT "经纪人头像",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "删除标记(0:不可用 1:可用)",  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT="房源经纪人";## Data for table "hse_house_broker"#INSERT INTO `hse_house_broker` VALUES (1,1,1,"张丽丽","http://r61cnlsfq.hn-bkt.clouddn.com/7daa4595-dfde-45da-8513-c5c2b81d20cc","2022-01-13 10:54:46","2022-02-09 15:50:25",0),(4,2,1,"张滴滴","http://r61cnlsfq.hn-bkt.clouddn.com/23ebd355-1e6a-4eea-b5a8-f9b112971e5c","2022-01-17 11:20:53","2022-02-09 15:50:46",1),(5,2,6,"王倩倩","http://r61cnlsfq.hn-bkt.clouddn.com/7daa4595-dfde-45da-8513-c5c2b81d20cc","2022-01-21 16:22:35","2022-02-09 15:50:34",0),(6,3,3,"李遇华","http://r61cnlsfq.hn-bkt.clouddn.com/23ebd355-1e6a-4eea-b5a8-f9b112971e5c","2022-02-08 14:40:07","2022-02-09 15:50:56",0);## Structure for table "hse_house_image"#CREATE TABLE `hse_house_image` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "id",  `house_id` bigint(20) DEFAULT NULL COMMENT "房源id",  `image_name` varchar(100) NOT NULL DEFAULT "" COMMENT "图片名称",  `image_url` varchar(200) DEFAULT NULL COMMENT "图片地址",  `type` tinyint(3) DEFAULT NULL COMMENT "1:普通图片 2:房产图片",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "删除标记(0:不可用 1:可用)",  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT="房源图片";## Data for table "hse_house_image"#INSERT INTO `hse_house_image` VALUES (5,2,"pc1_HOkXp6Dq7_1.jpg","http://139.198.127.41:9000/sph/20220117/pc1_HOkXp6Dq7_1.jpg",1,"2022-01-17 11:20:13","2022-01-17 11:20:13",0),(6,2,"apc_EgwS9InnI_1.jpg","http://139.198.127.41:9000/sph/20220117/apc_EgwS9InnI_1.jpg",1,"2022-01-17 11:20:13","2022-01-17 11:20:13",0),(7,2,"standard_4b284f6e-04ca-4540-a26e-5305743b68d8.jpg","http://139.198.127.41:9000/sph/20220117/standard_4b284f6e-04ca-4540-a26e-5305743b68d8.jpg",1,"2022-01-17 11:20:13","2022-01-17 11:20:13",0),(8,2,"apc_HbdX4RkOV_1.jpg","http://139.198.127.41:9000/sph/20220117/apc_HbdX4RkOV_1.jpg",1,"2022-01-17 11:20:13","2022-01-17 11:20:13",0),(9,1,"apc_9FMIBMHM9_1.jpg","http://139.198.127.41:9000/sph/20220117/apc_9FMIBMHM9_1.jpg",1,"2022-01-17 11:23:00","2022-01-17 11:23:00",0),(10,1,"apc_HIBLQpuMf_1.jpg","http://139.198.127.41:9000/sph/20220117/apc_HIBLQpuMf_1.jpg",1,"2022-01-17 11:23:00","2022-01-17 11:23:00",0),(11,1,"apc_4NhFJIj5T_1.jpg","http://139.198.127.41:9000/sph/20220117/apc_4NhFJIj5T_1.jpg",1,"2022-01-17 11:23:00","2022-01-17 11:23:00",0),(12,1,"apc_ODc6saIRi_1.jpg","http://139.198.127.41:9000/sph/20220117/apc_ODc6saIRi_1.jpg",1,"2022-01-17 11:23:01","2022-01-17 11:23:01",0),(13,1,"apc_ymzbHkvAU_1.jpg","http://139.198.127.41:9000/sph/20220117/apc_ymzbHkvAU_1.jpg",1,"2022-01-17 11:23:01","2022-01-17 11:23:01",0),(14,1,"pc1_4MHQXcI32_1.jpg","http://139.198.127.41:9000/sph/20220117/pc1_4MHQXcI32_1.jpg",1,"2022-01-17 11:23:01","2022-01-17 11:23:01",0),(15,1,"standard_9ab173da-bd9b-4f18-8094-5258601610de.jpg","http://139.198.127.41:9000/sph/20220117/standard_9ab173da-bd9b-4f18-8094-5258601610de.jpg",1,"2022-01-17 11:23:01","2022-01-20 11:16:53",1),(16,1,"dcddb77d336fb01334e87bcb1054b082_23201.jpg","http://139.198.127.41:9000/sph/20220120/dcddb77d336fb01334e87bcb1054b082_23201.jpg",2,"2022-01-20 10:48:29","2022-01-20 10:48:29",0),(17,1,"a482f61378e3ca735f257d89ff9a687f_63413.png","http://139.198.127.41:9000/sph/20220120/a482f61378e3ca735f257d89ff9a687f_63413.png",2,"2022-01-20 10:48:29","2022-01-20 10:48:29",0),(18,2,"8cd7fe193a7c39ad47173b5c250bb81d_74680.png","http://139.198.127.41:9000/sph/20220120/8cd7fe193a7c39ad47173b5c250bb81d_74680.png",2,"2022-01-20 11:22:04","2022-01-20 11:22:04",0),(19,2,"a482f61378e3ca735f257d89ff9a687f_63413.png","http://139.198.127.41:9000/sph/20220120/a482f61378e3ca735f257d89ff9a687f_63413.png",2,"2022-01-20 11:22:04","2022-01-20 11:22:04",0),(20,2,"f12c6915a1dfd666d8bb44a83b0dd6cc_24510.png","http://139.198.127.41:9000/sph/20220120/f12c6915a1dfd666d8bb44a83b0dd6cc_24510.png",2,"2022-01-20 11:22:05","2022-01-20 11:22:05",0),(21,2,"2b1b68e18a5e9530e4cb952c6407efa1_28715.png","http://139.198.127.41:9000/sph/20220120/2b1b68e18a5e9530e4cb952c6407efa1_28715.png",2,"2022-01-20 11:22:05","2022-01-20 11:22:28",1),(22,1,"8cd7fe193a7c39ad47173b5c250bb81d_74680.png","http://r37k428df.hn-bkt.clouddn.com/c5e3e5d1-8dc5-4783-9b80-5c9c74ea7d16",2,"2022-01-21 08:53:56","2022-01-21 09:11:09",1),(23,1,"a482f61378e3ca735f257d89ff9a687f_63413.png","http://r37k428df.hn-bkt.clouddn.com/71fbbd2a-bb95-4e9f-8fba-39d1dc37d191",2,"2022-01-21 08:55:06","2022-01-21 09:11:13",1),(24,1,"dcddb77d336fb01334e87bcb1054b082_23201.jpg","http://r61cnlsfq.hn-bkt.clouddn.com/0a3e9749-6e2f-4344-b62f-1f2c3037eda2",2,"2022-01-21 09:11:50","2022-01-21 09:11:50",0),(25,2,"f12c6915a1dfd666d8bb44a83b0dd6cc_24510.png","http://r61cnlsfq.hn-bkt.clouddn.com/cb530b79-b7aa-48df-b348-f9420f6bdb3b",2,"2022-01-21 09:28:16","2022-01-21 09:28:16",0),(26,2,"2b1b68e18a5e9530e4cb952c6407efa1_28715.png","http://r61cnlsfq.hn-bkt.clouddn.com/d980bd1d-aadc-44a6-81a2-d30d8d6224a7",2,"2022-01-21 09:28:47","2022-01-21 09:28:47",0),(27,3,"apc_o66IlLFre_1.jpg","http://r61cnlsfq.hn-bkt.clouddn.com/c4e911f2-cf57-40f6-b7d7-c1906dee52a7",1,"2022-02-08 14:39:29","2022-02-08 14:39:29",0),(28,3,"apc_dxN7NHSji_1.jpg","http://r61cnlsfq.hn-bkt.clouddn.com/8eb11585-4d02-4dff-b060-ff7739394bb2",1,"2022-02-08 14:39:29","2022-02-08 14:39:29",0),(29,3,"pc1_lqaPviRok_1.jpg","http://r61cnlsfq.hn-bkt.clouddn.com/d7acc92f-c13a-41bf-b539-5a873f09e999",1,"2022-02-08 14:39:29","2022-02-08 14:39:29",0),(30,3,"standard_2f9b5fb5-e16e-44a8-ae39-5ea34a82b4d5.jpg","http://r61cnlsfq.hn-bkt.clouddn.com/48f1ec44-6035-44ac-b145-ae08e2c14c49",1,"2022-02-08 14:39:29","2022-02-08 14:39:29",0),(31,3,"apc_dxN7NHSji_1.jpg","http://r61cnlsfq.hn-bkt.clouddn.com/f0120dce-6b88-4fa2-a5eb-1d1ddea76226",2,"2022-02-08 14:39:51","2022-02-08 14:39:51",0),(32,3,"apc_o66IlLFre_1.jpg","http://r61cnlsfq.hn-bkt.clouddn.com/73236d3c-340c-45bb-8c35-cbc7c2df9c2c",2,"2022-02-08 14:39:51","2022-02-08 14:39:51",0),(33,3,"pc1_lqaPviRok_1.jpg","http://r61cnlsfq.hn-bkt.clouddn.com/f7730961-618e-49e1-be72-180efac8cb26",2,"2022-02-08 14:39:51","2022-02-08 14:39:51",0),(34,3,"standard_2f9b5fb5-e16e-44a8-ae39-5ea34a82b4d5.jpg","http://r61cnlsfq.hn-bkt.clouddn.com/174a528b-80f1-43b2-9be4-9f10838e787c",2,"2022-02-08 14:39:51","2022-02-08 14:39:51",0),(35,3,"pc1_J6RXLclrT_1.jpg","http://r61cnlsfq.hn-bkt.clouddn.com/18c167ea-b158-4566-b5d2-1d1b97d7a255",1,"2022-02-09 20:12:38","2022-02-09 20:12:38",0),(36,3,"pc0_2YP2k5bsv_1.jpg","http://r61cnlsfq.hn-bkt.clouddn.com/e1dc7a3a-bf98-4338-aca7-5dcc4f8b1e8c",1,"2022-02-09 20:12:38","2022-02-09 20:12:51",1);## Structure for table "hse_house_user"#CREATE TABLE `hse_house_user` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "id",  `house_id` bigint(20) DEFAULT NULL COMMENT "房源id",  `name` varchar(20) NOT NULL DEFAULT "" COMMENT "房东姓名",  `phone` varchar(11) DEFAULT NULL COMMENT "手机",  `sex` tinyint(3) DEFAULT "1" COMMENT "性别 1:男 2:女",  `id_no` varchar(20) DEFAULT NULL COMMENT "身份证号",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "删除标记(0:不可用 1:可用)",  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT="房东信息表";## Data for table "hse_house_user"#INSERT INTO `hse_house_user` VALUES (1,1,"test","111",1,"1111111111","2022-01-13 11:00:16","2022-01-13 11:00:16",0),(2,1,"3","3",1,"1","2022-01-13 17:57:53","2022-01-13 17:58:08",1),(3,2,"麻子","15010445566",2,"5325555555555555555","2022-01-17 11:21:22","2022-01-17 11:21:22",0),(4,3,"张三","15010445566",1,"5325555555555555555","2022-02-08 14:40:29","2022-02-08 14:40:29",0),(5,3,"李四","15010445566",2,"5325555555555555555","2022-02-08 14:49:25","2022-02-08 14:49:25",0);## Structure for table "user_follow"#CREATE TABLE `user_follow` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "编号",  `user_id` bigint(20) NOT NULL DEFAULT "0" COMMENT "用户id",  `house_id` bigint(20) NOT NULL DEFAULT "0" COMMENT "房源id",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "逻辑删除(1:已删除,0:未删除)",  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT="用户关注表";## Data for table "user_follow"#INSERT INTO `user_follow` VALUES (1,1,1,"2022-01-21 11:17:57","2022-02-08 10:10:58",1),(2,1,1,"2022-02-08 10:11:08","2022-02-10 10:07:14",1),(3,1,3,"2022-02-09 20:27:22","2022-02-10 09:26:15",1),(4,1,3,"2022-02-10 10:01:17","2022-02-10 10:01:57",1),(5,1,3,"2022-02-10 10:06:03","2022-02-10 10:07:12",1),(6,1,3,"2022-02-10 10:20:48","2022-02-10 10:23:31",1),(7,1,2,"2022-02-10 10:23:24","2022-02-10 10:23:29",1),(8,1,3,"2022-02-10 10:23:38","2022-02-10 10:23:38",0);## Structure for table "user_info"#CREATE TABLE `user_info` (  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "编号",  `phone` varchar(11) NOT NULL DEFAULT "" COMMENT "手机号",  `password` varchar(50) NOT NULL DEFAULT "" COMMENT "用户密码",  `nick_name` varchar(20) DEFAULT NULL COMMENT "用户昵称",  `status` tinyint(3) NOT NULL DEFAULT "1" COMMENT "状态(0:锁定 1:正常)",  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "创建时间",  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",  `is_deleted` tinyint(3) NOT NULL DEFAULT "0" COMMENT "逻辑删除(1:已删除,0:未删除)",  PRIMARY KEY (`id`),  KEY `uk_mobile` (`phone`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT="用户表";## Data for table "user_info"#INSERT INTO `user_info` VALUES (1,"15099999999","96e79218965eb72c92a549dd5a330112","晴天",1,"2022-01-19 13:59:14","2022-01-19 14:17:35",0);

关键词: 更新时间 创建时间 首都机场