Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
304
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
DEFAULT_PORT
NUMBER(5)
—
Port number for the TL1 tunnel.
1.1.249
TL1_Tunnel_Gateway_Table
Primary key: TL1_TUNNEL_GATEWAY_TABLE
Tablespace: BASE_DATA_TABLESPACE
Table 1-238: TL1_Tunnel_Gateway_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NGNE_PKID
NUMBER(5)
—
Primary key for the non-Cisco GNE
(NGNE).
(NGNE).
NGNE_TID
VARCHAR(128) —
Tunnel agent ID for the NGNE.
NGNE_IPADDRESS
NUMBER(10)
NOT NULL
IP address of the NGNE.
NGNE_USERNAME
VARCHAR2(64) —
Username to log into the NGNE.
NGNE_USER_PASSWORD VARCHAR2(64) —
Password to log into the NGNE.
NGNE_TL1PORT
NUMBER(5)
—
NGNE TL1 port number.
1.1.250
TL1_Tunnel_Info_Table
The TL1_Tunnel_Info_Table stores information about the TL1 tunnels.
Primary key: PK_TL1_TUNNEL_INFO_TABLE
Tablespace: BASE_DATA_TABLESPACE
Table 1-239: TL1_Tunnel_Info_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
Tunnel_PKID
NUMBER(5)
—
Primary key for the tunnel.
TNE_NE_DBAccesss_ID NUMBER(10)
UNIQUE NOT
NULL
NULL
Foreign key from the NE_INFO_Table.
FK_NGNE_PKID
NUMBER(5)
—
Foreign key from the
TL1_Tunnel_Gateway_Table.
TL1_Tunnel_Gateway_Table.
TL1_Encoding
NUMBER(4)
—
ENUM for the encoding type.