最新要闻
- 全球聚焦:北江纺织:拟冲刺上交所IPO上市,预计募资4.22亿元,近年综合毛利率逐年下降
- 【环球速看料】五菱会玩!城市玩乐潮品SUV悦也“小书包”是块屏:可自定义内容
- 天天看点:打造名族品牌!杨元庆:联想核心生产制造还是立足中国
- 全球头条:超越GPS主导国内导航定位 北斗日定位量超3000亿次
- 焦点简讯:努比亚Z50 Ultra保护壳泄漏:后置摄像模组巨大无比
- 全球快看:院士称我国已经具备ChatGPT算力基础 关键在如何爆发
- 全球新消息丨工作至死:日本789万老人还在打零工
- 资讯:菲律宾一飞机早上起飞后失联:近期第二起
- 快播:橙色奶油冰淇淋层蛋糕食谱
- 世界要闻:精装版吉利星越L?领克DX11最新谍照曝光:首上魅族车机
- 天天消息!秒美国资费!每月198 还能更便宜:我国千兆宽带将全面普及 第二批城市名单来了
- 高尔夫美女参战《蚁人3》
- 网友曝光《狂飙》拍摄地有人竖牌“拍视频5元1次”:官方回应来了
- 天天精选!三亚去世侏儒抹香鲸被解剖:胃内有大量塑料/线虫 导致无法进食
- 焦点快看:要控制人类节奏!聊天机器人爱上用户并诱其离婚 微软出手限制了
- 年制绿氢3万吨、绿氧24万吨!我国全球最大绿氢项目开工
广告
手机
iphone11大小尺寸是多少?苹果iPhone11和iPhone13的区别是什么?
警方通报辅警执法直播中被撞飞:犯罪嫌疑人已投案
- iphone11大小尺寸是多少?苹果iPhone11和iPhone13的区别是什么?
- 警方通报辅警执法直播中被撞飞:犯罪嫌疑人已投案
- 男子被关545天申国赔:获赔18万多 驳回精神抚慰金
- 3天内26名本土感染者,辽宁确诊人数已超安徽
- 广西柳州一男子因纠纷杀害三人后自首
- 洱海坠机4名机组人员被批准为烈士 数千干部群众悼念
家电
环球新资讯:学习笔记——尚好房项目的数据库建表文件
(资料图片仅供参考)
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);
环球新资讯:学习笔记——尚好房项目的数据库建表文件
VirtualBox 配置虚拟机 Host-only 和 Nat
世界百事通!win系统提示请插入多卷集的最后一张磁盘解决方法
第三章 计算机进行小数运算时出错的原因
全球聚焦:北江纺织:拟冲刺上交所IPO上市,预计募资4.22亿元,近年综合毛利率逐年下降
【环球速看料】五菱会玩!城市玩乐潮品SUV悦也“小书包”是块屏:可自定义内容
天天看点:打造名族品牌!杨元庆:联想核心生产制造还是立足中国
天天快播:[数据结构] AVL树
全球头条:超越GPS主导国内导航定位 北斗日定位量超3000亿次
焦点简讯:努比亚Z50 Ultra保护壳泄漏:后置摄像模组巨大无比
全球快看:院士称我国已经具备ChatGPT算力基础 关键在如何爆发
全球新消息丨工作至死:日本789万老人还在打零工
资讯:菲律宾一飞机早上起飞后失联:近期第二起
(数据库系统概论|王珊)第四章数据库安全性:习题
快播:橙色奶油冰淇淋层蛋糕食谱
世界要闻:精装版吉利星越L?领克DX11最新谍照曝光:首上魅族车机
天天消息!秒美国资费!每月198 还能更便宜:我国千兆宽带将全面普及 第二批城市名单来了
焦点报道:java便捷的word导出工具(officejj)
当前观点:关于 The River All Red (Tr.许渊冲) 的一点感想
高尔夫美女参战《蚁人3》
网友曝光《狂飙》拍摄地有人竖牌“拍视频5元1次”:官方回应来了
天天精选!三亚去世侏儒抹香鲸被解剖:胃内有大量塑料/线虫 导致无法进食
4.打包子应用 投票
环球今日讯!极兔一面:10亿级ES海量搜索狂飙10倍,该怎么办?
一文让你彻底了解ChatGPT
焦点快看:要控制人类节奏!聊天机器人爱上用户并诱其离婚 微软出手限制了
年制绿氢3万吨、绿氧24万吨!我国全球最大绿氢项目开工
刘强东完了!章泽天官宣喜讯,被出轨4年。网友:这反击漂亮!
环球观点:数据结构刷题2023.02.18小记
环球精选!特斯拉追尾公交致1死 车主呼吁放开单踏板模式:为何老是失控?这是原因
环球资讯:1986年拍摄的泰坦尼克号残骸视频首次公开:残骸尺寸巨大
当前滚动:如何保存石榴
当前观点:iPhone 15 Pro CAD渲染图对比iPhone 14 Pro:改用USB C端口、相机更凸起、边框更窄
今日热门!渔民出海偶遇100多只海豚逐浪嬉戏:场面很美很壮观
苹果iOS 16.4首个公测版发布:普通用户将告别测试版
天天观焦点:油电平价!比亚迪秦PLUS DM-i 2023冠军版杀疯了:9.98万就能买DM-i超级混动
start+up韩剧在线观看_start up
环球快消息!女子不吃碳水半年狂减46斤 结果脱发、怕冷:治了半年
时讯:老黄厨房新菜来了 NVIDIA确认GTC 2023大会3月20日开幕
环球观天下!为什么这年头是个人就能造车?这事真就没门槛?
比半张A4纸还小 惠普1L迷你主机实测:3050 Ti独显给力
环球头条:iPhone安装不了第三方App?没关系它会出手!
世界简讯:咬牙耳朵里面疼怎么办_耳朵外轮廓疼怎么办
当前简讯:《星际2》冠军为孙哥黄哥剃光头:“卤蛋”情绪稳定
Vue急速入门-4
python项目中的“填坑”记录
自命为缓存之王的Caffeine(6)
MyBatis-Plus (SpringBoot2 版) Learning Day01
百事通!河南安阳一楼盘推出0首付0月供购房,这是什么操作?
交个朋友陷恶意裁员风波 没有了罗永浩还能走多远
世界快资讯丨口碑又崩了 漫威大片《蚁人3》豆瓣开分6.4:量子力学也带不动
【世界快播报】红旗接入百度AI文心一言 打造国产豪车品牌标杆
【当前独家】物理老师用《塞尔达传说:荒野之息》讲解小船过河原理:林克听了都说好!
世界头条:144MB缓存游戏神U!锐龙9 7950X3D跑分首曝:果然不出所料
每日热门:小米13 Ultra渲染图曝光:中分造型四摄
世界观热点:剪绳子问题 之动态规划 及 大数越界情况下的求余问题
千万小心二手RTX 20显卡!新套路出现:黑片秒变白片
日本MRJ刚失败 印度也要自研国产飞机:可载100人
女子第一次打到无人驾驶网约车:十分激动
每日热门:支持30+种中外语言!搜狗输入法力挺麒麟OS
世界微头条丨网站设计师招聘_网站设计师
世界热点!3、TreeMap源码解析
每片5.5元!绿联苹果钢化膜促销:适用iPhone 14/13/12系列
每日视讯:河南发布电动车佩戴头盔规定草案:未戴拒不改正罚20元
全球观天下!苦等3年微软终于点头:苹果M1/M2 Mac正式支持运行Win11
天天短讯!李荣浩新歌《乌梅子酱》火了!乌梅子酱淘宝搜索量暴涨200倍
新资讯:1999元!小米米家智能除湿机50L发布:100平除湿 梅雨季不怕了
当前信息:阿里一面:谈一下你对DDD的理解?2W字,帮你实现DDD自由
看热讯:关于ChatGPT,我们到底在担心什么?
【世界新要闻】在centos stream 9上搭建k8s最新版本(当前:v1.26.1)集群环境
【环球热闻】云原生学习作业8
天天新消息丨本周盘点(2.13-2.17):永吉股份周跌2.30%,主力资金合计净流出1796.91万元
每日看点!三年之期已到 不换APP享受自由音乐的理想国还有多远?
诗与远方
天天快消息!男子初到上海见转弯扶梯被震撼 网友看呆:同没见过
6999元!爱玛联名雷神发布HERO限量款机车:2500W电机 一键弹射
张纪中回应张颂文沙漠捡垃圾被剧组丢下:请理性看待
ESXi Args勒索病毒来袭,VMware ESXi用户需提高警惕
2、HashMap源码分析
观热点:使用springboot cache + redis缓存时使用gzip压缩以提升性能
天天最新:微凸铜底设计!微星CORELIQUID M360散热器图赏
当前视讯!美俄亥俄州居民嘴唇变色脸上起红斑 官方称空气水质安全:小溪全是死鱼 污染超百公里
全球快资讯丨iPhone 15 Pro外观无悬念了!关键是价格会更贵
《生化危机4:重制版》新细节:艾达王将扮演重要角色
蚌埠住了!iPhone 18 Pro背面设计来了 堪称行星发动机
世界今日报丨2023湖南新能源汽车置换促销补贴怎么领取
如何用chatGPT、代理IP和网络爬虫,打造一个智能有趣的聊天机器人?
环球新动态:数据结构刷题2023.02.17小记
分享7个刺激的老司机网站,别轻易点开
天天观察:乐维百科:什么是IT监控?为什么运维需要监控?
今日最新!正式抛弃 Feign!Spring 6 推出新特性:HTTP Interface,这波太秀了!
环球速看:2023年保定住房贷款利息个税专项附加扣除政策
《中国乒乓之绝地反击》今日正式上映:邓超、吴京演绎男乒至暗时刻
【世界聚看点】0脂无糖 舌里全麦面包14.9元2斤40片大促
你还会吃吗?女子用1元成本做出即食燕窝:呼吁别被智商税
今日热搜:车厂突然破产 几十万车主有点慌:修车配件全国找
真我GT Neo5 1TB版秒罄!徐起否认饥饿营销:需求量太大
天天微速讯:常见的个人博客搭建部署方案
焦点速递!SpringBoot
2023年跳槽,.NET工程师们,准备好了吗?