Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
40
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
CktOchncDir
NUMBER(1)
—
Direction of the OCHNC circuit. Values are:
0: East-to-west
1: West-to-east
2: Not applicable
0: East-to-west
1: West-to-east
2: Not applicable
isDuplicateNa
me
me
NUMBER(1)
DEFAULT 1
Whether or not the circuit has a duplicate
name. Values are:
0: Duplicate
1: Not duplicate
name. Values are:
0: Duplicate
1: Not duplicate
NPID
NUMBER(10)
—
Network partition ID to which the
subnetwork belongs.
subnetwork belongs.
CktAliasName
VARCHAR2(80) —
Circuit alias name.
isOpenVcat
NUMBER(1)
DEFAULT 0
Indicates whether or not the circuit is an
open VCAT. Values are:
0: False
1: True
open VCAT. Values are:
0: False
1: True
isOverlay
NUMBER(1)
DEFAULT 0
Indicates whether or not the circuit is an
overlay. Values are:
0: False
1: True
overlay. Values are:
0: False
1: True
isForPortGroup
ing
ing
NUMBER(1)
—
Indicates the Port Grouping Only check
box in the circuit wizard.
box in the circuit wizard.
isGmpls
NUMBER(1)
—
Whether or not the service is GMPLS.
Values are:
0: False
1: True
Values are:
0: False
1: True
1.1.20 Circuit_Ctp_Tbl
The Circuit_Ctp_Tbl stores the circuit termination points.
Foreign key: FK_CIRCUIT_CTPNPID
Tablespace: BASE_DATA_TABLESPACE
For medium, large, and high-end configurations, this table is partitioned.
Table 1-19: Circuit_Ctp_Tbl
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description