## Contractors

contractorID | companyName | address | phoneNumber | employeeCount
--- | --- | --- | --- | ---
1 | Contractor A | Address A | 123-456-7890 | 10
2 | Contractor B | Address B | 234-567-8901 | 15
3 | Contractor C | Address C | 345-678-9012 | 20
4 | Contractor D | Address D | 456-789-0123 | 25
5 | Contractor E | Address E | 567-890-1234 | 30

## Employees

employeeID | firstName | lastName | hireDate | salary | contractorID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Contractors.contractorID)
1 | John | Doe | 2022-01-01 | 50000.0 | 1
2 | Jane | Smith | 2022-01-02 | 55000.0 | 1
3 | Mike | Brown | 2022-01-03 | 60000.0 | 2
4 | Emily | Johnson | 2022-01-04 | 65000.0 | 2
5 | Tom | Wilson | 2022-01-05 | 70000.0 | 3

## Materials

materialID | description | quantity | unitCost | projectID
--- | --- | --- | --- | ---
|  |  |  | (→ Projects.projectID)
1 | Concrete | 100 | 50.0 | 1
2 | Steel | 50 | 75.0 | 1
3 | Glass | 20 | 25.0 | 2
4 | Bricks | 300 | 15.0 | 2
5 | Electrical Wiring | 100 | 10.0 | 3

## Payments

paymentID | amount | paymentDate | projectID | contractorID
--- | --- | --- | --- | ---
|  |  | (→ Projects.projectID) | (→ Contractors.contractorID)
1 | 10000 | 2022-02-01 | 1 | 1
2 | 15000 | 2022-02-02 | 1 | 1
3 | 20000 | 2022-02-03 | 2 | 2
4 | 30000 | 2022-02-04 | 2 | 2
5 | 40000 | 2022-02-05 | 3 | 3

## Funding

id | governmentAgency | privateDonors | publicPark | fundsAmount | projectID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Projects.projectID)
1 | City Hall | Local Businesses | Yes | 50000.0 | 1
2 | State Department | Private Foundations | No | 75000.0 | 1
3 | National Park Service |  | Yes | 100000.0 | 2
4 | Federal Grant Program |  | Yes | 125000.0 | 2
5 | International Organization | Global Donors | Yes | 150000.0 | 3