base_poi_landmarks sql - Githubissues

timlentse commented 9 years ago

CREATE TABLE IF NOT EXISTS `base_poi_landmarks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `province` varchar(50) DEFAULT NULL,
  `city_cn` varchar(50) DEFAULT NULL,
  `elong_city_id` char(4) NOT NULL,
  `lat` decimal(9,6) DEFAULT NULL,
  `lng` decimal(9,6) DEFAULT NULL,
  `source_domain` varchar(50) NOT NULL COMMENT '数据来源',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `cata` enum('metro','center','landmark','university','scene','train') NOT NULL,
  `address` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `na_city_cp` (`name`,`city_cn`,`source_domain`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

FBSENDER commented 9 years ago

city 变更为

city_name varchar(50)

city_id char(4)

elong定义了一套city_name与city_id的对应关系

FBSENDER commented 9 years ago

地标来源？

timlentse commented 9 years ago

@FBSENDER http://www.meituan.com/sitemap/dealsitemap.php?cityid=20这个如何？

FBSENDER commented 9 years ago

额我说表的字段增加数据的来源

timlentse commented 9 years ago

@FBSENDER ，噢， I konw.

FBSENDER commented 9 years ago

好像有拼写错误...

1.考虑把之前抓取地标的程序后端数据表改为这个 2.设计一下项目代码的目录结构 3.发现新的渠道写新的爬虫

2 做好了咱们一起看一下，再继续之后的工作

timlentse commented 9 years ago

把点评的也作为一个渠道合并到这个landmark项目中是否使poi这个项目更加有条理性呢？

FBSENDER commented 9 years ago

顶~

warriors-of-the-night / poi

base_poi_landmarks sql #11