Airports

idnamecountrycity
1HeathrowUKLondon
2SchipholNetherlandsAmsterdam

Airlines

idnameheadquartered_at
(→ Airports.id)
1BA1
2KLM2

Aircrafts

idmodelmax_passengersmax_rangeairline_id
(→ Airlines.id)
1Boeing 787 Dreamliner30076391
2Airbus A38052580002

OnboardServices

idservice_namedescriptionaircraft_id
(→ Aircrafts.id)
1Meal ServiceA variety of meals served on board.1
2Snack ServiceLight snacks available for purchase.2

InflightEntertainments

identertainment_namedescriptionaircraft_id
(→ Aircrafts.id)
1Movie SelectionWide range of movies available for viewing.1
2Games LibraryVariety of games available for play.2