Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 548
   
2-145
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
Chapter 2      Table Details
Enterprise_Skill_Group_Member Table
Enterprise_Skill_Group_Member Table
Maps skill groups to enterprise skill groups.
Use ICM Configuration Manager to add or delete Enterprise_Skill_Group_Member records.
Related tables:
 (via EnterpriseSkillGroupID)
 (via SkillTargetID)
Table 2-141 Enterprise_Skill_Group_Member Table Constraints
Constraint
Field Name(s)
PK
EnterpriseSkillGroupID
SkillTargetID
FK
EnterpriseSkillGroupID
SkillTargetID
IE-1
SkillTargetID
Table 2-142 Enterprise_Skill_Group_Member Table
Field Name
Description
Data Type
Keys and 
Null Option
EnterpriseSkillGroupID
Foreign Key from the Enterprise Skill Group 
table.
DBINT
PK, FK
NOT NULL
SkillTargetID
Foreign Key from the Skill Group table.
DBINT
PK, FK, 
IE-1
NOT NULL