Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
115
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
DESCRIPTION
VARCHAR2(256) —
Description of the service has been
provisioned.
provisioned.
SLOTMODULETYPE
NUMBER(10)
NOT NULL
Slot module type. This is an
internal field.
internal field.
PORTMODULETYPE
NUMBER(10)
NOT NULL
Port module type. This is an
internal field.
internal field.
1.1.105
NE_Audit_Trail_Table
The NE_Audit_Trail_Table shows ONS 15327 and ONS 15454 audit trail information.
Primary key: NE_AUDIT_TRAIL_TABLE_PK
Tablespace: ONS15454_DATA_TABLESPACE
For medium, large, and high-end configurations, this table is partitioned.
Table 1-103: NE_Audit_Trail_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
table.
same as NEDBAccessID in the NE
table.
SequenceNumber
NUMBER(6)
NOT NULL
Sequence number of the entry.
Possible values are 1 to 59,999.
Possible values are 1 to 59,999.
Timestamp
DATE
NOT NULL
Time stamp in Greenwich Mean
Time (GMT).
Time (GMT).
OperationDescription
VARCHAR2(256)
NOT NULL
Server combines information
obtained from multiple sources to
create the description.
obtained from multiple sources to
create the description.
OperationStatus
VARCHAR2(1)
—
Operational status. Values are:
P: Passed
F: Failed
X: Aborted
P: Passed
F: Failed
X: Aborted
NEUserId
VARCHAR2(64)
—
CTC user ID.
1.1.106
NE_INFO_TABLE
The NE_INFO_TABLE contains information about all NEs managed by Prime Optical.
Primary key: NE_INFO_PK