id | name | capacity |
---|---|---|
1 | Grand Voyager | 2000 |
2 | Ocean Explorer | 3500 |
3 | Atlantic Adventurer | 2800 |
4 | Caribbean Princess | 3600 |
5 | Aurora Borealis | 4000 |
id | facilityName | isAvailable |
---|---|---|
1 | Dining Hall | 1 |
2 | Swimming Pool | 0 |
3 | Gymnasium | 1 |
4 | Theatre | 0 |
5 | Arcade | 1 |
cruiseShipId | facilityId |
---|---|
(→ Cruise_Ships.id) | (→ Facilities.id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 4 |