Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LEAGUE_SCHEDULE_ID | int | 4 | null |
|
|
The league schedule ID |
||||||||||||||||||||
| LEAGUE_SCHEDULE_TITLE | varchar | 50 | √ | null |
|
|
The league schedule title |
|||||||||||||||||||
| LEAGUE_ID | int | 4 | √ | null |
|
|
The ID of the league that the schedule belongs to |
|||||||||||||||||||
| LEAGUE_NAME | varchar | 50 | √ | null |
|
|
The name of the league that the schedule belongs to |
|||||||||||||||||||
| SCHEDULE_TYPE | varchar | 10 | √ | null |
|
|
The type of schedule (Regular / Practice / Tournament) |
|||||||||||||||||||
| DISTRIBUTION_TYPE | varchar | 20 | √ | null |
|
|
The tournament or game distribution (Round Robin / Single Elimination / Double Elimination) |
|||||||||||||||||||
| SCHEDULE_LIMIT_TYPE | varchar | 20 | √ | null |
|
|
How games will be limited in the schedule (Matches per team / Rounds) |
|||||||||||||||||||
| NUMBER_OF_ROUNDS_OR_MATCHES | int | 4 | √ | null |
|
|
The number of rounds or matches per team that the schedule should be generated for |
|||||||||||||||||||
| BALANCE_SCHEDULE_BY_FIRST | varchar | 15 | √ | null |
|
|
The top priority when balancing the generated schedule (None / Game Site / Day of Week / Time / Week) |
|||||||||||||||||||
| BALANCE_SCHEDULE_BY_SECOND | varchar | 15 | √ | null |
|
|
The second priority when balancing the generated schedule (None / Game Site / Day of Week / Time / Week) |
|||||||||||||||||||
| BALANCE_SCHEDULE_BY_THIRD | varchar | 15 | √ | null |
|
|
The third priority when balancing the generated schedule (None / Game Site / Day of Week / Time / Week) |
|||||||||||||||||||
| BALANCE_SCHEDULE_BY_FOURTH | varchar | 15 | √ | null |
|
|
The fourth priority when balancing the generated schedule (None / Game Site / Day of Week / Time / Week) |
|||||||||||||||||||
| STARTING_DATE | date | 20 | √ | null |
|
|
The starting date for the schedule |
|||||||||||||||||||
| ENDING_DATE | date | 20 | √ | null |
|
|
The ending date for the schedule |
|||||||||||||||||||
| USE_ONLY_LEAGUE_SKIP_DATES | varchar | 5 | √ | null |
|
|
Whether only league-specific skip dates should be excluded when generating the schedule (Yes/No) |
|||||||||||||||||||
| DOUBLE_HEADERS | varchar | 5 | √ | null |
|
|
Whether games should be scheduled as double headers (Yes/No) |
|||||||||||||||||||
| TEAM_OFFICIATING | varchar | 5 | √ | null |
|
|
Whether the schedule games will be officiated by the participating teams (Yes/No) |
|||||||||||||||||||
| SPREAD_BOOKINGS_EVENLY | varchar | 5 | √ | null |
|
|
Whether bookings should be spread evenly over the full range of potential game dates (Yes/No) |
|||||||||||||||||||
| MAXIMUM_GAMES_PER_WEEK | int | 4 | √ | null |
|
|
The maximum number of games per week per team |
|||||||||||||||||||
| MAXIMUM_GAMES_PER_DAY | int | 4 | √ | null |
|
|
The maximum number of games per day per team |
|||||||||||||||||||
| GAME_DURATION_MINUTES | int | 4 | √ | null |
|
|
The duration of each game to be scheduled in minutes |
|||||||||||||||||||
| CALENDAR_CODE | varchar | 5 | √ | null |
|
|
The calendar code to be used for this schedule |
|||||||||||||||||||
| BYE_TEXT | varchar | 10 | √ | null |
|
|
The text to be used for byes |
|||||||||||||||||||
| USE_TEAM_HOME_LOCATIONS | varchar | 5 | √ | null |
|
|
Whether team’s home locations should be used when generating the schedule (Yes/No) |
|||||||||||||||||||
| SHOW_ONLINE | varchar | 5 | √ | null |
|
|
Whether this league schedule should be available online (Yes/No) |
|||||||||||||||||||
| SCHEDULE_OFFICIALS | varchar | 5 | √ | null |
|
|
Whether officials should be scheduled for this league schedule (Yes/No) |
|||||||||||||||||||
| OFFICIALS_PER_GAME | int | 4 | √ | null |
|
|
The number of officials to be scheduled for each game |
|||||||||||||||||||
| LEAGUE_SCHEDULE_GENERATED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the game schedule was last generated for this league schedule |
|||||||||||||||||||
| LEAGUE_SCHEDULE_GENERATED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the game schedule was last generated for this league schedule (date only) |
|||||||||||||||||||
| OFFICIALS_SCHEDULE_GENERATED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the officials schedule was last generated for this league schedule |
|||||||||||||||||||
| OFFICIALS_SCHEDULE_GENERATED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the officials schedule was last generated for this league schedule (date only) |
|||||||||||||||||||
| 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 |