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