Construction_Projects
ProjectID | Budget | Staff | Location | StartDate | EndDate |
1 | 1000000.0 | 20 | New York | 2023-01-01 | 2023-12-31 |
2 | 800000.0 | 15 | Los Angeles | 2023-02-01 | 2023-11-30 |
Employees
EmployeeID | Name | Position | HireDate |
1 | John Doe | Project Manager | 2022-06-01 |
2 | Jane Smith | Architect | 2021-09-01 |
Materials
MaterialID | Type | Quantity | UnitCost |
1 | Concrete | 500.0 | 75.0 |
2 | Steel Rebars | 300.0 | 100.0 |
Equipment
EquipmentID | ModelName | RentalRate | PurchasePrice |
1 | Excavator X500 | 250.0 | 500000.0 |
2 | Cranes MX700 | 300.0 | 600000.0 |
Suppliers
SupplierID | CompanyName | ContactInfo |
1 | ABC Concrete Supply | (555) 123-4567 |
2 | XYZ Steel Distribution | (555) 765-4321 |
Contractors
ContractorID | CompanyName | ServicesOffered | LicenseNumber |
1 | PQR Construction Co. | General Contracting | Lic#123456 |
2 | STU Building Solutions | Subcontracting | Lic#654321 |