mktg_campaign_item Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The mktg_campaign_item table in the marketing database contains information about individual campaign items.
The following table describes the columns in the mktg_campaign_item table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_campitem_id |
int |
no |
The ID of this campaign item. This is the primary key. |
i_creative_id |
int |
yes |
The ID of the creative associated with this campaign item. This is a foreign key into the mktg_creative table. |
guid_campitem_type |
uniqueidentifier |
no |
A GUID that identifies the type of this campaign item:
|
u_campitem_name |
nvarchar(50) |
no |
The name of this campaign item. |
b_campitem_active |
bit |
no |
A Boolean value that indicates whether this campaign item is active (approved). |
dt_campitem_start |
datetime |
no |
The date and time at which this campaign item starts. |
dt_campitem_end |
datetime |
no |
The date and time at which this campaign item ends. |
i_campitem_exposure_limit |
int |
no |
The maximum number of times to show this campaign item to a particular user. |
i_camp_id |
int |
yes |
The ID of the campaign with which this campaign item is associated. This is a foreign key into the mktg_campaign table. |
dt_campitem_created |
datetime |
no |
The date and time at which this campaign item was created. |
dt_campitem_archived |
datetime |
yes |
The date and time at which this campaign item was archived/deleted. |
dt_campitem_exported |
datetime |
yes |
The date and time at which this campaign item was last exported to the Data Warehouse Analytics System. |
dt_campitem_modified |
datetime |
yes |
The date and time at which this campaign item was last modified. |
u_campitem_modified_by |
nvarchar(50) |
yes |
The name of the user who created or last modified this campaign item. |
u_campitem_comments |
nvarchar(1024) |
yes |
Any arbitrary comments about this campaign item. |
b_campitem_deleted |
bit |
yes |
A Boolean value that indicates whether this campaign has been archived/deleted. |