Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
72
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
SOAKTIME_VALUE
NUMBER
(10)
(10)
NOT NULL
Indicates the soak time related to
the revertive option.
the revertive option.
IGNOREPATHALARM_VALUE
NUMBER (1)
NOT NULL
Indicates whether the circuit has
been provisioned using the
ignore path alarm option. Values
are:
0: False
1: True
been provisioned using the
ignore path alarm option. Values
are:
0: False
1: True
1.1.53 GNE_Table
The GNE_Table contains information about the various GNEs in the network.
Primary key: GNE_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-51: GNE_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
GNEID
NUMBER(8)
NOT NULL
GNE identifier. Unique sequence
number generated by the database.
This is the link between this table and
GNEID in the NE_INFO_TABLE.
number generated by the database.
This is the link between this table and
GNEID in the NE_INFO_TABLE.
GNEType
NUMBER(4)
DEFAULT 1
Values are:
1: Unknown
2: Self
3: ISR_as_GNE
4: Foreign_GNE_TL1
5: Foreign_GNE_CLNP
6: Foreign_GNE_IP
1: Unknown
2: Self
3: ISR_as_GNE
4: Foreign_GNE_TL1
5: Foreign_GNE_CLNP
6: Foreign_GNE_IP
RINGID
NUMBER(8)
—
Identifies the ring to which the NE is
connected. NEs with similar RING_IDs
are in the same ring.
connected. NEs with similar RING_IDs
are in the same ring.
GNESysId
VARCHAR2(128)
NOT NULL
Name of the GNE.
NextHopIPAddr
NUMBER(10)
NOT NULL
IP address of the next hop used to reach
the GNE.
the GNE.
GNEComment
VARCHAR2(512)
—
Comment for the GNE.