Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
43
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
CktDestModuleType
NUMBER(8)
—
Module type at destination.
CktDestIfIndex
NUMBER(20)
—
Static index of the interface at the
destination.
destination.
CktDestObjectType
NUMBER(10)
—
Object type at the destination.
CktDestPhysicalLoc
NUMBER(20)
—
Physical location of the destination
node.
node.
CktDestModelType
NUMBER(4)
—
Model type of the destination node.
CktDestDropProt
NUMBER(1)
—
Whether the endpoint is protected.
Values are:
0: False
1: True
Values are:
0: False
1: True
CktDestPathProt
NUMBER(1)
—
Path protection for this drop. Values
are:
0: Path fully protected
1: Path protected
2: Path unprotected
3: Path fully unprotected
are:
0: Path fully protected
1: Path protected
2: Path unprotected
3: Path fully unprotected
CktDestDropProtType NUMBER(1)
—
Protection type for ONS 15540:
0: No protection
1: Unknown protection
2: Splitter protection
3: Y-cable or line-card protection
4: Trunk card protection
0: No protection
1: Unknown protection
2: Splitter protection
3: Y-cable or line-card protection
4: Trunk card protection
CktDestPortName
VARCHAR2(64) —
Destination port name of the circuit.
CktDestAdditionalInfo VARCHAR2(64) DEFAULT
NULL
Additional information about the
circuit destination.
circuit destination.
NPID
NUMBER(10)
DEFAULT 0
Network partition ID.
1.1.22 Circuit_Size_Table
The Circuit_Size_Table contains information about the circuit sizes.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-21: Circuit_Size_Table