Cisco Cisco Prime Optical 9.6 Références techniques
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
145
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
StrCorbaTIDAI
D
D
VARCHAR2(512
)
)
—
Stores the TL1 target identifier (TID) value
returned by the getCTMHistoryPMData
API for each physical termination point
(PTP). The getCTMHistoryPMData API
stores the historical PM data output in a
.csv file. The PTP native name is one of the
output parameters displayed in this file. It
contains the rack, shelf, slot, and port
information for the PTP. It also contains
pluggable port module (PPM) information,
if applicable.
returned by the getCTMHistoryPMData
API for each physical termination point
(PTP). The getCTMHistoryPMData API
stores the historical PM data output in a
.csv file. The PTP native name is one of the
output parameters displayed in this file. It
contains the rack, shelf, slot, and port
information for the PTP. It also contains
pluggable port module (PPM) information,
if applicable.
1.1.137
ONS15454_Active_User_Table
The ONS15454_Active_User_Table contains information about the ONS 15454 SONET
and ONS 15454 SDH Active Users Table.
and ONS 15454 SDH Active Users Table.
Primary key: ONS15454_ACTIVE_USER_TABLE_PK
Tablespace: ONS15454_DATA_TABLESPACE
Table 1-133 : ONS15454_Active_User_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
ID to access this table for an NE.
UserID
VARCHAR2(64)
NOT NULL
Cisco ONS 15454 username.
ClientIp
VARCHAR2(64)
NOT NULL
Client IP address.
SessionType
VARCHAR2(20)
DEFAULT
NULL
NULL
Type of session.
LastLoginTime
DATE
DEFAULT
NULL
NULL
Date and time of most recent user login.
LastActivityTime
DATE
DEFAULT
NULL
NULL
Date and time of most recent user
activity.
activity.
SessionTicket
NUMBER(10)
DEFAULT 0
Ticket for the session.
1.1.138
ONS15454_CBQoS_Info_Table
Primary key: ONS15454_CBQOS_INFO_PK
Tablespace: ONS15454_DATA_TABLESPACE
Table 1-134: ONS15454_CBQoS_Info_Table