Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ClientID | INT | 10 | null |
|
|
|||||
| HotfixID | VARCHAR | 40 | null |
|
|
|||||
| PatchKB | VARCHAR | 30 | null |
|
|
|||||
| PatchTitle | VARCHAR | 255 | null |
|
|
|||||
| PatchOS | VARCHAR | 255 | √ | null |
|
|
||||
| PatchCategory | VARCHAR | 255 | null |
|
|
|||||
| PatchSeverity | VARCHAR | 50 | null |
|
|
|||||
| PatchCVSSScore | DOUBLE | 22 | null |
|
|
|||||
| PatchDateReleased | DATETIME | 19 | null |
|
|
|||||
| PatchesApproved | BIGINT | 19 | 0 |
|
|
|||||
| PatchesInstalled | INT | 10 | null |
|
|
|||||
| PatchesFailed | INT | 10 | null |
|
|
|||||
| PatchesNotAttemped | INT | 10 | null |
|
|
Relationships
Close relationships within degrees of separation
