Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
99
Tablespace: BASE_DATA_TABLESPACE
Table 1-77: Matrix_Flow_Domain_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
MFD_NE_DB_ID
NUMBER(10)
NOT NULL
MFD ID.
FD_NAME
VARCHAR2(128) —
Flow domain to which this MFD is
associated, if any.
associated, if any.
MFD_USER_LABEL
VARCHAR2(64)
—
Description of the MFD.
MFD_NATIVE_NAME
VARCHAR2(64)
NOT NULL
Native name of the MFD.
MFD_OWNER
VARCHAR2(64)
—
Owner of the MFD.
MFD_TRANSM_PARA
MS
MS
VARCHAR2(512) —
Transmission parameters of the
MFD.
MFD.
MFD_NET_ACCESS_D
OMAIN
OMAIN
VARCHAR2(64)
—
Network access domain of the
MFD.
MFD.
MFD_FLEXIBLE
NUMBER(1)
—
Flexibility of the MFD.
MFD_ADDITIONAL_IN
FO
FO
VARCHAR2(512) —
Additional information of the MFD.
1.1.80 MIB2_Interface_Table
The MIB2_Interface_Table corresponds to the MIB2 table in IF-MIB.
Primary key: MIB2_INTERFACE_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-78: MIB2_Interface_Table
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
IFDBAccessID
NUMBER(10)
NOT NULL
Unique sequence number generated by
the database.
the database.
NEDBAccessID
NUMBER(10)
NOT NULL
Refers to the NEDBAccessID in the
NE_INFO_TABLE.
NE_INFO_TABLE.
PhysicalLoc
NUMBER(20)
NOT NULL
Physical location.
ModuleType
NUMBER(8)
DEFAULT 0
Module type.
NEIfIndex
NUMBER(20)
NOT NULL
Encoded value for name derivation.
ObjectType
NUMBER(10)
NOT NULL
Object type.
ModelType
NUMBER(5)
NOT NULL
Model type.