Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Note De Mise
1-49
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
Related Tables
•
(via ProfileID)
•
(teamID maps to assignedTeamID and via profileID
•
(teamID maps to managedTeamID and via profileID)
•
(via teamID and profileID)
TeamCSQMapping
Database table name: TeamCSQMapping
The TeamCSQMapping table shows the relationship between Teams and CSQs; for example, Team 1 is
CSQ3, Team 4 is CSQ10.
CSQ3, Team 4 is CSQ10.
The TeamCSQMapping table contains the fields shown in
.
active
Indicates whether the record is active in the Unified CCX
system. A record becomes inactive if a team is deleted or
updated.
system. A record becomes inactive if a team is deleted or
updated.
f = Inactive
t = Active
boolean
NOT NULL
dateInactive
Date this record was deleted.
datetime year to
fraction(3)
fraction(3)
NULL
Table 1-28
Team Table Fields (continued)
Field Name
Description
Storage
Table 1-29
TeamCSQMapping Table Fields
Field Name
Description
Storage
recordID
Numeric identifier for this record.
int
NOT NULL
Primary Key
csqID
Numeric identifier for the CSQ.
int
NOT NULL
teamID
Numeric identifier for the team.
int
NOT NULL
profileID
Identifier of the Unified CCX profile that is associated with
this record.
this record.
int
NOT NULL
Primary Key