| 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 |