id | name | location |
---|---|---|
1 | Facility1 | Location1 |
2 | Facility2 | Location2 |
3 | Facility3 | Location3 |
4 | Facility4 | Location4 |
5 | Facility5 | Location5 |
equipmentId | type |
---|---|
1 | Jet_Bridge |
2 | Luggage_Conveyor |
3 | Security_Scanner |
4 | Aircraft_Tow_Vehicle |
5 | Passenger_Board_bridge |
maintenanceId | equipmentTypeId |
---|---|
(→ Maintenance_Facilities.id) | (→ Equipment.equipmentId) |
1 | 1 |
1 | 2 |
2 | 3 |
2 | 4 |
3 | 1 |
3 | 5 |
4 | 2 |
4 | 6 |
5 | 3 |
5 | 7 |
2 | 1 |
4 | 1 |
5 | 1 |