Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |