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轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/544258.html
標籤：其他
上一篇：04-資料型別轉換
下一篇：數的計數 c++