Cisco Cisco ICM Web Tools Technical References
2-200
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Sec_Group Table
Sec_Group Table
Used internally to track the state of records in the User_Group table. The Sec_Group table contains one
row for each User_Group row.
row for each User_Group row.
Related tables:
User Group (via UserGroupID)
Sec_User Table
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).
for each User_Group row that represents a user (rather than a group).
Related tables:
User Group (via UserGroupID)
Table 2-164 Sec_Group Table
Field Name
Description
Data Type
Keys and Null
Option
Option
UserGroupID
Foreign key from the User_Group table.
int
PK, FK, NOT
NULL
NULL
UserGroupName
The name of the group.
varchar(30)
NOT NULL
Table 2-165 Sec_User Table
Field Name
Description
Data Type
Keys and Null
Option
Option
UserGroupID
Foreign key from the User_Group table.
int
PK, FK, NOT
NULL
NULL
UserGroupName
The name of the user.
varchar(30)
NOT NULL