Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
57
Primary key: none
Foreign key: FK_CIRCUIT_VCG_ NPID
Tablespace: BASE_DATA_TABLESPACE
For medium, large, and high-end configurations, this table is partitioned.
Table 1-26: Circuit_VCG_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.
ParentCktNodeId
NUMBER(10)
NOT NULL
Node ID of the source node of the
parent VCAT circuit. This is an internal
field.
parent VCAT circuit. This is an internal
field.
ParentCktUniqueId
NUMBER(10)
NOT NULL
Unique number within each source
node. This is an internal field. The
combination of ParentCktNodeId and
ParentCktUniqueId results in a unique
circuit ID in the whole network.
node. This is an internal field. The
combination of ParentCktNodeId and
ParentCktUniqueId results in a unique
circuit ID in the whole network.
VCGDirection
NUMBER(1)
—
VCG direction. Values are:
0: None
1: Forward
2: Backward
3: Bidirectional
0: None
1: Forward
2: Backward
3: Bidirectional
NPID
NUMBER(10)
DEFAULT 0
Network partition ID.
VCATSTATE
NUMBER(1)
DEFAULT 0
VCAT member state.
1.1.28 Circuit_VLAN_Tbl
The Circuit_VLAN_Tbl contains information about VLANs associated with circuits.
Primary key: CIRCUIT_VLAN_PK
Foreign key: FK_CIRCUIT_VLAN_NPID
Tablespace: BASE_DATA_TABLESPACE