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 |