Flights

FlightIDDepartureTimeArrivalTimeOriginDestinationAircraftType
108:0010:00JFKLAXBoeing 747
209:0011:00ORDSEAAirbus A320

AccomodationTypes

TypeIDDescription
1Hotel
2Sleep Pod

Accomodations

AccomodationIDAirportIDTypeIDPrice
(→ Flights.FlightID)(→ AccomodationTypes.TypeID)
111150.0
221200.0
312150.0
422200.0

Hotels

HotelIDNameAddressPhoneNumberRating
1Grand Central Airport Hotel1 Grand Central Plaza, New York City+1 212-555-12344.5
2Terminal B HiltonTerminal B, JFK International Airport+1 718-244-60004.0

SleepPods

PodIDLocationOpeningHoursAccessibility
1Lounge AOpen 24/71
2Lounge B06:00 - 22:000

DiningOptions

OptionIDFoodTypeCuisinePriceRange
1BreakfastAmerican10
2DinnerItalian25
3SnackMexican15