## Employees

Id | Name | JobTitle | ContactInfo | HireDate | Salary
--- | --- | --- | --- | --- | ---
1 | John Doe | Carpenter | +1-987-654-3210 | 2021-01-15 | 50000.0
2 | Jane Smith | Electrician | +1-987-654-3211 | 2020-06-01 | 55000.0
3 | Alice Johnson | Plumber | +1-987-654-3212 | 2019-08-10 | 52000.0
4 | Bob Brown | Foreman | +1-987-654-3213 | 2018-11-15 | 60000.0
5 | Charlie Davis | Supervisor | +1-987-654-3214 | 2017-05-01 | 65000.0

## Equipment

Id | Type | ModelNumber | PurchaseDate | CostPrice | MarketValue
--- | --- | --- | --- | --- | ---
1 | Excavator | EX1000 | 2021-02-10 | 100000.0 | 120000.0
2 | Bulldozer | BD2000 | 2020-09-01 | 150000.0 | 180000.0
3 | Crane | CR3000 | 2019-05-05 | 200000.0 | 250000.0
4 | Dumper Truck | DT4000 | 2018-07-10 | 50000.0 | 65000.0
5 | Concrete Mixer | CM5000 | 2017-10-01 | 30000.0 | 40000.0

## ProjectStatus

Id | ProjectId | Date | TaskCompleted | BudgetSpent | ExpectedCompletionDate
--- | --- | --- | --- | --- | ---
| (→ ConstuctionSite.Id) |  |  |  |
1 | 1 | 2021-06-15 | Foundation Laid | 20000.0 | 2021-07-15
2 | 1 | 2021-07-15 | Walls Erected | 35000.0 | 2021-08-15
3 | 1 | 2021-08-15 | Roof Installed | 50000.0 | 2021-09-15
4 | 1 | 2021-09-15 | Interior Finished | 65000.0 | 2021-10-15
5 | 1 | 2021-10-15 | Final Inspection | 75000.0 | 2021-11-15

## ContractorDetails

Id | Name | Address | PhoneNumber | EmailAddress | ServicesOffered
--- | --- | --- | --- | --- | ---
1 | ABC Construction | 123 Main St, Cityville | +1-123-456-7890 | abc@construction.com | Residential and Commercial Building
2 | XYZ Infrastructure | 456 Elm St, Cityville | +1-123-456-7891 | xyz@infrastructure.com | Infrastructure Development
3 | DEF Electricals | 789 Oak St, Cityville | +1-123-456-7892 | def@electricals.com | Electrical Works
4 | GHI Plumbing | 135 Maple St, Cityville | +1-123-456-7893 | ghi@plumbing.com | Plumbing Services
5 | JKL Landscaping | 456 Pine St, Cityville | +1-123-456-7894 | jkl@landscaping.com | Landscape Design and Installation

## Boards

Id | GovernmentAgency | RegulatoryBoard | EngineeringProject
--- | --- | --- | ---
1 | City Planning Department | Building Code Authority | Highway Expansion Project
2 | Department of Transportation | Transport Safety Board | Railway Modernization Project
3 | Environment Protection Agency | Air Quality Control Committee | Industrial Waste Treatment Plant
4 | Health & Safety Executive | Occupational Health Committee | Hospital Construction Project
5 | Local Council | Heritage Preservation Society | Historic Building Restoration Project