Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Leaflet
Database Schema
General Database Concepts
2
Cisco Customer Response Solutions Database Schema
General Database Concepts
This section provides an overview of some basic database concepts.
Tables, Columns, and Rows
A database contains one or more tables of data. Each table in a database defines a
set of columns, which are called fields. Within each table, the database stores data
in rows, which are called records. Each record (row) contains one value for each
field (column) of the table. For example,
set of columns, which are called fields. Within each table, the database stores data
in rows, which are called records. Each record (row) contains one value for each
field (column) of the table. For example,
table, which contains five fields. This example shows a Skill table with three
records.
records.
Figure 1
Skill Table Fields and Records
Database tables and the number and names of their fields are constant. The
number of records in a table and the data that those records contain varies
according your system.
number of records in a table and the data that those records contain varies
according your system.
Table Relationships
Related tables in a database share one or more common fields. For example, both
the Skill and the SkillGroup tables include the skillID field. Each record in the
Skill table is related to each record in the SkillGroup table that shares the same
skillID value.
the Skill and the SkillGroup tables include the skillID field. Each record in the
Skill table is related to each record in the SkillGroup table that shares the same
skillID value.
Relationships between tables can be one-to-one or one-to-many. For example,
because one skill can be associated with many skill groups, the relationship
between the Skill and SkillGroup tables is one-to-many. On the other hand, each
because one skill can be associated with many skill groups, the relationship
between the Skill and SkillGroup tables is one-to-many. On the other hand, each