Accomodations

idnametype
1Mountain ChaletChalet
2Lakeside CabinCabin
3River View LodgeChalet
4Forest HutCabin
5Beach BungalowChalet

Prices

accommodationIdprice_per_night
(→ Accomodations.id)
1200.0
1300.0
2200.0
2300.0
3200.0

Guests

idfirstNamelastNameemailAddress
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3MichaelBrownmichael.brown@example.com
4EmilyWhiteemily.white@example.com
5DavidBlackdavid.black@example.com

Reservations

reservationIdguestIdaccommodationIdcheckInDatecheckOutDatetotalCost
(→ Guests.id)(→ Accomodations.id)
1112022-10-012022-10-071200.0
2212022-10-142022-10-211800.0
3322022-10-012022-10-071600.0
4422022-10-142022-10-212000.0
5532022-10-012022-10-07900.0