这是一个国际旅游景点及线路信息数据库。共有来自全球6个地区，108个城市的21,648个旅游景点。每个景点记录中包含有描述，简介，原价，基础价格，出发地，得分，评价数和月销售数。在该国际旅游数据库中共有5个其它旅游景点相关的表，分别是181,678个旅游评价记录，每个记录包含有独特性，评论，日期和时间；22,680个旅游特色及内容；64,630旅游政策及内容；44,308个旅游产品的原始价格和基础价格及3,961个旅游行程以及总结和日期。除此之外，数据库中有38,927个行程详情且每个详情记录中有时间，描述，内容和持续时间。在表图片中包含有46,996张旅游景点图片且存储在2.50G的媒体文件夹中。整个国际旅游景点及线路数据库共有14个表。
In the tourism database, there are 21,648 attractions records with description, short information, price original, price base, place from, score, comment count and month sale count in each from 108 cities of 6 regions around the world. There are 5 tables for these tourism, they are 181,678 tourism comment records with uniq, comment, date and time in each; 22,680 tourism feature records with content in each; 64,630 tourism policy records with content; tourism production with 44,308 records and having price base & price original in each and 3,961 tourism schedule records with summary and date in each. Besides, it has 38,927 schedule detail records with time, description, content and duration in each. In the table image slug, there are 46,996 images in the 2.50G media set. The whole world tourism attractions database totally has 14 tables.
| Name | n3_lyz_huodong.ctrip.com_international |
|---|---|
| Data | 241.39M (+ 60.94M) |
| Tables | 14 (+ 0) |
| Columns | 74 (+ 0) |
| Table Rows | 455,669 (+ 0) |
| Media | 2.50G (+ 0B) |
| Files | 46,504 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 108 | city |
100%
|
| region_id |
100%
|
||
| city_x_tourism | 30,727 | tourism_id |
100%
|
| city_id |
100%
|
||
| company | 0 | company |
0%
|
| image_slug | 46,996 | tourism_id |
100%
|
| region | 6 | region |
100%
|
| schedule_detail | 38,927 | time |
90.47%
|
| title |
88.58%
|
||
| description |
60.56%
|
||
| tourism_schedule_id |
100%
|
||
| content |
88.23%
|
||
| duration |
84.47%
|
||
| tourism | 21,648 | title |
100%
|
| description |
20.9%
|
||
| short_info |
99.8%
|
||
| price_original |
76.96%
|
||
| price_base |
100%
|
||
| place_from |
63.26%
|
||
| score |
16.99%
|
||
| comment_count |
100%
|
||
| month_sale_count |
23.64%
|
||
| tourism_comment | 181,678 | uniq |
100%
|
| comment |
100%
|
||
| tourism_id |
100%
|
||
| date |
100%
|
||
| time |
100%
|
||
| tourism_feature | 22,680 | content |
99.99%
|
| tourism_id |
100%
|
||
| tourism_policy | 64,630 | title |
100%
|
| content |
100%
|
||
| tourism_id |
100%
|
||
| tourism_production | 44,308 | title |
100%
|
| price_base |
100%
|
||
| tourism_id |
100%
|
||
| price_original |
54.41%
|
||
| tourism_schedule | 3,961 | date |
11.94%
|
| summary |
100%
|
||
| tourism_id |
100%
|
||
| tourism_x_company | 0 | tourism_id |
0%
|
| company_id |
0%
|
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
PHOTO_IMAGE
| Size (Bytes) | Files |
|---|---|
| 2.50G | 46,504 |
