Passengers

passengerIDfirstNamelastNameage
1JohnDoe35
2JaneSmith28
3AliceBrown40
4MikeWhite22
5EmmaGreen30

Flights

flightIDdepartureTimearrivalTimeoriginAirportdestinationAirport
12022-11-29 08:00:002022-11-29 10:00:00HeathrowGatwick
22022-11-29 12:00:002022-11-29 14:00:00GatwickStansted
32022-11-29 16:00:002022-11-29 18:00:00StanstedLuton
42022-11-30 07:00:002022-11-30 09:00:00HeathrowGatwick
52022-11-30 11:00:002022-11-30 13:00:00GatwickStansted

Border_Controls

controlIDborderTypeairportID
(→ Airports.airportID)
1Customs1
2Customs3
3Immigration1
4Immigration3
5Security Check2

Airports

airportIDairportNamecitycountry
1HeathrowLondonUK
2GatwickLondonUK
3StanstedLondonUK
4LutonLondonUK