Cisco Cisco IP Contact Center Release 4.6.1 Technical References
1-3
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 1 Introduction
General Concepts
This section gives a brief overview of some relational database concepts and some details about how
ICM software generates data.
ICM software generates data.
Tables, Columns, and Rows
A database contains tables of data. A table defines a series of columns or fields. The actual data is stored
as rows or records within each table. Each row contains one value for each column of the table. For
example,
as rows or records within each table. Each row contains one value for each column of the table. For
example,
shows a table with five columns. It contains three rows of data.
Figure 1-1
Columns and Rows in a Table
The data in tables differ for each system, but the definition of tables and columns does not. This manual
describes the columns of each table; it does not describe the actual data in table rows.
describes the columns of each table; it does not describe the actual data in table rows.
Table Relationships
Related tables in a database share one or more common fields or columns. For example, as shown in
, both the Agent and Peripheral tables include the PeripheralID field. This defines a
relationship: each row in the Agent table is related to the row in the Peripheral table that shares the same
PeripheralID value.
PeripheralID value.