Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
32
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
SwitchedChannelStatus NUMBER(2)
DEFAULT 0
Protection channel number.
1.1.12 Audit_Log_Mapping_Table
The Audit_Log_Mapping_Table contains information about audit log mapping.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-12: Audit_Log_Mapping_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
UserType
NUMBER(10)
—
Defines whether user type is Service or
User.
User.
ActualName
VARCHAR(256)
—
Name agreed upon by client and server.
CurrentName
VARCHAR(256)
—
Name currently used by the server.
1.1.13 Audit_Log_Table
The Audit_Log_Table is obsolete.
1.1.14 BLSR_Node
The BLSR_Node contains information about the BLSR node.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-13: BLSR_Node
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
BLSRID
NUMBER(8)
NOT NULL
BLSR ID.
RINGID
VARCHAR(8)
NOT NULL
Ring ID.
NODEID
NUMBER(8)
NOT NULL
Node ID.
RINGNODEID
NUMBER(8)
NOT NULL
Ring node ID.
1.1.15 BLSR_Span
The BLSR_Span contains information about the BLSR span.