spz-signup / spz-signup-app

MIT License
0 stars 1 forks source link

Multiple course Attendances, only one ects field for internal representation #27

Closed urvdp closed 5 days ago

urvdp commented 6 days ago

Problem Description:

If one applicant has two courses and does "Zusatzleistung" in one course and receives 3 ECTS instead of 2, then 3 ECTS are also returned for the other course, even though he did not do "Zusatzleistung."

Problem:

Internally, each applicant has one ects field to store the ects points. In the case of multiple courses, the capability to store multiple ects values is exceeded.

Solution:

The number of ECTS points has to be linked to the course attendance and not to the single-applicant model. Add a column "ects" in attendance table and read ects value based on the course from there instead of storing it in the applicant table.

urvdp commented 5 days ago

ToDo:

total time: ~3 hours