| id | name | city | country |
|---|---|---|---|
| 1 | JFK | New York City | USA |
| 2 | ATL | Atlanta | USA |
| 3 | LAX | Los Angeles | USA |
| 4 | YYZ | Toronto | Canada |
| 5 | EWR | Newark | USA |
| flightId | sourceAirport | destinationAirport | departureTime | arrivalTime |
|---|---|---|---|---|
| (→ Airports.id) | (→ Airports.id) | |||
| 1 | 1 | 2 | 2023-01-01 06:00:00 | 2023-01-01 11:00:00 |
| 2 | 3 | 4 | 2023-01-02 07:00:00 | 2023-01-02 12:00:00 |
| 3 | 1 | 3 | 2023-01-03 08:00:00 | 2023-01-03 13:00:00 |
| 4 | 4 | 2 | 2023-01-04 09:00:00 | 2023-01-04 14:00:00 |
| 5 | 3 | 1 | 2023-01-05 10:00:00 | 2023-01-05 15:00:00 |
| aircraftId | modelName | capacity |
|---|---|---|
| (→ Flights.aircraftId) | ||
| 1 | Boeing 787 Dreamliner | 250 |
| 2 | Airbus A380 | 800 |
| 3 | Bombardier CRJ-900 | 70 |
| 4 | Embraer E190 | 100 |
| 5 | De Havilland Canada Dash 8 Q400 | 78 |
| amenityId | aircraftId | onBoardService | inflightEntertainment | additionalServices |
|---|---|---|---|---|
| (→ Aircrafts.aircraftId) | ||||
| 1 | 1 | Onboard Service | ||
| 2 | 2 | Onboard Service | ||
| 3 | 1 | Inflight Entertainment | Movies, TV shows, music | WiFi, meals |
| 4 | 2 | Inflight Entertainment | Movies, TV shows, music | WiFi, meals |
| 5 | 3 | Onboard Service | ||
| 6 | 3 | Inflight Entertainment | Movies, TV shows, music | WiFi, meals |