Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Leaflet
Database Schema
Database Table Details
60
Cisco Customer Response Solutions Database Schema
Team
Database table name: Team
The Team table contains information about specific teams.
.
Related Tables
•
(via ProfileID)
•
(teamID maps to assignedTeamID and via profileID
•
(teamID maps to managedTeamID and via profileID)
•
(via teamID and profileID)
Table 1-26
Team Table Fields
Field Name
Description
Storage
teamID
Numeric identifier for this team.
int
NOT NULL
Primary Key
profileID
Identifier of the Cisco CRS profile that
is associated with this record.
is associated with this record.
int
NOT NULL
Primary Key
teamName
Name of this team.
nvarchar(50)
NOT NULL
active
Indicates whether the record is active in
the CRS system. A record becomes
inactive if a team is deleted or updated.
the CRS system. A record becomes
inactive if a team is deleted or updated.
0 = Inactive
1 = Active
bit
NOT NULL
dateInactive
Date this record was deleted.
datetime
NULL