Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LOCKER_ROOM_ID | int | 4 | null |
|
|
The locker room ID |
|||||||||||
| LOCKER_ROOM_NAME | varchar | 150 | √ | null |
|
|
The locker room name |
||||||||||
| LOCKER_ROOM_DESCRIPTION | varchar | 8000 | √ | null |
|
|
The locker room description |
||||||||||
| CENTER_ID | int | 4 | √ | null |
|
|
The ID of the center where the locker room is located |
||||||||||
| CENTER_NAME | varchar | 255 | √ | null |
|
|
The name of the center where the locker room is located |
||||||||||
| GENDER_INDEX | int | 4 | √ | null |
|
|
The ID of the gender that this locker room is restricted to |
||||||||||
| GENDER | varchar | 100 | √ | null |
|
|
The gender that this locker room is restricted to |
||||||||||
| CONFIG_LOCKER_BANKS | varchar | 5 | √ | null |
|
|
Whether locker banks should be configured for the locker room (Yes/No) |
||||||||||
| ROOM_WIDTH | int | 4 | √ | null |
|
|
The width of the locker room |
||||||||||
| ROOM_HEIGHT | int | 4 | √ | null |
|
|
The height of the locker room |
||||||||||
| SHOW_ROOM_ONLINE | varchar | 5 | √ | null |
|
|
Whether the locker room should be shown online (Yes/No) |
||||||||||
| DISPLAY_ON_MAP | varchar | 5 | √ | null |
|
|
Whether the locker room should be displayed on the online map (Yes/No) |
||||||||||
| ICON_FILE_ID | int | 4 | √ | null |
|
|
The ID of the icon file to be displayed on the online map |
||||||||||
| ICON_FILE_NAME | varchar | 50 | √ | null |
|
|
The name of the icon file to be displayed on the online map |
||||||||||
| NOTES | varchar | 200 | √ | null |
|
|
Notes for the locker room |
||||||||||
| IS_RETIRED | varchar | 5 | √ | null |
|
|
Whether the locker room has been retired from further use (Yes/No) |
||||||||||
| 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 |