Real_Estate_Developer

idnamecontact_info
1Company A+123456789
2Company B+987654321

Contractor

idnamespecialtylicense_number
1Contractor XConcrete WorkLX001
2Contractor YPlumbingLY002

Development_Project

idproject_namedeveloper_idcontractor_id
(→ Real_Estate_Developer.id)(→ Contractor.id)
1High Rise Building11
2Residential Complex22

Project_Milestone

idmilestone_descriptionstart_dateend_datedevelopment_project_id
(→ Development_Project.id)
1Foundation Completed2023-01-012023-01-101
2Framing Started2023-01-112023-01-201

Materials

idmaterial_typequantityunit_pricecontractor_id
(→ Contractor.id)
1Reinforcement Bar500101
2Pipes30082

Employee

idfirst_namelast_namepositioncontractor_id
(→ Contractor.id)
1JohnSmithSite Supervisor1
2JaneDoeEngineer2