work_locations
Where people are assigned: a venue, an attraction, a hotel team or a park team. One row is one work location.
- One row is
- one work location
- Columns
- 7
- Rows in Sample
- 159
- Rows in Standard
- 159
- Rows in Full
- 159
This table describes the company, not individual guests, so it is identical in all three sizes.
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| location_idkey | integer | Unique id for the row. | |
| location_name | text | Name. | |
| department_id | integer | Department that staffs it. | |
| venue_id | integer | The venue, when the location is one. Can be empty. | |
| attraction_id | integer | The attraction, when the location is one. Can be empty. | |
| hotel_id | integer | The hotel, for hotel teams. Can be empty. | |
| park_code | text | The park, for locations inside one. Can be empty. | CE; PT; PY |
How it connects
This table points to
- department_id matches departments.department_id
- venue_id matches venues.venue_id
- attraction_id matches attractions.attraction_id
Tables that point here
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| location_id | location_name | department_id | venue_id | attraction_id | hotel_id | park_code |
|---|---|---|---|---|---|---|
| 1 | Lighthouse Mercantile | 3 | 101 | CE | ||
| 2 | Faro Bakery & Coffee | 2 | 102 | CE | ||
| 3 | Lantern Cart | 2 | 103 | CE | ||
| 4 | Abuela's Cocina | 2 | 104 | CE | ||
| 5 | Cuentos Toy Workshop | 3 | 105 | CE |