## Apartments

apartmentID | type
--- | ---
1 | High-end Residential
2 | Budget Accommodation
3 | Corporate Housing
4 | Vacation Rentals
5 | Extended Stay

## EspressoMachines

espressoID | apartmentID | lastMaintenanceDate
--- | --- | ---
| (→ Apartments.apartmentID) |
1 | 1 | 2023-01-01
2 | 2 | 2023-06-01
3 | 3 | 2023-07-01
4 | 4 | 2023-08-01
5 | 5 | 2023-09-01

## Blenders

blenderID | apartmentID | lastMaintenanceDate
--- | --- | ---
| (→ Apartments.apartmentID) |
1 | 1 | 2023-01-15
2 | 2 | 2023-06-15
3 | 3 | 2023-07-15
4 | 4 | 2023-08-15
5 | 5 | 2023-09-15

## Employees

employeeID | name | role
--- | --- | ---
1 | John Doe | Technician
2 | Jane Smith | Supervisor
3 | Alice Johnson | Manager
4 | Bob Brown | Engineer
5 | Charlie Davis | Cleaner

## EspressoRepairs

repairId | espressoId | employeeId | repairDate | description
--- | --- | --- | --- | ---
| (→ EspressoMachines.espressoID) | (→ Employees.employeeID) |  |
1 | 1 | 1 | 2023-02-01 | Leakage issue
2 | 2 | 2 | 2023-03-01 | Grinder malfunction
3 | 3 | 3 | 2023-04-01 | Water pump failure
4 | 4 | 4 | 2023-05-01 | Heating element replacement
5 | 5 | 5 | 2023-06-01 | Milk frother problem

## BlenderRepairs

repairId | blenderId | employeeId | repairDate | description
--- | --- | --- | --- | ---
| (→ Blenders.blenderID) | (→ Employees.employeeID) |  |
1 | 1 | 1 | 2023-02-15 | Broken blade
2 | 2 | 2 | 2023-03-15 | Motor overheating
3 | 3 | 3 | 2023-04-15 | Pitch control issue
4 | 4 | 4 | 2023-05-15 | Lid seal damage
5 | 5 | 5 | 2023-06-15 | Container cracking