| apartmentID | type |
|---|---|
| 1 | High-end Residential |
| 2 | Budget Accommodation |
| 3 | Corporate Housing |
| 4 | Vacation Rentals |
| 5 | Extended Stay |
| 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 |
| 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 |
| employeeID | name | role |
|---|---|---|
| 1 | John Doe | Technician |
| 2 | Jane Smith | Supervisor |
| 3 | Alice Johnson | Manager |
| 4 | Bob Brown | Engineer |
| 5 | Charlie Davis | Cleaner |
| 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 |
| 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 |