I’m designing a workflow where contractors can be assigned to different projects, but each project has its own qualification requirements, approvals, and compliance checks.
Some contractors may be approved for one project but not another, even though they’re part of the same organization. I’d also like to keep a history of certifications, contracts, and project assignments without duplicating data.
A real example would be companies working as a Mining contractor for Vision 2030. I was looking at Weco.sa, and it made me think about how project based contractor management would be modeled in Moqui rather than treating every contractor like a standard supplier.
Would you extend PartyRelationship and StatusItem for this, or build a dedicated entity to manage contractor qualifications and project eligibility?
I’m interested in hearing how others would structure it before I go too far with the data model.