Skip to content

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

TableOne row isColumnsRows in FullRows in Sample
calendarone day152,9222,922
parksone park533
park_hoursone park on one day68,7668,766
landsone land41515
attractionsone attraction124949
hotelsone hotel644
room_typesone room type at one hotel41212
pass_productsone pass product655
weather_hourlyone hour770,12870,128

Guests and trips

TableOne row isColumnsRows in FullRows in Sample
householdsone household101,002,50910,026
guestsone person43,648,41536,308
bookingsone trip161,955,49719,324
hotel_staysone room stay91,015,51210,235
ticketsone ticket97,063,64969,206
annual_passesone pass for one year9206,9912,300
park_entriesone person entering one park on one day919,581,106195,989
express_purchasesone purchase for one park day9333,3353,294
return_vouchersone voucher7125,7241,227

In the park

TableOne row isColumnsRows in FullRows in Sample
ride_eventsone person on one ride8117,255,6551,166,930
wait_snapshotsone attraction at one quarter hour44,370,7004,370,700
ride_downtimeone closure618,78518,785
dining_reservationsone reservation81,432,52414,623

Spending

TableOne row isColumnsRows in FullRows in Sample
venuesone venue87272
suppliersone supplier31212
productsone product8367367
product_pricesone price for one product over a date range42,5692,569
category_code_mapone legacy category code71616
transactionsone sale1621,438,303214,462
transaction_linesone product on one sale775,761,789759,979
refundsone request12124,8261,216
refund_eventsone step of one request5461,8084,517
promotionsone promotion window766
experiment_assignmentsone household in the test432,249308

Feedback

TableOne row isColumnsRows in FullRows in Sample
survey_responsesone completed survey9333,5743,317
survey_day_ratingsone park day on one survey10694,1336,943
complaintsone complaint1564,966667

Workforce

TableOne row isColumnsRows in FullRows in Sample
departmentsone department21515
positionsone position54747
work_locationsone work location7159159
employeesone employee1017,00717,007
employment_historyone period at one pay rate847,80447,804
shiftsone person's shift on one day83,490,5093,490,509
payrollone person's pay for one period7494,485494,485
training_coursesone course388
training_completionsone person finishing one course544,22244,222

Operations

TableOne row isColumnsRows in FullRows in Sample
inventory_itemsone stock item7154154
product_ingredientsone stock item in one product3643643
purchase_ordersone order69,6899,689
purchase_order_linesone stock item on one order681,35081,350
inventory_dailyone stock item on one day7449,988449,988
work_ordersone job1564,54164,541
safety_incidentsone incident1319,96319,963

Marketing and events

TableOne row isColumnsRows in FullRows in Sample
campaignsone campaign87878
campaign_audienceone household in one campaign62,991,72629,722
booking_attributionone booking31,955,49719,324
eventsone event8136136
event_registrationsone household at one event663,327603

IT

TableOne row isColumnsRows in FullRows in Sample
it_systemsone system31010
it_ticketsone ticket1235,85935,859
change_requestsone change101,7261,726
it_incidentsone incident7487487

Finance

TableOne row isColumnsRows in FullRows in Sample
gl_accountsone account33232
gl_entriesone line of one journal997,71297,712
budgetsone account and department in one month54,6084,608