Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| QueueID | INT | 10 | √ | null |
|
|
||
| ComputerID | INT | 10 | null |
|
|
|||
| TimeStart | DATETIME | 19 | null |
|
|
|||
| Duration | INT | 10 | null |
|
|
|||
| Mode | INT | 10 | null |
|
|
|||
| UserID | INT | 10 | null |
|
|
|||
| Comments | VARCHAR | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | QueueID |
| AT_idx_maintenancemodequeue_v1 | Performance | Asc/Asc/Asc/Asc/Asc/Asc | QueueID + ComputerID + TimeStart + Duration + Mode + UserID |
| ComputerID | Performance | Asc | ComputerID |
| TimeStart | Performance | Asc | TimeStart |
Diagram producer might be missing
No diagrams were produced please see application output for any errors