Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
76
Primary key: IF_DWDM_CHAN_FREQ_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-55: IF_DWDM_Channel_Group
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
IFDBAccessID
NUMBER(10)
NOT NULL
Reference to IFDBAccessID in the
MIB2_Interface_Table.
MIB2_Interface_Table.
NEDBAccessID
NUMBER(10)
NOT NULL
ID to access this table for an NE; same as
NEDBAccessID in the NE_INFO_TABLE.
NEDBAccessID in the NE_INFO_TABLE.
MinFrequency
NUMBER(10)
NOT NULL
Lowest frequency in the bitmap for bit 0.
Spacing
NUMBER(4)
NOT NULL
Frequency spacing between successive
bits.
bits.
BitmapLogic
NUMBER(2)
DEFAULT 1
Whether frequencies in the bitmap are
carried or blocked. Values are:
1: Carried
2: Blocked
carried or blocked. Values are:
1: Carried
2: Blocked
Bitmap
VARCHAR2(64)
NOT NULL
List of frequencies as a bitmap.
1.1.58 IF_Optical_Phy_Config_Table
The IF_Optical_Phy_Config_Table describes extended physical properties for certain
interfaces.
interfaces.
Primary key: IF_OPTICAL_PHY_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-56: IF_Optical_Phy_Config_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints Description
Constraints Description
IFDBAccessID
NUMBER(10) NOT NULL
Reference to IFDBAccessID in the
MIB2_Interface_Table.
MIB2_Interface_Table.
NEDBAccessID
NUMBER(10) NOT NULL
ID to access this table for an NE; same as
NEDBAccessID in the NE_INFO_TABLE.
NEDBAccessID in the NE_INFO_TABLE.
IfMode
NUMBER(2)
DEFAULT 1
Mode of operation. Values are:
1: mode2R
2: mode3R
1: mode2R
2: mode3R