Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 620
Table 184: Indexes for Sec_Group Table
index_keys
index_description
index_name
UserGroupID
clustered, unique, primary key
located on PRIMARY
XPKSec_Group
Fields in Sec_Group Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Foreign key from the User_Group table.
UserGroupID
NOT NULL
varchar(64)
The name of the group.
UserGroupName
Sec_User Table
This table is in the 
To see database rules for these tables, click
Used internally to track the state of users in the User_Group table. The Sec_User table contains
one row for each User_Group row that represents a user (rather than a group).
Related table
 (via UserGroupID)
Table 185: Indexes for Sec_User Table
index_keys
index_description
index_name
UserGroupID
clustered, unique, primary key
located on PRIMARY
XPKSec_User
Fields in Sec_User Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Foreign key from the User_Group table.
UserGroupID
NOT NULL
varchar(64)
The name of the user.
UserGroupName
Service Table
To see database rules for these tables, click
Each row describes a service available at a peripheral.
Use the Service Explorer tool to add, update, and delete Service records.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
325
Chapter 2:  All Tables
Sec_User Table