## Guest

guestID | firstName | lastName | emailAddress | phoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 1234567890
2 | Jane | Smith | jane.smith@example.com | 0987654321

## Room

roomID | apartmentType | numberOfGuests
--- | --- | ---
| (→ Apartment.type) |
1 | High-end Residential | 2
2 | Standard | 4

## Booking

bookingID | startDate | endDate | guestID | roomID
--- | --- | --- | --- | ---
|  |  | (→ Guest.guestID) | (→ Room.roomID)
1 | 2022-01-01 | 2022-01-07 | 1 | 1
2 | 2022-01-08 | 2022-01-14 | 2 | 2

## Apartment

aptID | type | address | capacity
--- | --- | --- | ---
1 | High-end Residential | 123 Main St | 10
2 | Standard | 456 Elm St | 8

## Commercial_Appliance

applianceID | name | status | apartmentID
--- | --- | --- | ---
|  |  | (→ Apartment.aptID)
1 | Espresso Machine | Operational | 1
2 | Espresso Machine | Needs Repair | 2
3 | Blender | Operational | 1
4 | Blender | Needs Repair | 2

## Inventory

inventoryItem | quantity | reorderLevel
--- | --- | ---
Soap | 500 | 200
Shampoo | 300 | 100