I have the following Models and relations:
Club
- id, name, active
- relations:
- submissions HAS_MANY Submission -> cid
- members MANY_MANY Member -> ClubMember(cid, mid)
- cmembers HAS_MANY ClubMember -> cid
Member (this is not a user)
- id, name, surname
- relations:
- submissions HAS_MANY Submission -> mid
- clubs MANY_MANY Club -> ClubMember(mid, cid)
- mclubs HAS_MANY ClubMember -> mid
ClubMember
- id, cid, mid, active, startDate, endDate
- relations:
- club: BELONGS_TO Club -> cid
- member: BELONGS_TO Member -> mid
- submissions: HAS_MANY Submission //:: BUT HOW TO SPECIFY THIS? :://
// it should join on Submission->mid and Submission->cid
Submission
- id, cid, mid, details, score
- relations
- club: BELONGS_TO Club -> cid
- member: BELONGS_TO Member -> mid
How can I specify the relationship for ClubMember->submissions?
Any suggestions would be appreciated