## Airports

id | name | city | country
--- | --- | --- | ---
1 | JFK International | New York | USA
2 | Heathrow | London | UK
3 | Charles de Gaulle | Paris | France
4 | Hong Kong International | Hong Kong | China
5 | Tokyo Haneda | Tokyo | Japan

## Terminals

id | airportId | terminalNumber
--- | --- | ---
| (→ Airports.id) |
1 | 1 | 3
2 | 2 | 5
3 | 3 | 2
4 | 4 | 2
5 | 5 | 1

## Airlines

id | name | headQuarters
--- | --- | ---
1 | British Airways | UK
2 | American Airlines | US
3 | Air France | France
4 | Cathay Pacific | Hong Kong
5 | All Nippon Airways | Japan

## Flights

flightNumber | airlineId | departureTerminalId | arrivalTerminalId
--- | --- | --- | ---
| (→ Airlines.id) | (→ Terminals.id) | (→ Terminals.id)
101 | 1 | 1 | 2
202 | 2 | 3 | 5
303 | 3 | 2 | 4
404 | 4 | 1 | 1
505 | 5 | 5 | 3

## Medical_Facilities

facilityName | type | supplies
--- | --- | ---
Medical Clinic | Healthcare | None
First Aid Station | Emergency Care | None
Pharmacy | Drugstore | None
Physiotherapy Center | Rehabilitation | None
Mental Health Clinic | Psychiatry | None

## Medical_Supplies

supplyName | description
--- | ---
Bandages and Antiseptics | Used to clean and cover wounds.
Intravenous Drip | Delivers fluids, electrolytes, medications, etc., directly into a vein.
Oxygen Mask | Device that provides oxygen during emergencies.
Defibrillator Pads | Used to deliver an electric shock to restore normal heart rhythm.
Stethoscope | A tool used to listen to internal sounds made by the body.

## FacilitySupplies

facilityName | supplyName
--- | ---
(→ Medical_Facilities.facilityName) | (→ Medical_Supplies.supplyName)
Medical Clinic | Bandages and Antiseptics
Medical Clinic | Intravenous Drip
First Aid Station | Bandages and Antiseptics
First Aid Station | Oxygen Mask
Pharmacy | Defibrillator Pads
Pharmacy | Stethoscope