Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
24
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
AckIndex
NUMBER(10)
NOT NULL
Index of the alarm acknowledgement.
ActiveAlarmFla
g
g
NUMBER(1)
DEFAULT 0
Active alarm flag, which the server uses to
synchronize the database to the NE
information.
synchronize the database to the NE
information.
ActiveAlarmCo
mment
mment
VARCHAR2(201
4)
4)
—
Alarm comments.
ClearAlarmTim
eStamp
eStamp
DATE
DEFAULT NULL
Date and time when the alarm was
cleared.
cleared.
NEAlarmTimeS
tamp
tamp
DATE
NOT NULL
Date and time when the alarm was
generated as viewed by the NE.
generated as viewed by the NE.
ActiveAlarmInd
ex
ex
NUMBER(16)
NOT NULL
Unique alarm sequence number as
created by the database.
created by the database.
ModuleType
NUMBER(8)
DEFAULT 0
Module type.
PhysicalLoc
NUMBER(20)
DEFAULT 0
Physical location.
Alarmstatus
NUMBER(1)
NOT NULL
Indicates whether an alarm is active or
clear. Values are:
0: Active
1: Clear
clear. Values are:
0: Active
1: Clear
NEAlarmClearT
imeStamp
imeStamp
DATE
—
When the NE alarm was cleared.
ExternalConditi
on
on
VARCHAR2(102
4)
4)
—
External environment condition for the
NEs.
NEs.
ModelType
NUMBER(10)
DEFAULT 0
Model type.
ObjectType
NUMBER(10)
DEFAULT 0
Object type.
StrObjectInstan
ce
ce
VARCHAR2(256
)
)
—
StrObjInstance name.
Direction
VARCHAR2(8)
DEFAULT NULL
TL1 direction.
Location
VARCHAR2(4)
DEFAULT NULL
TL1 location.
1.1.3 Additional_Device_Info
The Additional_Device_Info contains information on additional devices.
Primary key: ADDITIONAL_DEVICE_INFO
Tablespace: BASE_DATA_TABLESPACE
Table 1-3: Additional_Device_Info
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
DeviceID
NUMBER(10)
NOT NULL
Unique ID generated by the
database.
database.