Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
60
1.1.32 CORBA_GW_Active_User_Table
The CORBA_GW_Active_User_Table contains information about the active
Prime Optical GateWay/CORBA users.
Prime Optical GateWay/CORBA users.
Primary key: CORBA_GW_ACTIVE_USER_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-31 CORBA_GW_Active_User_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
active_session_id
VARCHAR2(128)
NOT NULL
Session ID.
user_name
VARCHAR2(128)
NOT NULL
Username of the OSS user.
client_end_ip
NUMBER(10)
NOT NULL
IP address of the OSS user.
LastLoginTime
DATE
—
Most recent user login date and time.
client_end_ipv6
RAW(16)
—
IPv6 address.
is_ipv6
NUMBER(1)
—
Flag indicating the IP version. Values
are:
0: IPv4
1: IPv6
are:
0: IPv4
1: IPv6
1.1.33 CORBA_Interface_Table
The CORBA_Interface_Table contains information about the GateWay/CORBA interface.
Primary key: CORBA_INTERFACE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-32: CORBA_Interface_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
InterfaceIndex
NUMBER(10)
NOT NULL
Index used for mapping of
operations.
operations.
InterfaceName
VARCHAR(32)
NOT NULL
Name of the interface.
AdditionalPermissions NUMBER(1)
NOT NULL
Type of interface. Values are:
0: No permissions
1: All read
2: All write
0: No permissions
1: All read
2: All write
HelperClass
VARCHAR(128) NOT NULL
Helper class name used to get the