Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
78
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
ModelType
NUMBER(10)
NOT NULL
Model type.
ObjectType
NUMBER(10)
NOT NULL
Object type.
AttributeNameConst
NUMBER(10)
NOT NULL
Integer constant of the attribute.
AttrOrder
NUMBER(10)
NOT NULL
Sequential number.
AttrSize
NUMBER(10)
NOT NULL
Size of the attribute in bytes.
AttrType
NUMBER(10)
NOT NULL
Type of the attribute.
1.1.60 Interface_APS_Info
The Interface_APS_Info table contains APS information about interfaces that are
members of an APS group.
members of an APS group.
Primary key: IF_APS_INFO_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-58: Interface_APS_Info
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.
same as NEDBAccessID in the
NE_INFO_TABLE.
ApsGroupName
VARCHAR2(64) —
APS group name.
ApsChanNumber
NUMBER(2)
DEFAULT –1
Working or protected channel.
ApsChanStatusCurrent
NUMBER(2)
DEFAULT –1
Current state of interface in the
group:
1: Locked out
2: Signal degrade
3: Signal failure
4: Switched
group:
1: Locked out
2: Signal degrade
3: Signal failure
4: Switched
ApsChanLastSwitchover DATE
—
Time since switch to protection
channel.
channel.
ApsInterfaceState
NUMBER(2)
DEFAULT –1
Active or standby:
–1: Unknown
1: Active
2: Standby
–1: Unknown
1: Active
2: Standby