## Patios

Id | Name | Address | Phone | Number_of_Seats
--- | --- | --- | --- | ---
1 | Sunny Side | 123 Main St | 555-6789 | 50
2 | Garden Oasis | 456 Elm St | 555-7890 | 60

## Verandas

Id | Name | Address | Phone | Number_of_Seats
--- | --- | --- | --- | ---
1 | Cozy Nook | 789 Oak St | 555-7654 | 50
2 | Rooftop View | 135 Pine St | 555-6781 | 40

## Rooms

Id | RoomNo | Capacity | Amenities | FloorType
--- | --- | --- | --- | ---
1 | 101 | 8 | WiFi, TV, AC | Hardwood
2 | 102 | 10 | WiFi, TV, AC | Tile

## Staffs

Id | FirstName | LastName | Position | Salary
--- | --- | --- | --- | ---
1 | John | Smith | Manager | 60000.0
2 | Jane | Doe | Server | 30000.0

## Customers

Id | CustomerID | Fullname | Contact | ReservationDate
--- | --- | --- | --- | ---
1 | 1 | Alice Johnson | alice@example.com | 2022-09-01T10:00:00
2 | 2 | Bob Smith | bob@example.com | 2022-09-15T14:00:00

## Bookings

Id | BookingId | RoomNo | CheckInTime | CheckOutTime | TotalStayDays | Price
--- | --- | --- | --- | --- | --- | ---
1 | 1 | 101 | 10:00:00 | 14:00:00 | 2 | 150
2 | 2 | 102 | 11:00:00 | 15:00:00 | 2 | 170