Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ClientID | INT | 10 | 0 |
|
|
|||||
| LocationID | INT | 10 | 0 |
|
|
|||||
| ComputerID | INT | 10 | 0 |
|
|
|||||
| HotfixID | VARCHAR | 40 | null |
|
|
|||||
| HotfixTitle | VARCHAR | 255 | null |
|
|
|||||
| HotfixKB | VARCHAR | 30 | null |
|
|
|||||
| HotfixBulletin | VARCHAR | 255 | null |
|
|
|||||
| HotfixDescription | VARCHAR | 1024 | null |
|
|
|||||
| HotfixDateAdded | DATETIME | 19 | null |
|
|
|||||
| HotfixCategory | VARCHAR | 255 | null |
|
|
|||||
| HotfixSeverity | VARCHAR | 50 |
|
|
||||||
| HotfixPatchType | VARCHAR | 25 | null |
|
|
|||||
| HotfixOS | VARCHAR | 100 | null |
|
|
|||||
| HotfixIgnore | INT | 10 | null |
|
|
|||||
| HotfixApproved | INT | 10 | null |
|
|
|||||
| HotfixPushed | INT | 10 | null |
|
|
|||||
| HotfixInstalled | INT | 10 | null |
|
|
|||||
| HotfixFailed | INT | 10 | null |
|
|
|||||
| HotfixInstallDate | DATETIME | 19 | null |
|
|
|||||
| HotfixFinishedDate | DATETIME | 19 | null |
|
|
Relationships
Close relationships within degrees of separation
