Apartments

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

EspressoMachines

espressoIDapartmentIDlastMaintenanceDate
(→ Apartments.apartmentID)
112023-01-01
222023-06-01
332023-07-01
442023-08-01
552023-09-01

Blenders

blenderIDapartmentIDlastMaintenanceDate
(→ Apartments.apartmentID)
112023-01-15
222023-06-15
332023-07-15
442023-08-15
552023-09-15

Employees

employeeIDnamerole
1John DoeTechnician
2Jane SmithSupervisor
3Alice JohnsonManager
4Bob BrownEngineer
5Charlie DavisCleaner

EspressoRepairs

repairIdespressoIdemployeeIdrepairDatedescription
(→ EspressoMachines.espressoID)(→ Employees.employeeID)
1112023-02-01Leakage issue
2222023-03-01Grinder malfunction
3332023-04-01Water pump failure
4442023-05-01Heating element replacement
5552023-06-01Milk frother problem

BlenderRepairs

repairIdblenderIdemployeeIdrepairDatedescription
(→ Blenders.blenderID)(→ Employees.employeeID)
1112023-02-15Broken blade
2222023-03-15Motor overheating
3332023-04-15Pitch control issue
4442023-05-15Lid seal damage
5552023-06-15Container cracking