| 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 |