Contractors

contractorIDcompanyNameaddressphoneNumberemployeeCount
1Contractor AAddress A123-456-789010
2Contractor BAddress B234-567-890115
3Contractor CAddress C345-678-901220
4Contractor DAddress D456-789-012325
5Contractor EAddress E567-890-123430

Employees

employeeIDfirstNamelastNamehireDatesalarycontractorID
(→ Contractors.contractorID)
1JohnDoe2022-01-0150000.01
2JaneSmith2022-01-0255000.01
3MikeBrown2022-01-0360000.02
4EmilyJohnson2022-01-0465000.02
5TomWilson2022-01-0570000.03

Materials

materialIDdescriptionquantityunitCostprojectID
(→ Projects.projectID)
1Concrete10050.01
2Steel5075.01
3Glass2025.02
4Bricks30015.02
5Electrical Wiring10010.03

Payments

paymentIDamountpaymentDateprojectIDcontractorID
(→ Projects.projectID)(→ Contractors.contractorID)
1100002022-02-0111
2150002022-02-0211
3200002022-02-0322
4300002022-02-0422
5400002022-02-0533

Funding

idgovernmentAgencyprivateDonorspublicParkfundsAmountprojectID
(→ Projects.projectID)
1City HallLocal BusinessesYes50000.01
2State DepartmentPrivate FoundationsNo75000.01
3National Park ServiceYes100000.02
4Federal Grant ProgramYes125000.02
5International OrganizationGlobal DonorsYes150000.03