airport

idnamecitycountry
1San Francisco InternationalSan FranciscoUSA
2Los Angeles InternationalLos AngelesUSA
3Dubai InternationalDubaiUAE
4Heathrow AirportLondonUK
5Tokyo HanedaTokyoJapan

terminal

idnamecodecapacityairport_id
(→ airport.id)
1Terminal 1T1301
2Terminal 2T2601
3Terminal 3T3702
4Terminal 4T4902
5Terminal 5T51103

flight

idnumberdatedeparture_timearrival_timeorigin_airport_iddestination_airport_idaircraft_typestatus
(→ airport.id)(→ airport.id)
1AA1232023-01-01 08:0009:0010:0012Boeing 787Operational
2UA4562023-01-01 11:0012:0013:0013Airbus A320Delayed
3KL7892023-01-01 15:0016:0017:0024Boeing 777On Time
4QR1012023-01-01 18:0019:0020:0035Airbus A380Canceled
5EK2462023-01-01 21:0022:0023:0046Boeing 777Operational

medical_facility

idtypesupplieslocationcapacityairport_id
(→ airport.id)
1Medical ClinicBandages and AntisepticsTerminal 1, Gate B12None1
2Medical ClinicIntravenous Fluids and OxygenTerminal 2, Gate C14None1
3First Aid StationBandages and AntisepticsTerminal 3, Gate D16None2
4First Aid StationPain Relief Medications and SplintsTerminal 4, Gate E18None2
5PharmacyPrescription Medications and Over-the-Counter DrugsTerminal 5, Gate F20None3

employee

idfirstnamelastnamerolehire_datesalarydepartment_id
(→ department.id)
1JohnSmithManager2022-01-01750001
2JaneDoeAssistant Manager2022-01-15600001
3MichaelWilliamsSecurity Officer2022-02-01450002
4LauraJacksonHousekeeping Supervisor2022-02-15350003
5DavidMartinezJanitorial Staff2022-03-01250004

department

idnamemanager_id
(→ employee.id)
1Operations1
2Maintenance2
3Customer Service3
4Administration4