Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
290
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
This is an internal field.
This is an internal field.
PHYLOC
NUMBER(20)
NOT NULL
Physical object ID managed by the Prime
Optical system. This is an internal field.
Optical system. This is an internal field.
CTMUNIQID
NUMBER(10)
NOT NULL
Prime Optical ID used to identify the
contributor in the service. This is an
internal field.
contributor in the service. This is an
internal field.
SERVICENAME
VARCHAR2(256
)
)
—
Service name.
ROUTEID
VARCHAR2(256
)
)
NOT NULL
The route IP address.
ISPROTECTED
NUMBER(1)
NOT NULL
Endpoint protection. Values are:
0: Unprotected
1: Protected
0: Unprotected
1: Protected
ENABLEDELAY
NUMBER(10)
NOT NULL
Enabled delay value has been provisioned.
ISNEVERDISABL
E
E
NUMBER(1)
NOT NULL
Whether the never disable option is
enabled or disabled. Values are:
0: Disabled
1: Enabled
enabled or disabled. Values are:
0: Disabled
1: Enabled
DISABLEDELAY
NUMBER(10)
NOT NULL
Disabled delay value has been
provisioned.
provisioned.
TINFOTYPE
NUMBER(10)
NOT NULL
Endpoint type has been provisioned.
OPERSTATE
NUMBER(1)
NOT NULL
Operation status of the endpoint.
IFPORTINDEX
NUMBER(10)
NOT NULL
Physical object ID managed by the NE.
ADMINSTATE
NUMBER(1)
NOT NULL
Administrative status of the endpoint.
RXBW
NUMBER(20)
NOT NULL
Transmission bandwidth value has been
provisioned.
provisioned.
TXBW
NUMBER(20)
NOT NULL
Receiver bandwidth value has been
provisioned.
provisioned.
DESCRIPTION
VARCHAR2(256
)
)
—
Description of the service has been
provisioned.
provisioned.
SLOTMODULET
YPE
YPE
NUMBER(10)
NOT NULL
Slot module type. This is an internal field.
PORTMODULE
TYPE
TYPE
NUMBER(10)
NOT NULL
Port module type. This is an internal field.
1.1.230
PW_PP
The PW_PP stores the information related to the path point contributors for the
pseudowire services.
pseudowire services.
Primary key: PW_PP_PK
Table 1-220: PW_PP