Cisco Cisco E-Mail Manager Unity Integration Option Technical References
(via EntityID)
(via EnterpriseRouteID)
Table 83: Indexes for Enterprise_Route Table
index_keys
index_description
index_name
EnterpriseName, EntityID
clustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Enterprise_Route
EnterpriseRouteID
nonclustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKEnterprise_Route
Fields in Enterprise_Route Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the enterprise route.
Description
AK-1 NOT NULL
VNAME32
An enterprise name for this enterprise route. This name must be
unique among all enterprise routes within the business entity.
unique among all enterprise routes within the business entity.
EnterpriseName
PK NOT NULL
DBINT
Unique identifier for this enterprise route.
EnterpriseRouteID
AK-1, FK NOT NULL
DBINT
If partitioning is enabled, indicates the business entity to which
this enterprise route belongs.
this enterprise route belongs.
EntityID
Enterprise_Route_Member Table
This table is one of the
. For database rules click
It maps routes to enterprise routes. Use ICM Configuration Manager to add, update, and delete
Enterprise_Route_Member records.
Enterprise_Route_Member records.
Related Table
Table 84: Indexes for Enterprise_Route_Member Table
index_keys
index_description
index_name
EnterpriseRouteID, RouteID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKEnterprise_Route_Member
Fields in Enterprise_Route_Member Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Foreign key from the Enterprise_Route table.
EnterpriseRouteID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
174
Chapter 2: All Tables
Enterprise_Route_Member Table