id | name | location |
---|---|---|
1 | The Ritz | London |
2 | Le Royal Monceau | Paris |
3 | Grand Hyatt | New York |
4 | Hilton Tokyo | Tokyo |
5 | Four Seasons | Dubai |
amenityId | amenityName |
---|---|
1 | Spa |
2 | Gym |
3 | Pool |
4 | Restaurant |
5 | Bar |
hotelId | amenityId |
---|---|
(→ Hotels.id) | (→ Amenities.amenityId) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 4 |