[Rec-IM] Halls/Affiliations - Githubissues

gordon-cs / gordon-360-api

The 360° Gordon Experience

12 stars 7 forks source link

[Rec-IM] Halls/Affiliations #987

Closed amos-cha closed 1 year ago

amos-cha commented 1 year ago

new Term: Affiliations. This term pertains to all Halls/Clubs Team affiliations that can have points attributed to.

Database Changes

Team

(nullable) Affiliation

Series

WinnerID (teamID: nullable)
Points (points for winning this series)

new Affliation

Lookup Table only has name (just to retain db sanitization)

new AffiliationPoints compound key: AffiliationName, TeamID, SeriesID

AffiliationName (fk Affliation)
TeamID (fk Team)
SeriesID (fk Series)
Points (default 0)

new view SeriesTeamView

SeriesTeam but with calculated SportsmanshipRating

API Changes:

Updating a Series to completed or back to anything from completed will cause the Series to select its own winner based on WinCount => SportsmanshipRating
New Routes

amos-cha commented 1 year ago

Note: EFPT Changes their own protocol for managing filtering schemas. This has resulted in the defaulting of the dbo schema which is why we have 70 files changed.