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 |