Guestrooms

idroom_numberfloor_nocapacityamenities
1G00123Air Conditioning
2G00234WiFi Access
3G00312Parking Facility

Suites

idsuite_namearea_sqftoccupancyamenities
1Presidential Suite20006Air Conditioning
2Deluxe Suite8004WiFi Access

Reservations

reservation_idguest_namecheckincheckoutroom_typetotal_cost
1John Doe2022-09-012022-09-07Guestroom500.0
2Jane Smith2022-09-152022-09-20Guestroom700.0
3Alice Johnson2022-09-252022-09-30Suite1000.0

Employees

employee_idnameroledepartmenthire_date
1Mike BrownHousekeeping SupervisorHousekeeping2021-07-15
2Emily WhiteFront Desk ManagerReception2021-06-01
3David GreenMaintenance TechnicianEngineering2021-05-15

GuestReviews

review_idguest_nameratingcomments
1Tom Lee5Excellent service and clean rooms.
2Karen Kim4Nice location but could use some updates.
3Paul Wang3Good experience overall but had a minor issue with WiFi.

FoodMenu

menu_item_iditem_namedescriptionprice
1SteakGrilled steak served with vegetables.25.0
2Seafood PlatterAssorted seafood with lemon butter sauce.30.0
3Veggie PizzaThick crust pizza loaded with vegetables.15.0