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 |
id | airportId | terminalNumber |
---|---|---|
(→ Airports.id) | ||
1 | 1 | 3 |
2 | 2 | 5 |
3 | 3 | 2 |
4 | 4 | 2 |
5 | 5 | 1 |
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 |
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 |
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 |
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. |
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 |