Add course_sets_id column to semester_grades table. When adding Semester Transcript for a student whether individually or in bulk, Course Set ID will be fetch from student current program course set based on study level and semester when available. If not, throw an error.
Admin Course Set
Remove study_levels_code, semester and program field.
Course Set shouldn't be added uniquely anymore based on the 3 fields anymore. It will be added as it's own Course Set.
Admin Program
In Program update page, add a place to update the current course set for the program based on semester and study_levels_code. This means when adding Course Sets, both of those details aren't needed anymore.
Other Notes
Admin have to take notes of what courses is added to a Course Set.
Affected features:
Semester Transcript
Add
course_sets_idcolumn tosemester_gradestable. When adding Semester Transcript for a student whether individually or in bulk, Course Set ID will be fetch from student current program course set based on study level and semester when available. If not, throw an error.Admin Course Set
Remove
study_levels_code,semesterandprogramfield. Course Set shouldn't be added uniquely anymore based on the 3 fields anymore. It will be added as it's own Course Set.Admin Program
In Program update page, add a place to update the current course set for the program based on
semesterandstudy_levels_code. This means when adding Course Sets, both of those details aren't needed anymore.Other Notes