Borders

IDCustomsImmigrationOtherValuesAirportName
(→ Airports.Name)
1CustomsImmigrationNoneGatwick
2CustomsImmigrationNoneHeathrow
3ImmigrationCustomsNoneGatwick
4ImmigrationCustomsNoneStansted

Airports

NameCityCountry
GatwickLondonUK
HeathrowLondonUK
StanstedEssexUK
Charles de GaulleParisFrance
Dubai InternationalDubaiUAE

Planes

RegistrationNumberModelCapacityHomeAirportName
(→ Airports.Name)
ABCD1234A380400Gatwick
EFGH5678Boeing777350Heathrow
JKLZ9012A320200Stansted
MNOQ2345A320200Charles de Gaulle
PSTUV8901Boeing747400Dubai International

Passengers

FirstNameLastNameNationalityFlightRegistrationNumber
(→ Planes.RegistrationNumber)
John DoeSmithUSAABCD1234
Jane SmithJonesCanadaEFGH5678
Emily JohnsonWhiteAustraliaJKLZ9012
David BrownBlackNew ZealandMNOQ2345
Lucy GreenYellowUKPSTUV8901