Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ComputerID | INT | 10 | null |
|
|
|||
| PnPDeviceID | VARCHAR | 255 | null |
|
|
|||
| AdapterType | VARCHAR | 255 | null |
|
|
|||
| MAC | VARCHAR | 255 | null |
|
|
|||
| IPAddress | VARCHAR | 255 | null |
|
|
|||
| NetMask | VARCHAR | 255 | null |
|
|
|||
| Gateway | VARCHAR | 255 | null |
|
|
|||
| DateUpdated | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
|||
| IPv6 | VARCHAR | 64 | null |
|
|
|||
| Status | VARCHAR | 100 | null |
|
|
|||
| Speed | INT | 10 | null |
|
|
|||
| Description | VARCHAR | 255 | null |
|
|
|||
| BytesRec | BIGINT | 19 | null |
|
|
|||
| BytesSent | BIGINT | 19 | null |
|
|
|||
| MTU | INT | 10 | null |
|
|
|||
| DHCPEnabled | INT | 10 | null |
|
|
|||
| RoutingEnabled | INT | 10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | ComputerID + PnPDeviceID |
| MacAddress | Performance | Asc | MAC |
Diagram producer might be missing
No diagrams were produced please see application output for any errors