A user is registered if they filled in their name and school. This PR prevents at the database level unregistered users from being included in relationships modeled by the tables works, teacher_requests, and teacher_student_associations, where it's required to have this registration data in order to be identified by the other parties of those relations.
The PR also adds a constraint that checks if the initiator of a teacher-student association is part of that association, and creates functions that allow retrieving lists of characterizations and essays for a certain character/title in random order. It also relaxes the strict limit of maximum 10 rows fetched imposed on some tables.
A user is registered if they filled in their name and school. This PR prevents at the database level unregistered users from being included in relationships modeled by the tables
works,teacher_requests, andteacher_student_associations, where it's required to have this registration data in order to be identified by the other parties of those relations.The PR also adds a constraint that checks if the initiator of a teacher-student association is part of that association, and creates functions that allow retrieving lists of characterizations and essays for a certain character/title in random order. It also relaxes the strict limit of maximum 10 rows fetched imposed on some tables.