Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ClientID | INT | 10 | 0 |
|
|
|||
| ClientName | VARCHAR | 100 |
|
|
||||
| LocationID | INT | 10 | 0 |
|
|
|||
| LocationName | VARCHAR | 50 | null |
|
|
|||
| LocationAddress | VARCHAR | 50 | null |
|
|
|||
| LocationCity | VARCHAR | 52 | √ | null |
|
|
||
| LocationZip | VARCHAR | 10 | null |
|
|
|||
| LocationCountry | VARCHAR | 20 | null |
|
|
|||
| LocationPhone | VARCHAR | 30 | null |
|
|
|||
| LocationFax | VARCHAR | 30 | null |
|
|
|||
| LocationComments | VARCHAR | 500 | " " |
|
|
|||
| LocationRouterModel | VARCHAR | 106 | √ | null |
|
|
||
| LocationRouterAddress | VARCHAR | 267 | √ | null |
|
|
||
| LocationContact | VARCHAR | 101 | √ | null |
|
|
||
| LocationMaintenanceWindow | VARCHAR | 50 | √ | null |
|
|
||
| LocationDefaultGroup | VARCHAR | 50 | √ | null |
|
|
||
| LocationDefaultLoginTitle | VARCHAR | 50 | √ | null |
|
|
||
| LocationDefaultLogin | VARCHAR | 100 | √ | null |
|
|
||
| LocationTotalServers | DECIMAL | 25 | 0 |
|
|
|||
| LocationTotalWorkstations | DECIMAL | 23 | 0 |
|
|
|||
| LocationTotalNetworkDevices | BIGINT | 19 | √ | null |
|
|
||
| LocationTotalMobileDevices | INT | 10 | 0 |
|
|
|||
| LocationTotalRetiredComputers | BIGINT | 19 | √ | null |
|
|
||
| LocationTotalRetiredNetDevices | BIGINT | 19 | √ | null |
|
|