Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
44
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
UserId
NUMBER(4)
—
User ID.
CircuitSizeType
NUMBER(2)
—
Circuit size.
CircuitSizeId
NUMBER(2)
—
Circuit size ID.
CircuitSizeName
VARCHAR2(32)
—
Name of the circuit size.
1.1.23 Circuit_Span_BS_Tbl
The Circuit_Span_BS_Tbl stores circuit span information. Each span consists of the span
base information, span source circuit termination point, and span destination circuit
termination point. The span base information is stored in the Circuit_Span_BS_Tbl. The
span source circuit termination point is stored in the Circuit_CTP_Tbl and a reference to
the CIRCUIT_CTP_TBL row (that is, database row ID) is stored in the Circuit_Span_BS_Tbl
as CIRCUIT_SPAN_SRC_CTP_ACCESSID. Similarly, the span destination circuit
termination point is stored in the Circuit_CTP_Tbl and a reference to the
CIRCUIT_CTP_TBL row (database row ID) is stored in the Circuit_Span_BS_Tbl as
CIRCUIT_SPAN_DEST_CTP_ACCESSID.
base information, span source circuit termination point, and span destination circuit
termination point. The span base information is stored in the Circuit_Span_BS_Tbl. The
span source circuit termination point is stored in the Circuit_CTP_Tbl and a reference to
the CIRCUIT_CTP_TBL row (that is, database row ID) is stored in the Circuit_Span_BS_Tbl
as CIRCUIT_SPAN_SRC_CTP_ACCESSID. Similarly, the span destination circuit
termination point is stored in the Circuit_CTP_Tbl and a reference to the
CIRCUIT_CTP_TBL row (database row ID) is stored in the Circuit_Span_BS_Tbl as
CIRCUIT_SPAN_DEST_CTP_ACCESSID.
Foreign key: FK_CIRCUIT_SPAN_BS_NPID
Tablespace: BASE_DATA_TABLESPACE
For medium, large, and high-end configurations, this table is partitioned.
Table 1-22: Circuit_Span_BS_Tbl
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
CktSpanBSId
NUMBER(10)
NOT NULL
Unique sequence number generated
by the database.
by the database.
CktNodeId
NUMBER(10)
—
Node ID of the circuit's source node.
This is an internal field.
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.
Span_Type
NUMBER(5)
NOT NULL
Type of span.