Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
42
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
CktCtpDropPro
tType
tType
NUMBER(1)
—
Protection type. Values are:
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
CktCtpPortNa
me
me
VARCHAR2(64)
—
Destination port name of the circuit.
CktCtpAddition
alInfo
alInfo
VARCHAR2(64)
DEFAULT NULL
Additional information about the circuit
destination.
destination.
NPID
NUMBER(10)
DEFAULT 0
Network partition ID to which the
subnetwork belongs.
subnetwork belongs.
EqptInfoObjInd
ex
ex
NUMBER(6)
DEFAULT 0
ObjectIndex of reference in EqptInfoTable.
PayLoadType
NUMBER(6)
—
Indicates the payload type of the
Circuit Termination Point (CTP).
Circuit Termination Point (CTP).
1.1.21 Circuit_Dest_Tbl
The Circuit_Dest_Tbl shows the end and drop points for network circuits.
Primary key: None
Foreign key: FK_CIRCUIT_DEST_NPID
Tablespace: BASE_DATA_TABLESPACE
For medium, large, and high-end configurations, this table is partitioned.
Table 1-20: Circuit_Dest_Tbl
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
CktNodeId
NUMBER(10)
NOT NULL
Node ID of the circuit's source node.
This is an internal field.
This is an internal field.
CktUniqueId
NUMBER(10)
NOT NULL
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.
CktDestNodeId
NUMBER(10)
—
Destination node ID.