Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| LOCKER_SCHEDULE_ID | int | 4 | null |
|
|
Locker schedule ID |
|||||
| LOCKER_ID | int | 4 | √ | null |
|
|
The ID of the reserved locker |
||||
| START_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The start date and time of the locker reservation |
||||
| END_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The end date and time of the locker reservation |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The transaction ID for the locker reservation |
||||
| SITE_ID | int | 4 | √ | null |
|
|
The ID of the site where the locker reservation was created |
||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
The ID of the workstation where the locker reservation was created |
||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who created the locker reservation |
||||
| 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_SCHEDULES_LOCKER_SCHEDULE_ID_ORG_ID_PK | Primary key | Asc/Asc | LOCKER_SCHEDULE_ID + ORG_ID |
| LOCKER_SCHEDULES_END_DATE_TIME_IX | Performance | Asc | END_DATE_TIME |
| LOCKER_SCHEDULES_LOCKER_ID_IX | Performance | Asc | LOCKER_ID |
| LOCKER_SCHEDULES_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| LOCKER_SCHEDULES_SITE_ID_IX | Performance | Asc | SITE_ID |
| LOCKER_SCHEDULES_START_DATE_TIME_IX | Performance | Asc | START_DATE_TIME |
| LOCKER_SCHEDULES_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |
| LOCKER_SCHEDULES_TRANSACTION_ID_IX | Performance | Asc | TRANSACTION_ID |
| LOCKER_SCHEDULES_WORKSTATION_ID_IX | Performance | Asc | WORKSTATION_ID |