Patios

IdNameAddressPhoneNumber_of_Seats
1Sunny Side123 Main St555-678950
2Garden Oasis456 Elm St555-789060

Verandas

IdNameAddressPhoneNumber_of_Seats
1Cozy Nook789 Oak St555-765450
2Rooftop View135 Pine St555-678140

Rooms

IdRoomNoCapacityAmenitiesFloorType
11018WiFi, TV, ACHardwood
210210WiFi, TV, ACTile

Staffs

IdFirstNameLastNamePositionSalary
1JohnSmithManager60000.0
2JaneDoeServer30000.0

Customers

IdCustomerIDFullnameContactReservationDate
11Alice Johnsonalice@example.com2022-09-01T10:00:00
22Bob Smithbob@example.com2022-09-15T14:00:00

Bookings

IdBookingIdRoomNoCheckInTimeCheckOutTimeTotalStayDaysPrice
1110110:00:0014:00:002150
2210211:00:0015:00:002170