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 |
||||||||||
| CENTER_ID | int | 4 | √ | null |
|
|
The ID of the center where the locker room is located |
||||||||||
| GENDER_INDEX | int | 4 | √ | null |
|
|
The ID of the gender that this locker room is assigned 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 |
||||||||||
| 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) |
||||||||||
| 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 |
|||||||||||
| LOCKER_ROOM_DESCRIPTION | varchar | 8000 | √ | null |
|
|
The locker room description |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| LOCKER_ROOMS_LOCKER_ROOM_ID_ORG_ID_PK | Primary key | Asc/Asc | LOCKER_ROOM_ID + ORG_ID |
| LOCKER_ROOMS_CENTER_ID_IX | Performance | Asc | CENTER_ID |
| LOCKER_ROOMS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |