Chalets
Id | Name | Location | Capacity |
1 | Chalet A | Alps | 10 |
2 | Chalet B | Mountains | 8 |
3 | Chalet C | Beachside | 6 |
4 | Chalet D | City Centre | 12 |
5 | Chalet E | Lakeside | 10 |
Cabins
Id | Name | Location | Capacity |
1 | Cabin X | Forest | 4 |
2 | Cabin Y | Desert | 3 |
3 | Cabin Z | Riverbank | 5 |
4 | Cabin W | Coast | 7 |
5 | Cabin V | Hills | 6 |
Accommodations
Id | Type | Price_per_night |
| (→ Chalets.Name) | |
1 | Chalet A | 200.0 |
2 | Chalet B | 300.0 |
3 | Cabin X | 200.0 |
4 | Cabin Y | 300.0 |
5 | Chalet C | 250.0 |
Bookings
Id | Guest_name | CheckIn | CheckOut | Accommodation_id | Total_price |
| | | | (→ Accommodations.Id) | |
1 | John Doe | 2023-01-01 | 2023-01-05 | 1 | None |
2 | Jane Smith | 2023-01-10 | 2023-01-14 | 2 | None |
3 | Michael Johnson | 2023-01-15 | 2023-01-19 | 3 | None |
4 | Emma Wilson | 2023-01-20 | 2023-01-24 | 4 | None |
5 | David Brown | 2023-01-25 | 2023-01-29 | 5 | None |