Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
64
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
TreeNodeID
NUMBER(10)
NOT NULL
Unique sequence number generated by
the database. Each node in the Domain
Explorer tree is assigned a unique number
that is used as an index to access group
information in other tables.
the database. Each node in the Domain
Explorer tree is assigned a unique number
that is used as an index to access group
information in other tables.
ParentType
NUMBER(2)
NOT NULL
Indicates that the parent is a group.
ParentId
NUMBER(10)
NOT NULL
ID of the group.
ChildType
NUMBER(2)
NOT NULL
Type of tree node. Values are:
1: Root node
2: Group node
3: NE node
1: Root node
2: Group node
3: NE node
ChildId
NUMBER(10)
NOT NULL
ID of the group or NE.
1.1.41 Ems_Alarm_Table
The Ems_Alarm_Table shows information about EMS alarms.
Primary key: EMS_ALARM_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-40: Ems_Alarm_Table
Column Name Oracle Data Type
Integrity
Constraints
Constraints
Description
Name
VARCHAR2(128)
—
Name of the alarm displayed to client.
alarmIndex
NUMBER(5)
—
EMS index of alarm or group.
isGroup
NUMBER(1)
—
Whether or not this alarm belongs to a
group. Values are:
0: FALSE
1: TRUE
group. Values are:
0: FALSE
1: TRUE
Severity
NUMBER(1)
DEFAULT 4
Alarm severity. Values are:
–1: N/A
4: Warning
5: Minor
6: Major
7: Critical
–1: N/A
4: Warning
5: Minor
6: Major
7: Critical
isEnabled
NUMBER(1)
DEFAULT 1
Whether or not the alarm is enabled.
Values are:
0: False
1: True
Values are:
0: False
1: True