Hi All,
I need help in creating a model relation to a table with composite key.
Scenario:-
Table 1.
id (primary)
level
Table 2.
id (primary)
program
Table 3.
id (primary)
section
table 4.
id (primary)
user
table 5.
id (primary)
year
table 6.
id (primary)
term
Table 7.
id (primary)
levelId, (FK)
programId, (FK)
sectionId, (FK)
userId, (FK)
yearId (FK)
valid
Table 8.
userId, programId, sectionId, termId, yearId (composite key)
Grade
Now
I am calling the Table 7 model data and getting all the info, foreach user i need the grade based on the composite key in Table 8.
How can i make a relation to get the info.
Kindly help!!!!
Regards,
Wenceslaus D’silva