Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ClientID | INT | 10 | 0 |
|
|
|||
| LocationID | INT | 10 | 0 |
|
|
|||
| Installed | DECIMAL | 45 | √ | null |
|
|
||
| Fully Patched | DECIMAL | 32 | √ | null |
|
|
||
| Missing 1-2 Patches | DECIMAL | 32 | √ | null |
|
|
||
| Missing 3-5 Patches | DECIMAL | 32 | √ | null |
|
|
||
| Missing 6+ Patches | DECIMAL | 32 | √ | null |
|
|
||
| PTotal | DECIMAL | 42 | √ | null |
|
|