Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
284
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
PMParamID
NUMBER(10)
—
—
PMTableName
VARCHAR2(256)
NOT NULL
PM table name.
PMTableParam
VARCHAR2(256)
NOT NULL
PM table parameter name.
PMTableColNo
NUMBER(10)
—
Table column number.
DBColType
VARCHAR(64)
—
Database column type.
DBColSize
NUMBER(10)
—
Database column size.
TMFNAME
VARCHAR2(64)
DEFAULT N/A
TMF PM parameter name specified in
the Prime Optical GateWay/CORBA
implementation agreement.
the Prime Optical GateWay/CORBA
implementation agreement.
LOCATION
NUMBER(2)
DEFAULT 0
Near-end or far-end location
information.
information.
DIRECTION
NUMBER(2)
DEFAULT 0
Receive or transmit direction
information.
information.
1.1.222
PM_Historical_Appointments
The PM_Historical_Appointments table contains information about the PM data
collection schedule.
collection schedule.
For medium, large, and high-end configurations, this table is partitioned.
Primary key: PM_HISTORICAL_APPOINTMENTS_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-212: PM_Historical_Appointments
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEDbaccessid
NUMBER(10)
NOT NULL
NEDBaccessid of the purged NE; same as
NEDBaccessID in the NE_Info_Table.
NEDBaccessID in the NE_Info_Table.
IntervalType
NUMBER(1)
NOT NULL
Types of intervals. Values are:
0: 15 minutes
1: 24 hours
0: 15 minutes
1: 24 hours
OriginalSchedu
ledTime
ledTime
DATE
NOT NULL
Originally scheduled PM collection time.