Customs

idAirportCustomOfficerNameCustomOfficePhoneNumberOpeningHours
1GatwickJohn Doe123456789006:00 - 22:00
2HeathrowJane Smith098765432106:30 - 21:30
3StanstedAlice Brown112233445507:00 - 21:00
4LutonBob Johnson223344556606:00 - 22:00
5ManchesterCharlie White334455667706:30 - 21:30

Immigration

idAirportImmigrationOfficerNameImmigrationOfficePhoneNumberOpeningHours
1GatwickMichael Black135792468006:00 - 22:00
2HeathrowEmma Green098765432106:30 - 21:30
3StanstedDavid Blue112233445507:00 - 21:00
4LutonNathan Red223344556606:00 - 22:00
5ManchesterSimon Yellow334455667706:30 - 21:30

Runway

idAirportLengthWidthSurfaceType
1Gatwick3000.045.0Asphalt
2Heathrow3200.060.0Concrete
3Stansted2800.040.0Asphalt
4Luton2500.035.0Asphalt
5Manchester3100.050.0Concrete

Terminal

idAirportNameNumberOfDoorsFacilities
1GatwickTerminal A10Shops, Restaurants, Baggage Claim
2HeathrowTerminal 215Duty Free Shops, Lounge, Currency Exchange
3StanstedTerminal 18Cafes, Information Desk, Baby Changing Rooms
4LutonMain Terminal6ATMs, Lost & Found, Car Rental
5ManchesterTerminal 112WiFi, Parking, Disabled Access

Flight

idDepartureTimeArrivalTimeDestinationAirportPlaneId
(→ Aircraft.id)
12023-04-01 08:00:002023-04-01 11:00:00New York1
22023-04-01 10:00:002023-04-01 13:00:00Los Angeles2
32023-04-01 12:00:002023-04-01 15:00:00Paris3
42023-04-01 14:00:002023-04-01 17:00:00Tokyo4
52023-04-01 16:00:002023-04-01 19:00:00Rome5

Aircraft

idModelCapacityRegistrationNumberManufacturer
1Boeing 747-400400G-BNACBoeing
2Airbus A380800G-KBJSAirbus
3Bombardier CRJ-1000100EI-EEEBombardier
4Embraer E190100PS-AMZEmbraer
5AIRBUS A320180VQ-BEAAirbus