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 |