Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
98
Tablespace: NGXP_DATA_TABLESPACE
Table 1-75: LinkId_To_UniqueId
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
LINKID
NUMBER(10)
NOT NULL
Key of the link in the LINK_TABLE table.
This is an internal field.
This is an internal field.
UNIQUEID
NUMBER(10)
NOT NULL
Key of the TP service in the MPLS_TP_EP
table. This is an internal field.
table. This is an internal field.
1.1.78 Managed_Et_Table
The Managed_Et_Table contains information about the managed entity table.
Primary key: MANAGED_ET_TAB_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-76: Managed_Et_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
Mng_Entity_Type
NUMBER(5)
NOT NULL
Managed entity type. Values are:
1: Circuit termination point (CTP)
2: VLAN
1: Circuit termination point (CTP)
2: VLAN
Mng_Entity_Id_Num
NUMBER(10)
NOT NULL
Managed entity ID number.
Mng_Entity_Id2_Num NUMBER(10)
NOT NULL
Managed entity ID 2 number.
NeDBAccessId
NUMBER(10)
NOT NULL
NE database ID.
FIELD1_Num
NUMBER(10)
NOT NULL
Polymorphic field module type.
FIELD2_Num
NUMBER(20)
NOT NULL
Polymorphic field physical location.
FIELD3_Num
NUMBER(20)
NOT NULL
Polymorphic field If index.
FIELD4_Num
NUMBER(10)
NOT NULL
Polymorphic field object index.
Customer_Id_Str
VARCHAR2(256) —
Customer ID string representation.
Service_Id_Str
VARCHAR2(256) —
Service ID string representation.
1.1.79 Matrix_Flow_Domain_Table
The Matrix_Flow_Domain_Table contains matrix flow domains (MFDs) and their
associated information.
associated information.
Primary key: MFD_TABLE_PK