Employees

IdNameJobTitleContactInfoHireDateSalary
1John DoeCarpenter+1-987-654-32102021-01-1550000.0
2Jane SmithElectrician+1-987-654-32112020-06-0155000.0
3Alice JohnsonPlumber+1-987-654-32122019-08-1052000.0
4Bob BrownForeman+1-987-654-32132018-11-1560000.0
5Charlie DavisSupervisor+1-987-654-32142017-05-0165000.0

Equipment

IdTypeModelNumberPurchaseDateCostPriceMarketValue
1ExcavatorEX10002021-02-10100000.0120000.0
2BulldozerBD20002020-09-01150000.0180000.0
3CraneCR30002019-05-05200000.0250000.0
4Dumper TruckDT40002018-07-1050000.065000.0
5Concrete MixerCM50002017-10-0130000.040000.0

ProjectStatus

IdProjectIdDateTaskCompletedBudgetSpentExpectedCompletionDate
(→ ConstuctionSite.Id)
112021-06-15Foundation Laid20000.02021-07-15
212021-07-15Walls Erected35000.02021-08-15
312021-08-15Roof Installed50000.02021-09-15
412021-09-15Interior Finished65000.02021-10-15
512021-10-15Final Inspection75000.02021-11-15

ContractorDetails

IdNameAddressPhoneNumberEmailAddressServicesOffered
1ABC Construction123 Main St, Cityville+1-123-456-7890abc@construction.comResidential and Commercial Building
2XYZ Infrastructure456 Elm St, Cityville+1-123-456-7891xyz@infrastructure.comInfrastructure Development
3DEF Electricals789 Oak St, Cityville+1-123-456-7892def@electricals.comElectrical Works
4GHI Plumbing135 Maple St, Cityville+1-123-456-7893ghi@plumbing.comPlumbing Services
5JKL Landscaping456 Pine St, Cityville+1-123-456-7894jkl@landscaping.comLandscape Design and Installation

Boards

IdGovernmentAgencyRegulatoryBoardEngineeringProject
1City Planning DepartmentBuilding Code AuthorityHighway Expansion Project
2Department of TransportationTransport Safety BoardRailway Modernization Project
3Environment Protection AgencyAir Quality Control CommitteeIndustrial Waste Treatment Plant
4Health & Safety ExecutiveOccupational Health CommitteeHospital Construction Project
5Local CouncilHeritage Preservation SocietyHistoric Building Restoration Project