Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
292
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
CTMUNIQID
NUMBER(10)
NOT NULL
Prime Optical ID used to identify the
contributor in the service. This is an
internal field.
contributor in the service. This is an
internal field.
SERVICENAME
VARCHAR2(256)
—
Service name.
DESCRIPTION
VARCHAR2(256)
—
Description of the service has been
provisioned.
provisioned.
DISCOVERYSTATE
NUMBER(1)
NOT NULL
Discovery status of the service. Values
are:
0: Partial
1: Discovered
are:
0: Partial
1: Discovered
OPERSTATE
NUMBER(1)
NOT NULL
Summary of the operational state of all
the contributors.
the contributors.
ISPROTECTED
NUMBER(1)
NOT NULL
Whether the service is protected or
unprotected. Values are:
0: Unprotected
1: Protected
unprotected. Values are:
0: Unprotected
1: Protected
EPCOUNT
NUMBER(4)
NOT NULL
Number of endpoint contributors. This
is an internal field.
is an internal field.
1.1.232
Roll_Table
The Roll_Table contains information about the ONS 15600 Rolls table.
Primary key: ROLL_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-222 : Roll_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
RollNodeId
NUMBER(10)
NOT NULL
Node ID of the source node of the roll-
from circuit. This is an internal field.
from circuit. This is an internal field.
ConnectionInd
ex
ex
NUMBER(10)
NOT NULL
Unique number within each source node.
This is an internal field. The combination
of RollNodeId and ConnectionIndex
results in a unique number in the whole
network.
This is an internal field. The combination
of RollNodeId and ConnectionIndex
results in a unique number in the whole
network.
RollFromCktNo
deId
deId
NUMBER(10)
NOT NULL
Node ID of the roll-from circuit.
RollFromCktUn
iqueID
iqueID
NUMBER(10)
NOT NULL
Unique ID of the roll-from circuit.
RollToCktNodeI
D
D
NUMBER(10)
—
Node ID of the roll-to circuit.