Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
305
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
TL1_Port_Number
NUMBER(5)
—
Port number for the TL1 tunnel.
Default value is 3081.
Default value is 3081.
Tunnel_Status
NUMBER(1)
—
Status of tunnel. Values are:
0: Initial
1: Open
2: Close
0: Initial
1: Open
2: Close
Tunnel_Description
VARCHAR(256) —
Description for the tunnel.
1.1.251
Transaction_Log_Table
The Transaction_Log_Table stores information about Prime Optical transactions.
Primary key: TRANSACTION_LOG_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-240: Transaction_Log_Table
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
TransId
NUMBER(20)
NOT NULL
Transaction ID generated by the
database sequence.
database sequence.
NEDBAccessID
NUMBER(10)
NOT NULL
Source node for circuit and network
provisioning; same as NEDBAccessID in
the NE_Info_Table.
provisioning; same as NEDBAccessID in
the NE_Info_Table.
TimeStamp
DATE
—
When the transaction occurred.
UserName
VARCHAR2(64)
—
Name of the Prime Optical user.
ActionName
VARCHAR2(64)
—
Name of the transaction.
Result
NUMBER(1)
—
Whether the transaction succeeded or
failed. Values are:
0: Failure
1: Success
failed. Values are:
0: Failure
1: Success
Parms
VARCHAR2(2048)
—
Name/value pairs: name1:values1, and
so on.
so on.
ClassName
VARCHAR2(64)
—
Name of the class from which the
transaction was generated.
transaction was generated.
Module
NUMBER(2)
—
ID of the predefined modules.
LogMessage
VARCHAR2(1024)
—
Transaction log message.
Service
VARCHAR2(64)
—
Name of the service that logged this
entry (for example, ONS 15454 NE
Service).
entry (for example, ONS 15454 NE
Service).