Airports

idnamecitycountry
1JFK InternationalNew YorkUSA
2HeathrowLondonUK
3Charles de GaulleParisFrance
4Hong Kong InternationalHong KongChina
5Tokyo HanedaTokyoJapan

Terminals

idairportIdterminalNumber
(→ Airports.id)
113
225
332
442
551

Airlines

idnameheadQuarters
1British AirwaysUK
2American AirlinesUS
3Air FranceFrance
4Cathay PacificHong Kong
5All Nippon AirwaysJapan

Flights

flightNumberairlineIddepartureTerminalIdarrivalTerminalId
(→ Airlines.id)(→ Terminals.id)(→ Terminals.id)
101112
202235
303324
404411
505553

Medical_Facilities

facilityNametypesupplies
Medical ClinicHealthcareNone
First Aid StationEmergency CareNone
PharmacyDrugstoreNone
Physiotherapy CenterRehabilitationNone
Mental Health ClinicPsychiatryNone

Medical_Supplies

supplyNamedescription
Bandages and AntisepticsUsed to clean and cover wounds.
Intravenous DripDelivers fluids, electrolytes, medications, etc., directly into a vein.
Oxygen MaskDevice that provides oxygen during emergencies.
Defibrillator PadsUsed to deliver an electric shock to restore normal heart rhythm.
StethoscopeA tool used to listen to internal sounds made by the body.

FacilitySupplies

facilityNamesupplyName
(→ Medical_Facilities.facilityName)(→ Medical_Supplies.supplyName)
Medical ClinicBandages and Antiseptics
Medical ClinicIntravenous Drip
First Aid StationBandages and Antiseptics
First Aid StationOxygen Mask
PharmacyDefibrillator Pads
PharmacyStethoscope