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?