Project

projectIDnamestartDateendDatestructuralInspectionIDsafetyInspectionID
(→ Structural_Inspection.inspectionID)(→ Safety_Inspection.inspectionID)
1Bridge Replacement2023-01-012023-12-3112
2Highway Repair2023-02-012023-12-3134

Material

materialIDtypequantityunitpriceprojectID
(→ Project.projectID)
1Concrete100cubic yards751
2Steel Rebar50tons901
3Asphalt100tons602
4Gravel200tons402

Employee

employeeIDfirstNamelastNamerolehireDatesupervisorID
(→ Employee.employeeID)
1JohnDoeStructural Engineer2022-01-01None
2JaneSmithSafety Officer2022-01-01None
3MikeJohnsonSite Supervisor2022-01-011
4AnnaWilliamsArchitect2022-01-011

Structural_Inspection

inspectionIDdateresultinspectorEmployeeID
(→ Employee.employeeID)
12023-01-20 10:00:00Passed1
22023-02-20 10:00:00Failed2

Safety_Inspection

inspectionIDdateresultinspectorEmployeeID
(→ Employee.employeeID)
12023-01-15 10:00:00Passed1
22023-02-15 10:00:00Failed2

Worker

workerIDfirstNamelastNameemploymentStartDatecurrentProjectID
(→ Project.projectID)
1TomHanks2022-01-011
2SamWaterson2022-01-012