Airports

idnamecitycountry
1JFKNew York CityUSA
2ATLAtlantaUSA
3LAXLos AngelesUSA
4YYZTorontoCanada
5EWRNewarkUSA

Flights

flightIdsourceAirportdestinationAirportdepartureTimearrivalTime
(→ Airports.id)(→ Airports.id)
1122023-01-01 06:00:002023-01-01 11:00:00
2342023-01-02 07:00:002023-01-02 12:00:00
3132023-01-03 08:00:002023-01-03 13:00:00
4422023-01-04 09:00:002023-01-04 14:00:00
5312023-01-05 10:00:002023-01-05 15:00:00

Aircrafts

aircraftIdmodelNamecapacity
(→ Flights.aircraftId)
1Boeing 787 Dreamliner250
2Airbus A380800
3Bombardier CRJ-90070
4Embraer E190100
5De Havilland Canada Dash 8 Q40078

InflightAmenities

amenityIdaircraftIdonBoardServiceinflightEntertainmentadditionalServices
(→ Aircrafts.aircraftId)
11Onboard Service
22Onboard Service
31Inflight EntertainmentMovies, TV shows, musicWiFi, meals
42Inflight EntertainmentMovies, TV shows, musicWiFi, meals
53Onboard Service
63Inflight EntertainmentMovies, TV shows, musicWiFi, meals