Cisco Cisco IPCC Web Option Technical References
1-4
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 1 Introduction
General Concepts
Figure 1-3
A Cross-Reference Table
The Skill Group Member table contains one record for each member of each skill group. It has
one-to-many relationships with both the Agent table and the Skill Group table. This avoids a direct
many-to-many relationship between the Agent and Skill Group tables.
one-to-many relationships with both the Agent table and the Skill Group table. This avoids a direct
many-to-many relationship between the Agent and Skill Group tables.
Key Fields
One or more fields within a table can form a key. Keys are the fields used most commonly to locate
specific records. Usually the fields that make up a key are defined as NOT NULL (meaning they cannot
take the NULL value), but there are many exceptions.
specific records. Usually the fields that make up a key are defined as NOT NULL (meaning they cannot
take the NULL value), but there are many exceptions.
Most tables have a primary key. For example, the PeripheralID field is the primary key for the Peripheral
table. The primary key for the Trunk table is the combination of the TrunkGroupID and TrunkNumber
fields.
table. The primary key for the Trunk table is the combination of the TrunkGroupID and TrunkNumber
fields.
An example of a foreign key is the PeripheralID field in the Agent table. You can use this key to find all
agents associated with a specific peripheral.
agents associated with a specific peripheral.
The Agent table contains two alternate keys: the EnterpriseName field, and the combination of the
PeripheralID and PeripheralNumber fields. A value for either of these keys uniquely identifies an agent.
PeripheralID and PeripheralNumber fields. A value for either of these keys uniquely identifies an agent.