Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| LEAGUE_SCHEDULE_PAIRING_ID | int | 4 | null |
|
|
The league schedule pairing ID |
|||||
| LEAGUE_SCHEDULE_ID | int | 4 | √ | null |
|
|
The ID of the league schedule that the pairing belongs to |
||||
| HOME_TEAM_ID | int | 4 | √ | null |
|
|
The ID of the home team |
||||
| AWAY_TEAM_ID | int | 4 | √ | null |
|
|
The ID of the away team |
||||
| OFFICIAL_TEAM_ID | int | 4 | √ | null |
|
|
The ID of the team who is to provide officials for this pairing |
||||
| IS_BYE | varchar | 5 | √ | null |
|
|
Whether a team is getting a bye in this round (Yes/No) |
||||
| FACILITY_ID | int | 4 | √ | null |
|
|
The ID facility for this pairing (Yes/No) |
||||
| START_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The start date and time for this pairing |
||||
| END_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The end date and time for this pairing |
||||
| FACILITY_SCHEDULE_ID | int | 4 | √ | null |
|
|
The ID of the facility schedule reservation |
||||
| IS_POSTPONED | varchar | 5 | √ | null |
|
|
Whether this pairing has been postponed (Yes/No) |
||||
| POSTPONEMENT_REASON_ID | int | 4 | √ | null |
|
|
The ID of the reason for postponement |
||||
| HOME_SCORE | int | 4 | √ | null |
|
|
The home team score |
||||
| AWAY_SCORE | int | 4 | √ | null |
|
|
The away team score |
||||
| IS_TIE | varchar | 5 | √ | null |
|
|
Whether the result of this pairing is a tie (Yes/No) |
||||
| IS_HOME_FORFEIT | varchar | 5 | √ | null |
|
|
Whether the home team forfeited (Yes/No) |
||||
| IS_AWAY_FORFEIT | varchar | 5 | √ | null |
|
|
Whether the away team forfeited (Yes/No) |
||||
| GAME_NUMBER | int | 4 | √ | null |
|
|
The generated game number within the league or tournament |
||||
| ROUND_NUMBER | int | 4 | √ | null |
|
|
The round number within the league or tournament |
||||
| DISPLAY_ORDER | int | 4 | √ | null |
|
|
The display order or this pairing within the schedule or tournament bracket |
||||
| MATCH_ID | int | 4 | √ | null |
|
|
The match ID for this pairing |
||||
| HOME_RESULT_MATCH_ID | int | 4 | √ | null |
|
|
The match ID of the pairing that the home team advanced from |
||||
| HOME_RESULT_TYPE | varchar | 15 | √ | null |
|
|
The type of result that causes the home team to advance to this pairing (Winner / Loser / Bye / Final Round / None) |
||||
| AWAY_RESULT_MATCH_ID | int | 4 | √ | null |
|
|
The match ID of the pairing that the away team advanced from |
||||
| AWAY_RESULT_TYPE | varchar | 15 | √ | null |
|
|
The type of result that causes the away team to advance to this pairing (Winner / Loser / Bye / Final Round / None) |
||||
| DISPLAY_MATCH_ID | int | 4 | √ | null |
|
|
The display match ID for this pairing (excludes byes) |
||||
| DISPLAY_HOME_RESULT_MATCH_ID | int | 4 | √ | null |
|
|
The display match ID of the pairing that the home team advanced from (excludes byes) |
||||
| DISPLAY_AWAY_RESULT_MATCH_ID | int | 4 | √ | null |
|
|
The display match ID of the pairing that the away team advanced from (excludes byes) |
||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
||||
| LAST_SYNC_TIME | datetime | 16,3 | (getdate()) |
|
|
Date and time Hub record was last modified |
|||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
||||
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| LEAGUE_SCHEDULE_PAIRINGS_LEAGUE_SCHEDULE_PAIRING_ID_ORG_ID_PK | Primary key | Asc/Asc | LEAGUE_SCHEDULE_PAIRING_ID + ORG_ID |
| LEAGUE_SCHEDULE_PAIRINGS_AWAY_TEAM_ID_IX | Performance | Asc | AWAY_TEAM_ID |
| LEAGUE_SCHEDULE_PAIRINGS_FACILITY_ID_IX | Performance | Asc | FACILITY_ID |
| LEAGUE_SCHEDULE_PAIRINGS_FACILITY_SCHEDULE_ID_IX | Performance | Asc | FACILITY_SCHEDULE_ID |
| LEAGUE_SCHEDULE_PAIRINGS_HOME_TEAM_ID_IX | Performance | Asc | HOME_TEAM_ID |
| LEAGUE_SCHEDULE_PAIRINGS_LEAGUE_SCHEDULE_ID_IX | Performance | Asc | LEAGUE_SCHEDULE_ID |
| LEAGUE_SCHEDULE_PAIRINGS_OFFICIAL_TEAM_ID_IX | Performance | Asc | OFFICIAL_TEAM_ID |
| LEAGUE_SCHEDULE_PAIRINGS_POSTPONEMENT_REASON_ID_IX | Performance | Asc | POSTPONEMENT_REASON_ID |
| LEAGUE_SCHEDULE_PAIRINGS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |