这是一个国际组团旅游数据库，共有24,458个旅游信息记录。每个信息记录中有 内容，描述和类型。这些旅游团信息是由507家公司提供, 2个出发城市和77个目的地，共涉及全球9个区域。除此之外，旅游团信息数据库中还包含有7个与国际组团旅游相关的表，分别是12个旅游内容及内容，详情和路线；12个旅游特色；7个旅游线路及路线名称；13个旅游时间表及日期和内容；26个旅游景点及景点，描述和旅游时间表详情；53个旅游计划详情及时间，内容，旅游时间表和标记和40个旅游图片记录且这些照片储存在55.46K的文件夹中。
该国际旅游团信息数据库中共有19个表。
This is a multi-table database of global tourisms with 24,458 records provided by 507 companies from 9 regions in the world. Each record is comprised of content, description and type.
From this international tourisms database, there are 2 departure cities and 77 destinations. Besides, there are 7 tables mostly related with these tourisms, they are 12 tourism content records with content, detail and route in each；12 tourism feature records；7 tourism route records with name, route and date in each；13 tourism schedule records with date and content in each；26 tourism schedule attractions records with attractions, description and tourism schedule detail in each；53 tourism schedule detail records with time, content, tourism schedule and mark in each and 40 image slug records and these images are keeped in 55.46K media set.
The whole global tourisms data set has 19 tables.
| Name | n3_lyz_vacations.ctrip.com.grouptravel_international |
|---|---|
| Data | 27.44M (+ 0B) |
| Tables | 19 (+ 0) |
| Columns | 92 (+ 0) |
| Table Rows | 69,825 (+ 0) |
| Media | 55.46K (+ 0B) |
| Files | 2 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| company | 507 | company |
99.8%
|
| departure_city | 2 | tourism_id |
100%
|
| city |
100%
|
||
| price_from |
100%
|
||
| destination | 77 | destination |
100%
|
| region_id |
100%
|
||
| destination_2 | 39 | destination |
100%
|
| key_2_id |
100%
|
||
| destination_2_x_tourism | 9,566 | destination_2_id |
100%
|
| tourism_id |
100%
|
||
| destination_x_tourism | 15,252 | destination_id |
100%
|
| tourism_id |
100%
|
||
| image_slug | 40 | tourism_id |
100%
|
| title |
70%
|
||
| region | 9 | region |
100%
|
| key_id |
100%
|
||
| tourism | 24,458 | title |
100%
|
| content |
0%
|
||
| description |
0%
|
||
| type |
86.55%
|
||
| tourism_content | 12 | content |
100%
|
| detail |
16.67%
|
||
| tourism_route_id |
100%
|
||
| tourism_feature | 12 | content |
100%
|
| tourism_id |
100%
|
||
| tourism_route | 7 | route_name |
100%
|
| tourism_id |
100%
|
||
| tourism_schedule | 13 | date |
100%
|
| content |
100%
|
||
| tourism_route_id |
100%
|
||
| tourism_schedule_attractions | 26 | attractions |
100%
|
| description |
100%
|
||
| tourism_schedule_detail_id |
100%
|
||
| tourism_schedule_detail | 53 | time |
96.23%
|
| content |
69.81%
|
||
| tourism_schedule_id |
100%
|
||
| mark |
100%
|
||
| tourism_x_company | 19,746 | 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 |
|---|---|
| 55.46K | 2 |
