Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
282
Primary key: LINKID_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-207: PatchCord_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
LinkID
NUMBER(8)
NOT NULL
Unique number created by the database.
VirtualLinkIdSrc
NUMBER(10)
DEFAULT –1
Source virtual link identifier.
VirtualLinkIdDst
NUMBER(10)
DEFAULT –1
Destination virtual link identifier.
1.1.218
PM_ATTR_Value_Mapping_Table
The PM_ATTR_Value_Mapping_Table is used to map real-time polling result values to
different display values.
different display values.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-208: PM_ATTR_Value_Mapping_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
PMViewName
VARCHAR2(64)
NOT NULL
Specifies the PM table.
ATTRIndex
NUMBER(5)
NOT NULL
Index from ObjectAttribute table.
ATTRValue
VARCHAR2(64)
NOT NULL
Returned attribute value from the real-
time PM query.
time PM query.
DisplayText
VARCHAR2(64)
NOT NULL
Text displayed in PM columns.
1.1.219
PM_ATTRID_Mapping_Table
The PM_ATTRID_Mapping_Table contains mapping information about the retrieval of
real-time PM data from the NE.
real-time PM data from the NE.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-209: PM_ATTRID_Mapping_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description