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 |
id | suite_name | area_sqft | occupancy | amenities |
---|---|---|---|---|
1 | Presidential Suite | 2000 | 6 | Air Conditioning |
2 | Deluxe Suite | 800 | 4 | WiFi Access |
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 |
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 |
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. |
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 |