Cisco Cisco Unified Contact Center Enterprise 9.0(1) Technical References
1-3
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 1 Introduction
General Concepts
Figure 1-2
Tables Related by a Shared Column
Relationships between tables can be one-to-one or one-to-many. For example, because one peripheral
can be associated with many agents, the relationship between the Peripheral and Agent tables is
one-to-many. On the other hand, each peripheral has a single peripheral default route and each peripheral
default route belongs to only one peripheral. Therefore, the relationship between the Peripheral and
Peripheral Default Route tables is one-to-one.
can be associated with many agents, the relationship between the Peripheral and Agent tables is
one-to-many. On the other hand, each peripheral has a single peripheral default route and each peripheral
default route belongs to only one peripheral. Therefore, the relationship between the Peripheral and
Peripheral Default Route tables is one-to-one.
Sometimes a single row might not be associated with any rows in a related table. For example, it is
possible to define a peripheral with no associated agents. Normally, this would only be a temporary
condition. In some cases, however, the condition might be permanent. For example, you can define a
trunk group but not define the associated trunks.
possible to define a peripheral with no associated agents. Normally, this would only be a temporary
condition. In some cases, however, the condition might be permanent. For example, you can define a
trunk group but not define the associated trunks.
Sometimes the natural relationship between two tables appears to be many-to-many. For example, each
agent can be a member of many skill groups and each skill group can contain many agents. Therefore,
the Agent and Skill Group tables appear to have a many-to-many relationship. However, in this case, a
third table, called a cross-reference table, actually links the tables so the relationship is actually
one-to-many. For example,
agent can be a member of many skill groups and each skill group can contain many agents. Therefore,
the Agent and Skill Group tables appear to have a many-to-many relationship. However, in this case, a
third table, called a cross-reference table, actually links the tables so the relationship is actually
one-to-many. For example,
shows how the Skill Group Member table acts as a
cross-reference table for the Agent and Skill Group tables.