Headteachers and Parents must be able to manage students' absence appeals

[josepostiga]

Scenario

As a Headteacher
I want to access a list of my classes' students' absences
So that I can manage them

As a Parent
I want to access a list of my student's absences
So that I can manage them

Description

When a teacher marks a student as absent from a lesson, the lesson_registry table gets a record of type ABSENT associated with that student.

The absences might be justified later on, by the students' parents. Parents must be able to access a list of their students' absences and insert an absence justification that, in turn, will be the object of a decision from that class Headteacher, deciding if to accept or reject it (with a reason for not accepting it), according to the school's internal guidelines.

When a Parent submits a justification, the Headteacher must receive an email notification, and, in turn, when the Headteacher decides on that, the Parent and the Student should also receive an email notification.

Besides that, Headteachers can change the decision, at any time, but needs to also insert a motive of change. A notification email should also be sent on this case.

Database and schema information

Create a new appeal table, which will hold a polymorphic relation to the original record to be appealed (to resolve to the relevant lesson_registry), a status enum (PENDING being the default, ACCEPTED or DECLINED) and the usual timestamps.

Create a new appeal_registry which will hold an appeal and user foreign keys, an action enum (PENDING being the default, ACCEPTED, DECLINED) and a description, to hold contextual information to the type of record created.

Additional requirements

No additional requirements.