Construction_Projects

ProjectIDBudgetStaffLocationStartDateEndDate
11000000.020New York2023-01-012023-12-31
2800000.015Los Angeles2023-02-012023-11-30

Employees

EmployeeIDNamePositionHireDate
1John DoeProject Manager2022-06-01
2Jane SmithArchitect2021-09-01

Materials

MaterialIDTypeQuantityUnitCost
1Concrete500.075.0
2Steel Rebars300.0100.0

Equipment

EquipmentIDModelNameRentalRatePurchasePrice
1Excavator X500250.0500000.0
2Cranes MX700300.0600000.0

Suppliers

SupplierIDCompanyNameContactInfo
1ABC Concrete Supply(555) 123-4567
2XYZ Steel Distribution(555) 765-4321

Contractors

ContractorIDCompanyNameServicesOfferedLicenseNumber
1PQR Construction Co.General ContractingLic#123456
2STU Building SolutionsSubcontractingLic#654321