Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
Table 36: Indexes for Application_Gateway Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Application_Gateway
ICRInstanceID
nonclustered located on PRIMARY
XIE1Application_Gateway
ApplicationGatewayID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKApplication_Gateway
Fields in Application_Gateway Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
A unique identifier for the application gateway.
ApplicationGatewayID
NOT NULL
DBINT
The type of gateway:
ApplicationGatewayType
• 0 = custom gateway
• 1 = remote ICM
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the application gateway.
Description
NOT NULL
DBINT
The encryption method used by the application gateway:
Encryption
• 0 = none
• 1 = private key
AK-1 NOT NULL
VNAME32
An enterprise name for the application gateway. This name
must be unique among all application gateways in the enterprise.
must be unique among all application gateways in the enterprise.
EnterpriseName
NOT NULL
DBINT
The fault-tolerance strategy used by the application gateway.
To see values for this field, click
To see values for this field, click
FaultTolerance
FK, IE-1 NULL
DBINT
Identifies the instance associated with the application gateway.
ICRInstanceID
NULL
char(1)
Indicates which side of the Gateway the software should use
when both are available: A or B. This applies only when
ApplicationGatewayType is 0 (custom gateway).
when both are available: A or B. This applies only when
ApplicationGatewayType is 0 (custom gateway).
PreferredSide
Application_Gateway_Connection Table
This table is part of the
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
61
Chapter 2: All Tables
Application_Gateway_Connection Table