| Id | Name | Location |
|---|---|---|
| 1 | New York JFK | USA |
| 2 | London Heathrow | UK |
| 3 | Tokyo Haneda | Japan |
| ClinicId | AirportId | Name |
|---|---|---|
| (→ Airports.Id) | ||
| 1 | 1 | JFK Health Center |
| 2 | 2 | Heathrow Medical Services |
| 3 | 3 | Haneda Medical Point |
| StationId | AirportId | Name |
|---|---|---|
| (→ Airports.Id) | ||
| 1 | 1 | Terminal 1 First Aid |
| 2 | 2 | Terminal 3 First Aid |
| 3 | 3 | International Terminal First Aid |
| SuppliesId | Description | Quantity |
|---|---|---|
| 1 | Bandages and Antiseptics | 100 |
| 2 | Intravenous Fluids | 75 |
| 3 | Oxygen Masks | 50 |
| 4 | Defibrillators | 25 |
| 5 | Emergency Blankets | 100 |
| ClinicSuppliesId | ClinicId | SuppliesId | Amount |
|---|---|---|---|
| (→ Medical_Clinics.ClinicId) | (→ Medical_Supplies.SuppliesId) | ||
| 1 | 1 | 1 | 50 |
| 2 | 1 | 2 | 25 |
| 3 | 2 | 1 | 60 |
| 4 | 2 | 2 | 30 |
| 5 | 3 | 1 | 80 |
| 6 | 3 | 2 | 40 |
| AidStationSuppliesId | StationId | SuppliesId | Amount |
|---|---|---|---|
| (→ First_Aid_Stations.StationId) | (→ Medical_Supplies.SuppliesId) | ||
| 1 | 1 | 1 | 30 |
| 2 | 1 | 2 | 15 |
| 3 | 2 | 1 | 40 |
| 4 | 2 | 2 | 20 |
| 5 | 3 | 1 | 50 |
| 6 | 3 | 2 | 25 |