Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 548
   
2-143
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
Chapter 2      Table Details
Enterprise_Service_Member Table
Enterprise_Service_Member Table
Maps services to enterprise services.
Use ICM Configuration Manager to add or delete Enterprise_Service_Member records.
Related tables:
 (via EnterpriseServiceID)
 (via SkillTargetID)
Table 2-137 Enterprise_Service_Member Table Constraints
Constraint
Field Name(s)
PK
EnterpriseServiceID
SkillTargetID
FK
EnterpriseServiceID
SkillTargetID
IE-1
SkillTargetID
Table 2-138 Enterprise_Service_Member Table
Field Name
Description
Data Type
Keys and Null 
Option
EnterpriseServiceID
Foreign key from the Enterprise Service table.
DBINT
PK, FK
NOT NULL
SkillTargetID
Foreign Key from the Service table.
DBINT
PK, FK, IE-1
NOT NULL