FlightID | DepartureTime | ArrivalTime | Origin | Destination | AircraftType |
---|---|---|---|---|---|
1 | 08:00 | 10:00 | JFK | LAX | Boeing 747 |
2 | 09:00 | 11:00 | ORD | SEA | Airbus A320 |
TypeID | Description |
---|---|
1 | Hotel |
2 | Sleep Pod |
AccomodationID | AirportID | TypeID | Price |
---|---|---|---|
(→ Flights.FlightID) | (→ AccomodationTypes.TypeID) | ||
1 | 1 | 1 | 150.0 |
2 | 2 | 1 | 200.0 |
3 | 1 | 2 | 150.0 |
4 | 2 | 2 | 200.0 |
HotelID | Name | Address | PhoneNumber | Rating |
---|---|---|---|---|
1 | Grand Central Airport Hotel | 1 Grand Central Plaza, New York City | +1 212-555-1234 | 4.5 |
2 | Terminal B Hilton | Terminal B, JFK International Airport | +1 718-244-6000 | 4.0 |
PodID | Location | OpeningHours | Accessibility |
---|---|---|---|
1 | Lounge A | Open 24/7 | 1 |
2 | Lounge B | 06:00 - 22:00 | 0 |
OptionID | FoodType | Cuisine | PriceRange |
---|---|---|---|
1 | Breakfast | American | 10 |
2 | Dinner | Italian | 25 |
3 | Snack | Mexican | 15 |