A team record shall store data used to identify sports teams.
| Field | Format |
|---|---|
| name | Unique short name or abbreviation of team. Up to 16 characters. |
| longName | Long descriptive name of team. Up to 64 characters. |
| home | Optional home region, city, or state of team. Up to 64 characters. |
| fkLeague | Foreign key to league this team participates |
A league record represents a sport league with competitive teams playing each other.
| Field | Format |
|---|---|
| name | Unique name of sport. Up to 64 characters. |
| highWins | Boolean value of whether high score wins |
Season records are periodic sets of matches, usually yearly.
| Field | Format |
|---|---|
| year | Four digit year string. |
| name | Optional alternative name of season, up to 64 chars long |
| fkLeague | Foreign key to league |
Matches records represent games where teams play against each other.
| Field | Format |
|---|---|
| round | Sequential match number in season, as an integer greater than zero. |
| fkSeason | Foreign key to season of match |
Participation represents teams scheduled to play, and their results. The relationship is many to many of teams to matches.
| Field | Format |
|---|---|
| fkTeam | Foreign key of team playing match |
| fkMatch | Foreign key of match |
| score | Final score of team in match, as integer. Null if team hasn't played |