## Accomodations

id | name | type
--- | --- | ---
1 | Mountain Chalet | Chalet
2 | Lakeside Cabin | Cabin
3 | River View Lodge | Chalet
4 | Forest Hut | Cabin
5 | Beach Bungalow | Chalet

## Prices

accommodationId | price_per_night
--- | ---
(→ Accomodations.id) |
1 | 200.0
1 | 300.0
2 | 200.0
2 | 300.0
3 | 200.0

## Guests

id | firstName | lastName | emailAddress
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com
3 | Michael | Brown | michael.brown@example.com
4 | Emily | White | emily.white@example.com
5 | David | Black | david.black@example.com

## Reservations

reservationId | guestId | accommodationId | checkInDate | checkOutDate | totalCost
--- | --- | --- | --- | --- | ---
| (→ Guests.id) | (→ Accomodations.id) |  |  |
1 | 1 | 1 | 2022-10-01 | 2022-10-07 | 1200.0
2 | 2 | 1 | 2022-10-14 | 2022-10-21 | 1800.0
3 | 3 | 2 | 2022-10-01 | 2022-10-07 | 1600.0
4 | 4 | 2 | 2022-10-14 | 2022-10-21 | 2000.0
5 | 5 | 3 | 2022-10-01 | 2022-10-07 | 900.0