| Primary Key | Field Type |
|---|---|
 ID |
int |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 Sport |
uniqueidentifier | |||
| Season |
uniqueidentifier | |||
| Division |
uniqueidentifier |  |
||
| Gender |
uniqueidentifier | |
||
| Notes |
nvarchar(2048) | |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 ClientSitesID |
int | ClientSites.ID | ||
| PageCreatorClientUsersID |
int | |
ClientUsers.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_ATHLETICS_TEAMS_PAGECREATORCLIENTUSERSID |
PageCreatorClientUsersID | |||
| IX_ATHLETICS_TEAMS_SEASON |
Season | |||
| PK_ATHLETICS_TEAMS |
ID | |
|
|
| Referenced by | Field |
|---|---|
 ATHLETICS_EECOACHES |
TeamID |
| ATHLETICS_EVENTS |
TeamID |
| ATHLETICS_ROSTERS |
TeamID |