Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
46
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
CktSpanCDLFlowID
NUMBER(3)
DEFAULT –1
(Applicable only to ONS 155xx
circuits) Source CDL flow identifier.
The valid range is from 0 to 254.
circuits) Source CDL flow identifier.
The valid range is from 0 to 254.
CktSpanSrcPortName
VARCHAR2(64) —
Span source port name of the circuit.
CktSpanDestPortName VARCHAR2(64) —
Span destination name of the circuit.
CktUpsrSpanSrcState
NUMBER(2)
—
UPSR (SNCP) status selector at the
edge of the span at the source side.
edge of the span at the source side.
CktUpsrSpanDstState
NUMBER(2)
—
UPSR (SNCP) status selector at the
edge of the span at the destination
side.
edge of the span at the destination
side.
NPID
NUMBER(10)
DEFAULT 0
Network partition ID to which the
subnetwork belongs.
subnetwork belongs.
1.1.24 Circuit_Span_Tbl
The Circut_Span_Tbl contains information about spans associated with circuits.
Primary key: None
Foreign key: FK_CIRCUIT_SPAN_NPID
Tablespace: BASE_DATA_TABLESPACE
For medium, large, and high-end configurations, this table is partitioned.
Table 1-23: Circuit_Span_Tbl
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
CktSpanId
NUMBER(10)
NOT NULL
Unique sequence number
generated by the database.
generated by the database.
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.
node. This is an internal field. The
CktNodeId and CktUniqueId
combine to form a circuit ID that is
unique in the network.
CktLinkId
NUMBER(10)
—
ID of the link to which this span
belongs.
belongs.
CktSpanSrcNodeId
NUMBER(10)
—
Node ID of the span source.