hotelID | name | address | city |
---|---|---|---|
1 | The Ritz | 123 Main St. | New York |
2 | Hilton Garden Inn | 456 Elm St. | Chicago |
roomID | hotelID | type | price |
---|---|---|---|
(→ Hotel.hotelID) | |||
1 | 1 | Luxury Suite | 300.0 |
2 | 1 | Standard Room | 150.0 |
3 | 2 | Deluxe Room | 200.0 |
4 | 2 | Economy Room | 100.0 |
amenityID | description |
---|---|
1 | Swimming pool with sun loungers |
2 | Fitness center with sauna and steam rooms |
featureID | amenityID | Leisure_Features | City |
---|---|---|---|
(→ Amenity.amenityID) | |||
1 | 1 | Swimming Pool | Miami |
2 | 2 | Swimming Pool | Los Angeles |
3 | 1 | Hot Tub | Miami |
4 | 2 | Hot Tub | Dallas |
bookingID | customerName | checkInDate | checkOutDate | roomID |
---|---|---|---|---|
(→ Room.roomID) | ||||
1 | John Doe | 2022-09-01 | 2022-09-07 | 1 |
2 | Jane Smith | 2022-08-15 | 2022-08-21 | 2 |