Languages

idlanguage
1English
2French
3German
4Japanese
5Russian

Pilots

idnamelicenseNumberspeaksId
(→ Languages.id)
1John Doe12345678901
2Mary Smith9876543212
3Alice Johnson55555555553
4Bob Brown44444444444
5Charlie Green33333333335

GateAgents

idnamegateNumberspeaksId
(→ Languages.id)
1Paul WhiteA11
2Tom BlackC52
3Lucy BlueD123
4Kelly RedE144
5Hannah PinkF205

Flights

flightNumberdepartureTimearrivalTimepilotIdgateAgentId
(→ Pilots.id)(→ GateAgents.id)
1012022-01-01 08:002022-01-01 10:0011
1022022-01-01 09:002022-01-01 11:0022
1032022-01-01 10:002022-01-01 12:0033
1042022-01-01 11:002022-01-01 13:0044
1052022-01-01 12:002022-01-01 14:0055

Passengers

passengerIdfirstNamelastNameage
1AlexanderSmith25
2EmmaWilliams30
3DavidJones40
4DanielBlack50
5LauraWhite60