Guests

idfirstNamelastNameemailAddress
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3AliceBrownalice.brown@example.com
4BobGreenbob.green@example.com
5CharlieBlackcharlie.black@example.com

Reservations

reservationIdguestIDcheckInDatecheckOutDateovernightStaysamenities
(→ Guests.id)
112023-01-012023-01-03GuestroomAir Conditioning
222023-01-062023-01-08GuestroomNo Air Conditioning
332023-01-102023-01-12SuiteAir Conditioning
442023-01-132023-01-15SuiteNo Air Conditioning
552023-01-172023-01-19GuestroomNo Air Conditioning

Rooms

roomNumbertypeOfRoompricePerNight
1Standard Room100
2Deluxe Suite200
3Premium Suite300
4Family Suite250
5Executive Suite400

Bookings

bookingIdreservationIdroomNumber
(→ Reservations.reservationId)(→ Rooms.roomNumber)
111
222
333
444
555

Reviews

reviewIdbookingIdratingcomments
(→ Bookings.bookingId)
115Great stay! Very clean.
224The suite was nice but a bit expensive.
335Loved it! Perfect location.
444Good experience overall.
553Not what I expected.