这是一个来自中国国内23个省份，797个公司的66,802个组团旅游信息数据库。每个组团旅游信息记录中包含有旅游信息描述和类型。在组团旅游数据中有185个旅游目的地和90个出发城市。除此之外，组团旅游数据中还有16个旅游图片且储存在98.81K的媒体文件夹中；6个旅游内容及详情；3个旅游特色及内容；1个旅游路线及名称和5个旅游时间表且每个时间表中有日期，内容和旅游路线。该组团旅游信息数据库共有16个表。
This is a domestic group travel database with 66,802 records from 797 companies of 23 provinces in China. Each tourism record consists of description and type. It has 185 destinations and 90 departure cities in these group travel data. In the whole domestic tourism database, there are 6 tables most related with these group travel, they are 16 travel photos keeped in 98.81K media set；6 tourism content with detail records；3 tourism feature with content in each；1 tourism route with name; 5 tourism schedule records with date, content & tourism route in each and 5 tourism schedule attractions.
The whole China's domestic tourism data set has 16 tables.
| Name | n3_lyz_vacations.ctrip.com_grouptravel |
|---|---|
| Data | 60.70M (+ 0B) |
| Tables | 16 (+ 0) |
| Columns | 75 (+ 0) |
| Table Rows | 198,770 (+ 0) |
| Media | 98.81K (+ 0B) |
| Files | 3 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| company | 797 | company |
99.87%
|
| departure_city | 90 | tourism_id |
100%
|
| city |
100%
|
||
| price_from |
100%
|
||
| destination | 185 | destination |
100%
|
| region_id |
100%
|
||
| destination_x_tourism | 66,802 | destination_id |
100%
|
| tourism_id |
100%
|
||
| image_slug | 16 | tourism_id |
100%
|
| title |
100%
|
||
| region | 23 | region |
100%
|
| tourism | 66,802 | title |
100%
|
| description |
0%
|
||
| type |
100%
|
||
| tourism_content | 6 | content |
100%
|
| detail |
16.67%
|
||
| tourism_route_id |
100%
|
||
| tourism_feature | 3 | content |
100%
|
| tourism_id |
100%
|
||
| tourism_route | 1 | route_name |
100%
|
| tourism_id |
100%
|
||
| tourism_schedule | 5 | date |
100%
|
| content |
100%
|
||
| tourism_route_id |
100%
|
||
| tourism_schedule_attractions | 5 | attractions |
100%
|
| description |
100%
|
||
| tourism_schedule_detail_id |
100%
|
||
| tourism_schedule_detail | 0 | time |
0%
|
| content |
0%
|
||
| tourism_schedule_id |
0%
|
||
| tourism_summary | 0 | content |
0%
|
| tourism_id |
0%
|
||
| tourism_x_company | 64,035 | 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 |
|---|---|
| 98.81K | 3 |
