Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| RANKING_SYSTEM_ID | int | 4 | null |
|
|
The ranking system ID |
|||||
| RANKING_SYSTEM_NAME | varchar | 100 | √ | null |
|
|
The ranking system name |
||||
| RANKING_SYSTEM_DESCRIPTION | varchar | 500 | √ | null |
|
|
The ranking system description |
||||
| RANKING_SYSTEM_TYPE | varchar | 30 | √ | null |
|
|
The type of ranking system to base this system upon (Win Loss Percentage Normal / Game Ranking Points / Match Win Loss Percentage / Match Ranking Points / Scores As Games Percentage / Scores As Games Points) |
||||
| POINTS_FOR_WIN | int | 4 | √ | null |
|
|
The number of points to be awarded for a win |
||||
| POINTS_FOR_TIE | int | 4 | √ | null |
|
|
The number of points to be awarded for a tie |
||||
| POINTS_FOR_LOSS | int | 4 | √ | null |
|
|
The number of points to be awarded for a loss |
||||
| GAMES_PLAYED_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the number of games played |
||||
| WINS_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the number of wins |
||||
| LOSSES_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the number of losses |
||||
| TIES_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the number of ties |
||||
| WIN_PERCENTAGE_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the win percentage |
||||
| POINTS_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the number of points |
||||
| GAME_WINS_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the number of games won in match play |
||||
| GAME_LOSSES_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the number of games lost in match play |
||||
| TOTAL_SCORE_FOR_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the total of scores for |
||||
| TOTAL_SCORE_AGAINST_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the total of scores against |
||||
| SCORE_DIFFERENTIAL_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the total score differential |
||||
| GAMES_BEHIND_HEADING | varchar | 10 | √ | null |
|
|
The column heading to be displayed on the standings page for the number of games behind the leader |
||||
| SHOW_GAMES_PLAYED | varchar | 5 | √ | null |
|
|
Whether the number of games played column should be displayed on the standings page (Yes/No) |
||||
| SHOW_WINS | varchar | 5 | √ | null |
|
|
Whether the number of wins column should be displayed on the standings page (Yes/No) |
||||
| SHOW_LOSSES | varchar | 5 | √ | null |
|
|
Whether the number of losses column should be displayed on the standings page (Yes/No) |
||||
| SHOW_TIES | varchar | 5 | √ | null |
|
|
Whether the number of ties column should be displayed on the standings page (Yes/No) |
||||
| SHOW_WIN_PERCENTAGE | varchar | 5 | √ | null |
|
|
Whether the win percentage column should be displayed on the standings page (Yes/No) |
||||
| SHOW_POINTS | varchar | 5 | √ | null |
|
|
Whether the number of points column should be displayed on the standings page (Yes/No) |
||||
| SHOW_GAME_WINS | varchar | 5 | √ | null |
|
|
Whether the number of games won in match play column should be displayed on the standings page (Yes/No) |
||||
| SHOW_GAME_LOSSES | varchar | 5 | √ | null |
|
|
Whether the number of games lost in match play column should be displayed on the standings page (Yes/No) |
||||
| SHOW_TOTAL_SCORE_FOR | varchar | 5 | √ | null |
|
|
Whether the total of scores for column should be displayed on the standings page (Yes/No) |
||||
| SHOW_TOTAL_SCORE_AGAINST | varchar | 5 | √ | null |
|
|
Whether the total of scores against column should be displayed on the standings page (Yes/No) |
||||
| SHOW_SCORE_DIFFERENTIAL | varchar | 5 | √ | null |
|
|
Whether the score differential column should be displayed on the standings page (Yes/No) |
||||
| SHOW_GAMES_BEHIND | varchar | 5 | √ | null |
|
|
Whether the number of games behind the leader column should be displayed on the standings page (Yes/No) |
||||
| 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) |
|---|---|---|---|
| RANKING_SYSTEMS_RANKING_SYSTEM_ID_ORG_ID_PK | Primary key | Asc/Asc | RANKING_SYSTEM_ID + ORG_ID |
| RANKING_SYSTEMS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |