Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-48
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
Related Tables
•
(via resourceLoginID and profileID
•
(via ProfileID)
•
(managedTeamID maps to teamID, via profileID)
Team
Database table name: Team
The Team table contains information about specific teams.
The fields in the Team table are shown in
.
supervisorType
Type of supervisor for this team
0 = Primary
1 = Secondary
smallint
NOT NULL
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
second
second
NULL
Table 1-27
Supervisor Table Fields
Field Name
Description
Storage
Table 1-28
Team Table Fields
Field Name
Description
Storage
teamID
Numeric identifier for this team.
int
NOT NULL
Primary Key
profileID
Identifier of the Unified CCX profile that is associated with
this record.
this record.
int
NOT NULL
Primary Key
teamName
Name of this team.
nvarchar(50)
NOT NULL