Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
48
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
IsCktSpanInUPSR
NUMBER(1)
—
Whether the circuit span is part of
a unidirectional path switched ring
(UPSR) ring. Values are:
0: False
1: True
a unidirectional path switched ring
(UPSR) ring. Values are:
0: False
1: True
IsCktSpanWorking
NUMBER(1)
—
Whether the circuit span is a
working span. Values are:
0: False
1: True
working span. Values are:
0: False
1: True
IsCktSpanActive
NUMBER(1)
—
Whether the circuit span carries
active traffic. Values are:
0: False
1: True
active traffic. Values are:
0: False
1: True
CktSpanProtOp
NUMBER(1)
—
Last successful span protection
operation performed on this span.
Values are:
0: Clear
1: Manual
2: Force
3: Lockout
operation performed on this span.
Values are:
0: Clear
1: Manual
2: Force
3: Lockout
CktSpanAdditionalInfo
VARCHAR2(64) DEFAULT
NULL
Additional information about the
circuit span.
circuit span.
CktSpanCDLFlowID
NUMBER(3)
DEFAULT –1
Source converged data link (CDL)
flow identifier; applies only to ONS
15530 and ONS 15540 circuits.
Valid range is 0 to 254.
flow identifier; applies only to ONS
15530 and ONS 15540 circuits.
Valid range is 0 to 254.
CktSpanSrcPortName
VARCHAR2(64) —
Span source port name of the
circuit.
circuit.
CktSpanDestPortName
VARCHAR2(64) —
Span destination port name of the
circuit.
circuit.
NPID
NUMBER(10)
DEFAULT 0
Network partition ID.
1.1.25 Circuit_Tbl
The Circuit_Tbl shows circuit information about an entire network.
Primary key: CIRCUIT_TBL_PK
Foreign key: FK_CIRCUIT_NPID
Tablespace: BASE_DATA_TABLESPACE
For medium, large, and high-end configurations, this table is partitioned.