这是一个国际旅游产品信息数据库，共有12个地区的10,885个国际旅游产品，每个旅游产品记录中有特征，描述，类型和总结。在数据中，共有63个公司提供这些国际旅游产品，10,167个始发城市和116个目的地。除此之外，数据中包含有28,545个旅游特征；4个旅游行程和5个旅游行程详情。在图片表中有12张旅游景点图片且存储在465.11M的文件夹中。整个国际旅游信息数据库中共有12个表。
This is an international tourism database with 10,885 records from 12 regions. Each record is comprised of feature, description, type and summary. In this data, there are 63 companies providing these tourism and it has 10,167 departure cities and 116 destinations. Besides, it has tourism feature with 28,545 records, 4 tourism schedules and tourism schedule detail with 5 records. The international tourism data also comes with 51,570 images of these tourism in the 465.11M media set. The whole international tourism database totally has 12 tables.
| Name | n3_lyz_taocan.ctrip.com_international |
|---|---|
| Data | 45.75M (+ 7.50M) |
| Tables | 12 (+ 0) |
| Columns | 55 (+ 0) |
| Table Rows | 122,875 (+ 0) |
| Media | 465.11M (+ 0B) |
| Files | 1,226 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| company | 63 | company |
98.41%
|
| departure_city | 10,167 | city |
100%
|
| tourism_id |
100%
|
||
| price_from |
99.09%
|
||
| destination | 116 | destination |
100%
|
| region_id |
100%
|
||
| destination_x_tourism | 10,885 | destination_id |
100%
|
| tourism_id |
100%
|
||
| image_slug | 51,570 | tourism_id |
100%
|
| title |
91.32%
|
||
| region | 12 | region |
100%
|
| tourism | 10,885 | title |
100%
|
| feature |
0%
|
||
| description |
0.01%
|
||
| type |
100%
|
||
| summary |
0.01%
|
||
| tourism_feature | 28,545 | content |
100%
|
| tourism_id |
100%
|
||
| tourism_schedule | 4 | date |
100%
|
| content |
100%
|
||
| tourism_id |
100%
|
||
| tourism_schedule_detail | 5 | time |
40%
|
| content |
100%
|
||
| tourism_schedule_id |
100%
|
||
| tourism_x_company | 10,623 | tourism_id |
100%
|
| company_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
PHOTO_IMAGE
| Size (Bytes) | Files |
|---|---|
| 465.11M | 1,226 |
