Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| lsp_id | INT UNSIGNED | 10 | √ | null |
|
|
||
| vrf_oid | INT UNSIGNED | 10 | null |
|
|
|||
| lsp_oid | INT UNSIGNED | 10 | null |
|
|
|||
| device_id | INT UNSIGNED | 10 | null |
|
|
|||
| mplsLspRowStatus | enum('active', 'notInService', 'notReady', 'createAndGo', 'createAndWait', 'destroy') | 13 | null |
|
|
|||
| mplsLspLastChange | BIGINT | 19 | √ | NULL |
|
|
||
| mplsLspName | VARCHAR | 64 | null |
|
|
|||
| mplsLspAdminState | enum('noop', 'inService', 'outOfService') | 12 | null |
|
|
|||
| mplsLspOperState | enum('unknown', 'inService', 'outOfService', 'transition') | 12 | null |
|
|
|||
| mplsLspFromAddr | VARCHAR | 32 | null |
|
|
|||
| mplsLspToAddr | VARCHAR | 32 | null |
|
|
|||
| mplsLspType | enum('unknown', 'dynamic', 'static', 'bypassOnly', 'p2mpLsp', 'p2mpAuto', 'mplsTp', 'meshP2p', 'oneHopP2p', 'srTe', 'meshP2pSrTe', 'oneHopP2pSrTe') | 13 | null |
|
|
|||
| mplsLspFastReroute | enum('true', 'false') | 5 | null |
|
|
|||
| mplsLspAge | BIGINT | 19 | √ | NULL |
|
|
||
| mplsLspTimeUp | BIGINT | 19 | √ | NULL |
|
|
||
| mplsLspTimeDown | BIGINT | 19 | √ | NULL |
|
|
||
| mplsLspPrimaryTimeUp | BIGINT | 19 | √ | NULL |
|
|
||
| mplsLspTransitions | INT UNSIGNED | 10 | √ | NULL |
|
|
||
| mplsLspLastTransition | BIGINT | 19 | √ | NULL |
|
|
||
| mplsLspConfiguredPaths | INT UNSIGNED | 10 | √ | NULL |
|
|
||
| mplsLspStandbyPaths | INT UNSIGNED | 10 | √ | NULL |
|
|
||
| mplsLspOperationalPaths | INT UNSIGNED | 10 | √ | NULL |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | lsp_id |
| mpls_lsps_device_id_index | Performance | Asc | device_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors