Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-9
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
Related tables
•
•
(via ProfileID)
Campaign
Database table name: Campaign
The campaign configuration information is stored in this table. A campaign is associated with one or
more CSQs. This mapping of Campaigns and CSQs is stored separately in CampaignCSQMap table.
more CSQs. This mapping of Campaigns and CSQs is stored separately in CampaignCSQMap table.
The Campaign table contains the fields shown in
active
Whether the record is active in the system. A record
becomes inactive if the team is deleted from the system.
becomes inactive if the team is deleted from the system.
f = Inactive
t = Active
boolean
NOT NULL
dateinactive
Date this record was deleted.
datetime year to
second
second
NULL
Table 1-3
AreaCode Table Fields (continued)
Field Name
Description
Storage
Table 1-4
Campaign Table Fields
Field Name
Description
Storage
recordid
A unique identifier for the record.
int
NOT NULL
Primary Key
campaignid
A unique identifier for the campaign.
int
NOT NULL
Primary Key
profileid
Identifier of the Unified CCX profile that is associated
with this record.
with this record.
int
NOT NULL
Primary Key
createdatetime
Default -CURRENT_TIMESTAMP
datetime year to
second
second
NOT NULL
campaignname
Name of the campaign. Must be unique.
nvarchar(50)
NOT NULL
enabled
0 = campaign is enabled
1 = campaign is disabled
smallint
NOT NULL