## Guestrooms

id | room_number | floor_no | capacity | amenities
--- | --- | --- | --- | ---
1 | G001 | 2 | 3 | Air Conditioning
2 | G002 | 3 | 4 | WiFi Access
3 | G003 | 1 | 2 | Parking Facility

## Suites

id | suite_name | area_sqft | occupancy | amenities
--- | --- | --- | --- | ---
1 | Presidential Suite | 2000 | 6 | Air Conditioning
2 | Deluxe Suite | 800 | 4 | WiFi Access

## Reservations

reservation_id | guest_name | checkin | checkout | room_type | total_cost
--- | --- | --- | --- | --- | ---
1 | John Doe | 2022-09-01 | 2022-09-07 | Guestroom | 500.0
2 | Jane Smith | 2022-09-15 | 2022-09-20 | Guestroom | 700.0
3 | Alice Johnson | 2022-09-25 | 2022-09-30 | Suite | 1000.0

## Employees

employee_id | name | role | department | hire_date
--- | --- | --- | --- | ---
1 | Mike Brown | Housekeeping Supervisor | Housekeeping | 2021-07-15
2 | Emily White | Front Desk Manager | Reception | 2021-06-01
3 | David Green | Maintenance Technician | Engineering | 2021-05-15

## GuestReviews

review_id | guest_name | rating | comments
--- | --- | --- | ---
1 | Tom Lee | 5 | Excellent service and clean rooms.
2 | Karen Kim | 4 | Nice location but could use some updates.
3 | Paul Wang | 3 | Good experience overall but had a minor issue with WiFi.

## FoodMenu

menu_item_id | item_name | description | price
--- | --- | --- | ---
1 | Steak | Grilled steak served with vegetables. | 25.0
2 | Seafood Platter | Assorted seafood with lemon butter sauce. | 30.0
3 | Veggie Pizza | Thick crust pizza loaded with vegetables. | 15.0