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 |
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 |
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 |
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 |
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 |