Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
LTJobID | INT | 10 | √ | null |
|
|
||||
PluginGUID | VARCHAR | 36 | null |
|
|
|||||
DefinitionGUID | VARCHAR | 36 | null |
|
|
|||||
ComputerID | INT | 10 | null |
|
|
|||||
JobTypeID | INT | 10 | null |
|
|
|||||
JobSubTypeID | INT | 10 | null |
|
|
|||||
SolutionJobID | VARCHAR | 36 | null |
|
|
|||||
StartTime | DATETIME | 19 | null |
|
|
|||||
EndTime | DATETIME | 19 | null |
|
|
|||||
JobStatus | INT | 10 | null |
|
|
|||||
LastUpdated | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | LTJobID |