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 |