Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
28
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
majoralarmcount
NUMBER(20)
DEFAULT 0
Major alarm count.
criticalalarmcount
NUMBER(20)
DEFAULT 0
Critical alarm count.
warningalarmcount
NUMBER(20)
DEFAULT 0
Warning alarm count.
1.1.7 Alarm_Event_Cause_Table
The Alarm_Event_Cause_Table statically maps alarm and event cause indexes to strings.
Primary key: ALARM_EVENT_CAUSE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-7: Alarm_Event_Cause_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
EnumIndex
NUMBER(4)
—
Index of alarm or event cause.
EnumString
VARCHAR2(64)
—
Alarm or event cause string for the
EnumIndex.
EnumIndex.
1.1.8 Alarm_Event_Table
The Alarm_Event_Table contains information about all events reported by NEs.
Primary key: None
Tablespace: EVENT_DATA_TABLESPACE
Table 1-8: Alarm_Event_Cause_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
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.
EventIndex
NUMBER(10)
NOT NULL
Index of alarm or event. Unique
sequence number generated by the
database.
sequence number generated by the
database.
ModuleOrIfIndex
NUMBER(20)
NOT NULL
Unique integer that identifies an
interface in the NE; same as
ifStaticIndex in the Interface_Table.
interface in the NE; same as
ifStaticIndex in the Interface_Table.