Describe the bug
School id's are not actually unique in the database. Thus, whenever a school is identified, there must be some form of secondary matching to ensure that the desired school is the one targeted.
Where Is Bug/How to Recreate
Steps to reproduce the behavior:
Backend routes
Expected behavior
Suggested fix(es):
- For each route that queries the db, ensure that id's are not the only criteria for equality. Also use standardized name (and year if the data being inserted/updated/deleted/queried is year-dependent).
- Note that school id's in the yearlySchoolParticipation table reference the row id's for the schools, so these should not have to be changed.
Screenshots
Other comments
Describe the bug
School id's are not actually unique in the database. Thus, whenever a school is identified, there must be some form of secondary matching to ensure that the desired school is the one targeted.
Where Is Bug/How to Recreate
Steps to reproduce the behavior:
Backend routes
Expected behavior
Suggested fix(es):
Screenshots
Other comments