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