Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Table 84: Indexes for Enterprise_Service Table
index_keys
index_description
index_name
EntityID, EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Enterprise_Service
EnterpriseServiceID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKEnterprise_Service
Fields in Enterprise_Service Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the enterprise
service.
service.
Description
AK-1 NOT NULL
VNAME32
An enterprise name for this enterprise service.
This name must be unique among all enterprise
services within the business entity.
This name must be unique among all enterprise
services within the business entity.
EnterpriseName
PK NOT NULL
DBINT
Unique identifier for this enterprise service.
EnterpriseServiceID
AK-1, FK NOT NULL
DBINT
If partitioning is enabled, indicates the business
entity to which the enterprise service belongs.
entity to which the enterprise service belongs.
EntityID
Enterprise_Service_Member Table
This table is one of the
. For database rules click
It maps services to enterprise services. Use ICM Configuration Manager to add or delete
Enterprise_Service_Member records.
Enterprise_Service_Member records.
Related tables
(via SkillTargetID)
Table 85: Indexes for Enterprise_Service_Member Table
index_keys
index_description
index_name
SkillTargetID
nonclustered located on PRIMARY
XIE1Enterprise_Service_Member
EnterpriseServiceID, SkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKEnterprise_Service_Members
Fields in Enterprise_Service_Member Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Foreign key from the Enterprise Service table.
EnterpriseServiceID
PK, FK, IE-1 NOT NULL
DBINT
Foreign Key from the Service table.
SkillTargetID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
140
Chapter 2: - All Tables
Enterprise_Service_Member Table