...
Property | Type | Values | Example |
|---|---|---|---|
Name
| text | Female U15A Playoffs | Female U15A Playoffs |
Season
| enum |
| 2021-22 |
Office
| fk to Office | (from db) | 785 (PCAHA Female) |
Type
| enum |
| Playoffs |
Division1
| enum |
| U15 |
Gender1
| enum |
| Female |
Category1
| enum |
| A |
Start Date
| date | 2022-01-31 | |
End Date
| date | 2022-03-06 |
...
2 Worth noting that when designing schedules, an assumption made was that associations could have multiple tournaments for a single division. In practice, this doesn’t seem to be the case, but this design would allow for this. e.g., Kamloops could have a U13C tournament at the start and end of the season, but in practice they’ll have a U13C tournament in the fall and a U15C tournament in the winter, if not concurrently. Downside of this design is you have to create two separate schedules in this scenario, so you can’t link to a single page for an event like this.
3 These are hardcoded enum values and will need to be aligned with SID soon to allow flexibility for multi-sports.
Relations
Office
A schedule belongs to a single Office. An office does not have any concept of division/gender/category, which generally is defined by a schedule or team belonging to the office, and further enforced by permissions which may be limited in this way.
...