Chalets

idchaletNamepricePerNightlocationcapacity
1Aurora200.0Alps6
2Sunshine300.0Beach8
3Moonlight250.0City10
4Starlight150.0Forest8
5Dawn275.0Mountain6

Cabins

idcabinNamepricePerNightlocationcapacity
1Lakeshore200.0Lake4
2Riverview300.0Riverside6
3Seaside250.0Coast8
4Woodside150.0Forest4
5Valley275.0Hills6

Guests

idfirstnamelastnameemailphoneNumbercheckIncheckOut
1JohnDoejohn@gmail.com12345678902022-01-01 10:00:002022-01-05 15:00:00
2JaneSmithjane@gmail.com09876543212022-01-01 15:00:002022-01-05 10:00:00
3JackBrownjack@gmail.com11122233342022-01-01 12:00:002022-01-05 11:00:00
4SamanthaWhitesamantha@gmail.com43211234562022-01-01 13:00:002022-01-05 12:00:00
5EmmaBlackemma@gmail.com34567891232022-01-01 14:00:002022-01-05 13:00:00

Bookings

idguestIdchaletIdbookingDatetotalCost
(→ Guests.id)(→ Chalets.id)
1112022-01-01 00:00:001000.0
2222022-01-01 00:00:001200.0
3332022-01-01 00:00:001500.0
4442022-01-01 00:00:001800.0
5552022-01-01 00:00:002000.0

Reviews

idguestIdchaletIdratingcommentreviewDate
(→ Guests.id)(→ Chalets.id)
1115Great stay!2022-01-01 00:00:00
2224Good experience!2022-01-01 00:00:00
3333Fine, could have been better.2022-01-01 00:00:00
4445Excellent service!2022-01-01 00:00:00
5554Good value for money.2022-01-01 00:00:00