这是一个包含有全球9大洲，123个地区和4,126个城市的旅游游记数据库。该全球旅游游记数据库中有5,351篇游记，每篇游记记录有描述，出发数据和持续时间。这些游记是由1,461个作者撰写而成。在表游记内容中有37,263个记录且每个记录中有总结，标题和线路。除此之外，数据库中还有80,418张游记图片且存储在106.53M文件夹中。整个全球旅游游记数据库共有12个表。
With 5,351 tourism logs by 1,461 authors, this is a global tourism logs database.
Each tourism log is comprised of description, set out data and duration. All these tourism logs are about 4,126 line cities from 123regions of 9 continents around the world. In table log content, it has 37,263 records with summary, title and line spot in each. It also comes with 80,418 log images in the 106.53M media set.
The whole global tourism logs data set totaly has 12 tables.
| Name | n3_lyz_tripadvisor.cn_log |
|---|---|
| Data | 334.39M (+ 202.59M) |
| Tables | 12 (+ 0) |
| Columns | 54 (+ 0) |
| Table Rows | 313,930 (+ 0) |
| Media | 106.53M (+ 0B) |
| Files | 2,000 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| author | 1,461 | author |
99.93%
|
| continent | 9 | continent |
100%
|
| image_slug | 80,418 | log_content_id |
100%
|
| title |
0%
|
||
| line_city | 4,126 | line_city |
100%
|
| log | 5,351 | description |
0%
|
| set_out_data |
98.17%
|
||
| title |
100%
|
||
| duration |
100%
|
||
| log_content | 37,263 | summary |
96.3%
|
| log_id |
100%
|
||
| title |
100%
|
||
| line_spot |
99.66%
|
||
| log_content_detail | 159,833 | title |
99.75%
|
| description |
98.46%
|
||
| log_content_id |
100%
|
||
| log_x_author | 2,833 | log_id |
100%
|
| author_id |
100%
|
||
| log_x_line_city | 16,514 | log_id |
100%
|
| line_city_id |
100%
|
||
| region | 123 | region |
100%
|
| continent_id |
100%
|
||
| region_x_log | 5,999 | region_id |
100%
|
| log_id |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
LOG_IMAGE
| Size (Bytes) | Files |
|---|---|
| 106.53M | 2,000 |
