Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
97
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NumWarningAlarms
NUMBER(8)
DEFAULT 0
Number of warning alarms on
the link.
the link.
LinkSrcPhyLocUnManaged
VARCHAR2(30)
DEFAULT
NULL
NULL
Source physical location if
unmanaged NE is a termination
point.
unmanaged NE is a termination
point.
LinkDestPhyLocUnmanaged VARCHAR2(30)
DEFAULT
NULL
NULL
Destination physical location if
unmanaged NE is a termination
point.
unmanaged NE is a termination
point.
LinkUnmanaged
NUMBER(1)
DEFAULT 0
Whether a link has at least one
unmanaged NE. Values are:
0: False
1: True
unmanaged NE. Values are:
0: False
1: True
LinkCost
NUMBER(10)
DEFAULT 1
Link weight.
LinkSrlgList
VARCHAR2(256) DEFAULT
NULL
User-defined SRL groups for the
link.
link.
STSize
NUMBER(8)
DEFAULT –1
Size of a server trail.
STType
NUMBER(8)
DEFAULT –1
Type of a server trail.
STCount
NUMBER(8)
DEFAULT –1
Number of server trails created.
STNodeId
NUMBER(10)
DEFAULT –1
Node ID of a server trail.
STUniqueId
NUMBER(10)
DEFAULT –1
Unique ID of a server trail.
LinkAliasName
VARCHAR2(256) —
User-defined alias for the link.
LinkBlsrRingId
VARCHAR(8)
—
BLSR ring ID for the link.
LinkDstCTCIndex
NUMBER(8)
—
Static CTC index at the
destination. This is an internal
field.
destination. This is an internal
field.
LinkSrcCTCIndex
NUMBER(8)
—
Static CTC index at the source.
This is an internal field.
This is an internal field.
CktNodeID
NUMBER(10)
—
Node ID of the circuit's source
node. This is an internal field.
node. This is an internal field.
CktUniqueID
NUMBER(10)
—
Unique number within each
source node. This is an internal
field. The CktNodeId and
CktUniqueId combine to form a
circuit ID that is unique in the
network.
source node. This is an internal
field. The CktNodeId and
CktUniqueId combine to form a
circuit ID that is unique in the
network.
1.1.77 LinkId_To_UniqueId
The LinkId_To_UniqueId table stores the relation among the Transport Profile (TP)
tunnel links and the TP services.
tunnel links and the TP services.
Primary key: LINKID_TO_UNIQUEID_PK