| material_id | name | cost |
|---|---|---|
| 1 | Concrete | 30.0 |
| 2 | Steel Rebar | 60.0 |
| 3 | Lumber | 20.0 |
| 4 | Bricks | 15.0 |
| 5 | Cement | 45.0 |
| project_id | name | start_date | end_date | infrastructure_id |
|---|---|---|---|---|
| (→ Infrastructure.infrastructure_id) | ||||
| 1 | Highway Bridge Repair | 2023-01-01 | 2023-07-31 | 1 |
| 2 | Road Paving | 2023-05-01 | 2023-10-31 | 2 |
| 3 | Building Foundation | 2023-03-01 | 2023-09-30 | 3 |
| 4 | Stadium Construction | 2023-08-01 | 2024-02-28 | 4 |
| 5 | Park Improvement | 2023-06-01 | 2023-12-31 | 5 |
| infrastructure_id | description | service_life_expectancy_id | renewal_schedule_id |
|---|---|---|---|
| (→ Service_Life_Expectancy.service_life_expectancy_id) | (→ Renewal_Schedule.renewal_schedule_id) | ||
| 1 | Bridge Abutment | 1 | 1 |
| 2 | Retaining Wall | 2 | 2 |
| 3 | Foundation Slab | 3 | 3 |
| 4 | Earthwork Embankment | 4 | 4 |
| 5 | Drainage System | 5 | 5 |
| worker_id | first_name | last_name | skill_level |
|---|---|---|---|
| 1 | John | Smith | 8 |
| 2 | Jane | Doe | 9 |
| 3 | Mike | Johnson | 7 |
| 4 | Emily | Williams | 9 |
| 5 | David | Brown | 8 |
| task_id | description | assigned_to_worker_id | due_date | completed |
|---|---|---|---|---|
| (→ Workers.worker_id) | ||||
| 1 | Repair concrete cracks | 1 | 2023-07-15 | 0 |
| 2 | Install new drainage system | 2 | 2023-10-01 | 0 |
| 3 | Replace steel rebar | 3 | 2023-09-15 | 0 |
| 4 | Paint bridge abutments | 4 | 2023-11-15 | 0 |
| 5 | Level retaining wall | 5 | 2023-12-15 | 0 |
| service_life_expectancy_id | min_years | max_years |
|---|---|---|
| 1 | 20 | 40 |
| 2 | 15 | 30 |
| 3 | 30 | 60 |
| 4 | 10 | 20 |
| 5 | 5 | 15 |
| renewal_schedule_id | frequency |
|---|---|
| 1 | Yearly |
| 2 | Quarterly |
| 3 | Semiannually |
| 4 | Monthly |
| 5 | Annually |