## Project

projectID | name | startDate | endDate | structuralInspectionID | safetyInspectionID
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Structural_Inspection.inspectionID) | (→ Safety_Inspection.inspectionID)
1 | Bridge Replacement | 2023-01-01 | 2023-12-31 | 1 | 2
2 | Highway Repair | 2023-02-01 | 2023-12-31 | 3 | 4

## Material

materialID | type | quantity | unit | price | projectID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Project.projectID)
1 | Concrete | 100 | cubic yards | 75 | 1
2 | Steel Rebar | 50 | tons | 90 | 1
3 | Asphalt | 100 | tons | 60 | 2
4 | Gravel | 200 | tons | 40 | 2

## Employee

employeeID | firstName | lastName | role | hireDate | supervisorID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Employee.employeeID)
1 | John | Doe | Structural Engineer | 2022-01-01 | None
2 | Jane | Smith | Safety Officer | 2022-01-01 | None
3 | Mike | Johnson | Site Supervisor | 2022-01-01 | 1
4 | Anna | Williams | Architect | 2022-01-01 | 1

## Structural_Inspection

inspectionID | date | result | inspectorEmployeeID
--- | --- | --- | ---
|  |  | (→ Employee.employeeID)
1 | 2023-01-20 10:00:00 | Passed | 1
2 | 2023-02-20 10:00:00 | Failed | 2

## Safety_Inspection

inspectionID | date | result | inspectorEmployeeID
--- | --- | --- | ---
|  |  | (→ Employee.employeeID)
1 | 2023-01-15 10:00:00 | Passed | 1
2 | 2023-02-15 10:00:00 | Failed | 2

## Worker

workerID | firstName | lastName | employmentStartDate | currentProjectID
--- | --- | --- | --- | ---
|  |  |  | (→ Project.projectID)
1 | Tom | Hanks | 2022-01-01 | 1
2 | Sam | Waterson | 2022-01-01 | 2