materialID | name | quantity | cost |
---|---|---|---|
1 | Cement | 100 | 39.99 |
2 | Steel Rebars | 200 | 68.75 |
3 | Concrete Blocks | 300 | 25.0 |
4 | Bricks | 150 | 18.5 |
5 | Electrical Wiring | 100 | 45.0 |
employeeID | firstName | lastName | hireDate | position |
---|---|---|---|---|
1 | John | Doe | 2021-01-01 | Project Manager |
2 | Jane | Smith | 2021-02-01 | Engineer |
3 | Mike | Johnson | 2021-03-01 | Construction Worker |
4 | Emily | Brown | 2021-04-01 | Supervisor |
5 | Tom | White | 2021-05-01 | Architect |
projectID | projectName | startDate | endDate | budget |
---|---|---|---|---|
1 | Residential Building | 2021-06-01 | 2021-08-01 | 300000.0 |
2 | Commercial Complex | 2021-07-01 | 2021-09-01 | 1000000.0 |
3 | Road Repair | 2021-08-01 | 2021-10-01 | 500000.0 |
4 | School Renovation | 2021-09-01 | 2021-11-01 | 600000.0 |
5 | Office Building | 2021-10-01 | 2021-12-01 | 700000.0 |
inventoryID | materialID | quantity |
---|---|---|
(→ Material.materialID) | ||
1 | 1 | 50 |
2 | 2 | 100 |
3 | 3 | 200 |
4 | 4 | 100 |
5 | 5 | 50 |
safetyID | employeeID | personalProtectiveEquipment | trainingPrograms | constructionWorker |
---|---|---|---|---|
(→ Employee.employeeID) | ||||
1 | 1 | Hard Hat, Gloves, Steel-toed Boots | OSHA Training, First Aid Certification | Experienced |
2 | 2 | Helmet, Earplugs, Safety Glasses | Fall Protection Training, CPR/First Aid | Intermediate |
3 | 3 | Hard Hat, Gloves, Safety Vest | Toolbox Talks, Scaffolding Training | Novice |
4 | 4 | Helmet, Safety Shoes, Goggles | Hazard Communication Training, Forklift Operation | Skilled |
5 | 5 | Hard Hat, Gloves, Knee Pads | Lockout/Tagout Training, Confined Space Entry | Expert |