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 |