Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| svc_id | INT UNSIGNED | 10 | √ | null |
|
|
||
| svc_oid | INT UNSIGNED | 10 | null |
|
|
|||
| device_id | INT UNSIGNED | 10 | null |
|
|
|||
| svcRowStatus | enum('active', 'notInService', 'notReady', 'createAndGo', 'createAndWait', 'destroy') | 13 | √ | NULL |
|
|
||
| svcType | enum('unknown', 'epipe', 'tls', 'vprn', 'ies', 'mirror', 'apipe', 'fpipe', 'ipipe', 'cpipe', 'intTls', 'evpnIsaTls') | 10 | √ | NULL |
|
|
||
| svcCustId | INT UNSIGNED | 10 | √ | NULL |
|
|
||
| svcAdminStatus | enum('up', 'down') | 4 | √ | NULL |
|
|
||
| svcOperStatus | enum('up', 'down') | 4 | √ | NULL |
|
|
||
| svcDescription | VARCHAR | 80 | √ | NULL |
|
|
||
| svcMtu | INT | 10 | √ | NULL |
|
|
||
| svcNumSaps | INT | 10 | √ | NULL |
|
|
||
| svcNumSdps | INT | 10 | √ | NULL |
|
|
||
| svcLastMgmtChange | BIGINT | 19 | √ | NULL |
|
|
||
| svcLastStatusChange | BIGINT | 19 | √ | NULL |
|
|
||
| svcVRouterId | INT | 10 | √ | NULL |
|
|
||
| svcTlsMacLearning | enum('enabled', 'disabled') | 8 | √ | NULL |
|
|
||
| svcTlsStpAdminStatus | enum('enabled', 'disabled') | 8 | √ | NULL |
|
|
||
| svcTlsStpOperStatus | enum('up', 'down') | 4 | √ | NULL |
|
|
||
| svcTlsFdbTableSize | INT | 10 | √ | NULL |
|
|
||
| svcTlsFdbNumEntries | INT | 10 | √ | NULL |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | svc_id |
| mpls_services_device_id_index | Performance | Asc | device_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors