Cisco Cisco Administrative Workstation Referências técnicas
Keys and Null Option:
Data Type:
Description:
Field Name:
AK-1 NOT NULL
VNAME32
An enterprise name for this enterprise skill group. This name
must be unique among all enterprise skill groups within the
business entity.
must be unique among all enterprise skill groups within the
business entity.
EnterpriseName
PK NOT NULL
DBINT
Unique identifier for this enterprise skill group.
EnterpriseSkillGroupID
AK-1, FK NOT NULL
DBINT
If partitioning is enabled, indicates the business entity to which
the enterprise skill group belongs.
the enterprise skill group belongs.
EntityID
Enterprise_Skill_Group_Member Table
This table is one of the
. For database rules click
It maps skill groups to enterprise skill groups. Use ICM Configuration Manager to add or delete
Enterprise_Skill_Group_Member records
Enterprise_Skill_Group_Member records
Related tables
(via SkillTargetID)
Table 88: Indexes for Enterprise_Skill_Group_Member Table
index_keys
index_description
index_name
SkillTargetID
nonclustered located on PRIMARY
XIE1Enterprise_Skill_Group_Mem
EnterpriseSkillGroupID, SkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKEnterprise_Skill_Members
Fields in Enterprise_Skill_Group_Member Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Foreign Key from the Enterprise Skill Group table.
EnterpriseSkillGroupID
PK, FK, IE-1 NOT NULL
DBINT
Foreign Key from the Skill Group table.
SkillTargetID
Event Table
This table is in the
. To see database rules for these tables, click
Central database only.
Contains system events generated by the ICM software.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
177
Chapter 2: All Tables
Enterprise_Skill_Group_Member Table