All individual subscriptions are 50% off this week only!

lovatt
4 years ago

Multiple relationships on one pivot table?

Posted 4 years ago by lovatt

I'm trying to have more than one relationship on a pivot table is this possible?

screenshot of schema : http://snag.gy/FWS4A.jpg

An Applicant can apply for many vacancies and a Vacancy can have many applicants, but for each record in my pivot i have another field (applicant_statuses) this will record the status of the applicant's application.

is this the right approach? if so, how do i set / retrieve this status?

Please sign in or create an account to participate in this conversation.