Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ClientID | INT | 10 | 0 |
|
|
|||
| TotalComputers | DECIMAL | 32 | √ | null |
|
|
||
| ActiveComputers | DECIMAL | 32 | √ | null |
|
|
||
| TotalDevices | DECIMAL | 32 | √ | null |
|
|
||
| ActiveDevices | DECIMAL | 32 | √ | null |
|
|
||
| RetiredAssets | DECIMAL | 32 | √ | null |
|
|
||
| MasterComputers | DECIMAL | 32 | √ | null |
|
|
||
| Servers | DECIMAL | 32 | √ | null |
|
|
||
| WorkStations | DECIMAL | 32 | √ | null |
|
|
||
| Mobile | DECIMAL | 32 | √ | null |
|
|
||
| Smartphones | DECIMAL | 32 | √ | null |
|
|
||
| Tablets | DECIMAL | 32 | √ | null |
|
|
||
| Statdate | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|