Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| LEAGUE_SCHEDULE_PAIRING_ID | int | 4 | null |
|
|
The league schedule pairing ID |
|||||
| LEAGUE_ID | int | 4 | √ | null |
|
|
The ID of the league that the league schedule belongs to |
||||
| LEAGUE_NAME | varchar | 50 | √ | null |
|
|
The name of the league that the league schedule belongs to |
||||
| LEAGUE_SCHEDULE_ID | int | 4 | √ | null |
|
|
The ID of the league schedule that the pairing belongs to |
||||
| LEAGUE_SCHEDULE_TITLE | varchar | 50 | √ | null |
|
|
The title of the league schedule that the pairing belongs to |
||||
| HOME_TEAM_ID | int | 4 | √ | null |
|
|
The ID of the home team |
||||
| HOME_TEAM_NAME | varchar | 60 | √ | null |
|
|
The name of the home team |
||||
| AWAY_TEAM_ID | int | 4 | √ | null |
|
|
The ID of the away team |
||||
| AWAY_TEAM_NAME | varchar | 60 | √ | null |
|
|
The name of the away team |
||||
| OFFICIAL_TEAM_ID | int | 4 | √ | null |
|
|
The ID of the team who is to provide officials for this pairing |
||||
| OFFICIAL_TEAM_NAME | varchar | 60 | √ | null |
|
|
The name 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 of the facility for this pairing |
||||
| FACILITY_NAME | varchar | 255 | √ | null |
|
|
The name of the facility for this pairing |
||||
| 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 |
||||
| START_DATE_ONLY | date | 20 | √ | null |
|
|
The start date for this pairing (date only) |
||||
| END_DATE_ONLY | date | 20 | √ | null |
|
|
The end date for this pairing (date only) |
||||
| START_TIME_ONLY | time | 16 | √ | null |
|
|
The start time for this pairing (time only) |
||||
| END_TIME_ONLY | time | 16 | √ | null |
|
|
The end time for this pairing (time only) |
||||
| 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 |
||||
| POSTPONEMENT_REASON_NAME | varchar | 20 | √ | null |
|
|
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 | int | 4 | √ | 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 | int | 4 | √ | 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) |
||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
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 |