| id | chaletName | pricePerNight | location | capacity |
|---|---|---|---|---|
| 1 | Aurora | 200.0 | Alps | 6 |
| 2 | Sunshine | 300.0 | Beach | 8 |
| 3 | Moonlight | 250.0 | City | 10 |
| 4 | Starlight | 150.0 | Forest | 8 |
| 5 | Dawn | 275.0 | Mountain | 6 |
| id | cabinName | pricePerNight | location | capacity |
|---|---|---|---|---|
| 1 | Lakeshore | 200.0 | Lake | 4 |
| 2 | Riverview | 300.0 | Riverside | 6 |
| 3 | Seaside | 250.0 | Coast | 8 |
| 4 | Woodside | 150.0 | Forest | 4 |
| 5 | Valley | 275.0 | Hills | 6 |
| id | firstname | lastname | phoneNumber | checkIn | checkOut | |
|---|---|---|---|---|---|---|
| 1 | John | Doe | john@gmail.com | 1234567890 | 2022-01-01 10:00:00 | 2022-01-05 15:00:00 |
| 2 | Jane | Smith | jane@gmail.com | 0987654321 | 2022-01-01 15:00:00 | 2022-01-05 10:00:00 |
| 3 | Jack | Brown | jack@gmail.com | 1112223334 | 2022-01-01 12:00:00 | 2022-01-05 11:00:00 |
| 4 | Samantha | White | samantha@gmail.com | 4321123456 | 2022-01-01 13:00:00 | 2022-01-05 12:00:00 |
| 5 | Emma | Black | emma@gmail.com | 3456789123 | 2022-01-01 14:00:00 | 2022-01-05 13:00:00 |
| id | guestId | chaletId | bookingDate | totalCost |
|---|---|---|---|---|
| (→ Guests.id) | (→ Chalets.id) | |||
| 1 | 1 | 1 | 2022-01-01 00:00:00 | 1000.0 |
| 2 | 2 | 2 | 2022-01-01 00:00:00 | 1200.0 |
| 3 | 3 | 3 | 2022-01-01 00:00:00 | 1500.0 |
| 4 | 4 | 4 | 2022-01-01 00:00:00 | 1800.0 |
| 5 | 5 | 5 | 2022-01-01 00:00:00 | 2000.0 |
| id | guestId | chaletId | rating | comment | reviewDate |
|---|---|---|---|---|---|
| (→ Guests.id) | (→ Chalets.id) | ||||
| 1 | 1 | 1 | 5 | Great stay! | 2022-01-01 00:00:00 |
| 2 | 2 | 2 | 4 | Good experience! | 2022-01-01 00:00:00 |
| 3 | 3 | 3 | 3 | Fine, could have been better. | 2022-01-01 00:00:00 |
| 4 | 4 | 4 | 5 | Excellent service! | 2022-01-01 00:00:00 |
| 5 | 5 | 5 | 4 | Good value for money. | 2022-01-01 00:00:00 |