Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-2
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
Figure 2
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 will vary according your system.
and the data that those records contain will vary 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.
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 call or call leg has its own set of data about the agent who handled
the call and other information. Therefore, the relationship between the AgentConnectionDetail and
ContactCallDetail table is one-to-one.
associated with many skill groups, the relationship between the Skill and SkillGroup tables is
one-to-many. On the other hand, each call or call leg has its own set of data about the agent who handled
the call and other information. Therefore, the relationship between the AgentConnectionDetail and
ContactCallDetail table is one-to-one.
Each database table description in this manual is followed by a Related Tables section. These sections
show the fields by which a table is related to other tables. If the fields have different names in each table,
these sections show the mapping.
show the fields by which a table is related to other tables. If the fields have different names in each table,
these sections show the mapping.
Database Table Details
This section provides information about Unified CCX system database tables, their records, and their
fields.
fields.
Each description provides the following information:
•
Database Table Name—Name of the Unified CCX database table.
•
Field Name—Name of a field as it appears in the database table.
•
Description—Description of the field, including valid values where appropriate.
•
Storage—Information about the data in each field as follows:
–
Data type used for the field in the database.
Note
For storage characteristics and limitations of the data types used for the fields in the databases
refer to "IBM Informix SQL Reference Guide". The date and time in the database fields are
stored in Coordinated Universal Time (UTC).
refer to "IBM Informix SQL Reference Guide". The date and time in the database fields are
stored in Coordinated Universal Time (UTC).
–
Whether the NULL value is valid for the field. “NULL” if the NULL value is or “NOT NULL”
if the NULL value is not valid.
if the NULL value is not valid.
Records
skillID
1
2
3
skillName
Guitar
Bass
Drum
active
1
0
1
dateInactive
NULL
2002-06-19 12:02:01.680
NULL
profileID
1
1
1
Fields
79415