Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| UserID | INT | 10 | 0 |
|
|
|||
| ClientID | INT | 10 | 0 |
|
|
|||
| ReportCompanyName | MEDIUMTEXT | 16777215 | √ | null |
|
|
||
| ClientName | VARCHAR | 50 |
|
|
||||
| ClientCompany | VARCHAR | 100 |
|
|
||||
| ClientArea | VARCHAR | 52 | √ | null |
|
|
||
| LocationID | INT | 10 | 0 |
|
|
|||
| LocationName | VARCHAR | 50 | null |
|
|
|||
| LocationArea | VARCHAR | 52 | √ | null |
|
|
||
| DeviceID | INT | 10 | 0 |
|
|
|||
| DeviceLocalIP | VARCHAR | 35 | null |
|
|
|||
| DeviceName | VARCHAR | 50 | null |
|
|
|||
| DeviceType | VARCHAR | 255 | √ | null |
|
|
||
| DeviceIcon | BLOB | 65535 | √ | null |
|
|
||
| DeviceMAC | VARCHAR | 30 | null |
|
|
|||
| DeviceAssetDate | DATETIME | 19 | null |
|
|
|||
| DeviceDateLastInventory | DATETIME | 19 | null |
|
|
|||
| DeviceDateLastContact | DATETIME | 19 | null |
|
|
|||
| DeviceUptime | BIGINT | 19 | null |
|
|
|||
| DeviceDataIn | BIGINT | 19 | null |
|
|
|||
| DeviceDataOut | BIGINT | 19 | null |
|
|
|||
| DeviceStatus | INT | 10 | null |
|
|
|||
| DeviceManufacturer | VARCHAR | 255 | √ | null |
|
|
||
| DeviceModel | VARCHAR | 255 | √ | null |
|
|
||
| DeviceSNMPTree | VARCHAR | 50 | √ | null |
|
|
||
| DeviceAccessPasswordTitle | VARCHAR | 50 | √ | null |
|
|
||
| DeviceProbeAgentID | INT | 10 | null |
|
|
|||
| DeviceSyncedToManage | VARCHAR | 5 |
|
|
||||
| DeviceDetectionTemplate | VARCHAR | 255 | √ | null |
|
|