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 |
|
|