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 |
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 |
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 |
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 |
id | Funding | publicPark | fundsAmount | projectID |
---|---|---|---|---|
(→ Projects.projectID) | ||||
1 | City Hall | Yes | 50000.0 | 1 |
2 | State Department | No | 75000.0 | 1 |
3 | National Park Service | Yes | 100000.0 | 2 |
4 | Federal Grant Program | Yes | 125000.0 | 2 |
5 | International Organization | Yes | 150000.0 | 3 |