64 tables, 10 business areas
Every table links to at least one other. Guest tables shrink with the dataset size. Company tables, such as the ledger and the staff schedule, are the same in all three.
- Reference
- Guests and trips
- In the park
- Spending
- Feedback
- Workforce
- Operations
- Marketing and events
- IT
- Finance
Reference
| Table | One row is | Columns | Rows in Full | Rows in Sample |
|---|---|---|---|---|
| calendar | one day | 15 | 2,922 | 2,922 |
| parks | one park | 5 | 3 | 3 |
| park_hours | one park on one day | 6 | 8,766 | 8,766 |
| lands | one land | 4 | 15 | 15 |
| attractions | one attraction | 12 | 49 | 49 |
| hotels | one hotel | 6 | 4 | 4 |
| room_types | one room type at one hotel | 4 | 12 | 12 |
| pass_products | one pass product | 6 | 5 | 5 |
| weather_hourly | one hour | 7 | 70,128 | 70,128 |
Guests and trips
| Table | One row is | Columns | Rows in Full | Rows in Sample |
|---|---|---|---|---|
| households | one household | 10 | 1,002,509 | 10,026 |
| guests | one person | 4 | 3,648,415 | 36,308 |
| bookings | one trip | 16 | 1,955,497 | 19,324 |
| hotel_stays | one room stay | 9 | 1,015,512 | 10,235 |
| tickets | one ticket | 9 | 7,063,649 | 69,206 |
| annual_passes | one pass for one year | 9 | 206,991 | 2,300 |
| park_entries | one person entering one park on one day | 9 | 19,581,106 | 195,989 |
| express_purchases | one purchase for one park day | 9 | 333,335 | 3,294 |
| return_vouchers | one voucher | 7 | 125,724 | 1,227 |
In the park
| Table | One row is | Columns | Rows in Full | Rows in Sample |
|---|---|---|---|---|
| ride_events | one person on one ride | 8 | 117,255,655 | 1,166,930 |
| wait_snapshots | one attraction at one quarter hour | 4 | 4,370,700 | 4,370,700 |
| ride_downtime | one closure | 6 | 18,785 | 18,785 |
| dining_reservations | one reservation | 8 | 1,432,524 | 14,623 |
Spending
| Table | One row is | Columns | Rows in Full | Rows in Sample |
|---|---|---|---|---|
| venues | one venue | 8 | 72 | 72 |
| suppliers | one supplier | 3 | 12 | 12 |
| products | one product | 8 | 367 | 367 |
| product_prices | one price for one product over a date range | 4 | 2,569 | 2,569 |
| category_code_map | one legacy category code | 7 | 16 | 16 |
| transactions | one sale | 16 | 21,438,303 | 214,462 |
| transaction_lines | one product on one sale | 7 | 75,761,789 | 759,979 |
| refunds | one request | 12 | 124,826 | 1,216 |
| refund_events | one step of one request | 5 | 461,808 | 4,517 |
| promotions | one promotion window | 7 | 6 | 6 |
| experiment_assignments | one household in the test | 4 | 32,249 | 308 |
Feedback
| Table | One row is | Columns | Rows in Full | Rows in Sample |
|---|---|---|---|---|
| survey_responses | one completed survey | 9 | 333,574 | 3,317 |
| survey_day_ratings | one park day on one survey | 10 | 694,133 | 6,943 |
| complaints | one complaint | 15 | 64,966 | 667 |
Workforce
| Table | One row is | Columns | Rows in Full | Rows in Sample |
|---|---|---|---|---|
| departments | one department | 2 | 15 | 15 |
| positions | one position | 5 | 47 | 47 |
| work_locations | one work location | 7 | 159 | 159 |
| employees | one employee | 10 | 17,007 | 17,007 |
| employment_history | one period at one pay rate | 8 | 47,804 | 47,804 |
| shifts | one person's shift on one day | 8 | 3,490,509 | 3,490,509 |
| payroll | one person's pay for one period | 7 | 494,485 | 494,485 |
| training_courses | one course | 3 | 8 | 8 |
| training_completions | one person finishing one course | 5 | 44,222 | 44,222 |
Operations
| Table | One row is | Columns | Rows in Full | Rows in Sample |
|---|---|---|---|---|
| inventory_items | one stock item | 7 | 154 | 154 |
| product_ingredients | one stock item in one product | 3 | 643 | 643 |
| purchase_orders | one order | 6 | 9,689 | 9,689 |
| purchase_order_lines | one stock item on one order | 6 | 81,350 | 81,350 |
| inventory_daily | one stock item on one day | 7 | 449,988 | 449,988 |
| work_orders | one job | 15 | 64,541 | 64,541 |
| safety_incidents | one incident | 13 | 19,963 | 19,963 |
Marketing and events
| Table | One row is | Columns | Rows in Full | Rows in Sample |
|---|---|---|---|---|
| campaigns | one campaign | 8 | 78 | 78 |
| campaign_audience | one household in one campaign | 6 | 2,991,726 | 29,722 |
| booking_attribution | one booking | 3 | 1,955,497 | 19,324 |
| events | one event | 8 | 136 | 136 |
| event_registrations | one household at one event | 6 | 63,327 | 603 |
IT
| Table | One row is | Columns | Rows in Full | Rows in Sample |
|---|---|---|---|---|
| it_systems | one system | 3 | 10 | 10 |
| it_tickets | one ticket | 12 | 35,859 | 35,859 |
| change_requests | one change | 10 | 1,726 | 1,726 |
| it_incidents | one incident | 7 | 487 | 487 |
Finance
| Table | One row is | Columns | Rows in Full | Rows in Sample |
|---|---|---|---|---|
| gl_accounts | one account | 3 | 32 | 32 |
| gl_entries | one line of one journal | 9 | 97,712 | 97,712 |
| budgets | one account and department in one month | 5 | 4,608 | 4,608 |