id | name | type |
---|---|---|
1 | Mountain Chalet | Chalet |
2 | Lakeside Cabin | Cabin |
3 | River View Lodge | Chalet |
4 | Forest Hut | Cabin |
5 | Beach Bungalow | Chalet |
accommodationId | price_per_night |
---|---|
(→ Accomodations.id) | |
1 | 200.0 |
1 | 300.0 |
2 | 200.0 |
2 | 300.0 |
3 | 200.0 |
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 |
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 |