Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| LOCKER_BANK_ID | int | 4 | null |
|
|
The locker bank ID |
|||||
| LOCKER_BANK_NAME | varchar | 150 | √ | null |
|
|
The locker bank name |
||||
| LOCKER_ROOM_ID | int | 4 | √ | null |
|
|
The locker room ID |
||||
| PREFIX | varchar | 6 | √ | null |
|
|
The prefix to append when generating locker numbers |
||||
| SUFFIX | varchar | 6 | √ | null |
|
|
The suffix to append when generating locker numbers |
||||
| FROM_NUMBER | int | 4 | √ | null |
|
|
The starting number to use when generating locker numbers |
||||
| EXCLUDE | varchar | 15 | √ | null |
|
|
The numbers to be excluded when generating locker numbers (Even Numbers / Odd Numbers / None) |
||||
| LOCKER_SIZE_ID | int | 4 | √ | null |
|
|
The locker size ID |
||||
| TIME_PERIOD | varchar | 20 | √ | null |
|
|
The time period to use for locker reservations (Hourly / Daily / Weekly / Monthly (duration) / Monthly (calendar) / Yearly / Defined Date Ranges / Specific Period) |
||||
| LOCKER_ROWS | int | 4 | √ | null |
|
|
The number of rows of lockers in the locker bank |
||||
| LOCKER_COLUMNS | int | 4 | √ | null |
|
|
The number of columns of lockers in the locker bank |
||||
| 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) |
|---|---|---|---|
| LOCKER_BANKS_LOCKER_BANK_ID_ORG_ID_PK | Primary key | Asc/Asc | LOCKER_BANK_ID + ORG_ID |
| LOCKER_BANKS_LOCKER_ROOM_ID_IX | Performance | Asc | LOCKER_ROOM_ID |
| LOCKER_BANKS_LOCKER_SIZE_ID_IX | Performance | Asc | LOCKER_SIZE_ID |
| LOCKER_BANKS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |