Cisco Cisco IP Contact Center Release 4.6.1 技术参考
2-427
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
User_Group_Member Table
Related tables:
(via UserGroupName)
(via CustomerDefinitionID)
(via UserGroupName)
(via UserGroupName)
User_Group_Member Table
Lists the specific users that are members of each user group. If the group is of type “U then it has a single
User_Group_Member record. If the group is of type 'G' is can have multiple User_Group_Member
records. A single user can be a member of multiple user groups.
User_Group_Member record. If the group is of type 'G' is can have multiple User_Group_Member
records. A single user can be a member of multiple user groups.
Use Configuration Manager to create, update, and delete User Group Member records.
Related tables:
(via UserGroupName)
Table 2-389 User_Group_Member Table Constraints
Constraint
Field Name(s)
PK
UserGroupMemberID
AK-1
UserGroupName
UserName
UserName
IE-1
UserName
Table 2-390 User_Group_Member Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
UserGroupMemberID
A unique identifier for the record.
DBINT
PK
NOT NULL
UserGroupName
The group to which the member belongs.
varchar(30)
AK-1
NOT NULL
UserName
The username as registered with SQL Server.
varchar(30)
AK-1, IE-1
NOT NULL