This table contains the meta-information for a campaign. This table is used by the Marketing subsystem.
Column Descriptions
| Column Name
| Column Type
| Description
|
| CAMPAIGN_ID
| INTEGER NOT NULL
| Primary key.
|
| STOREENT_ID
| INTEGER NOT NULL
| This field contains the store ID to which the campaign belongs.
|
| NAME
| VARCHAR(64) NOT NULL
| This field contains the name of the campaign.
|
| DESCRIPTION
| VARCHAR(254)
| This field provides a description of the campaign.
|
| TYPE
| INTEGER
| Reserved for IBM internal use.
|
| STATUS
| CHAR(1)
| Reserved for IBM internal use.
|
| FIELD1
| VARCHAR(254)
| Customizable.
|
| LASTUPDATE
| TIMESTAMP NOT NULL
| This field contains the timestamp for the last updates made to the campaign.
|
| LASTUPDATEDBY
| VARCHAR(254) NOT NULL
| This field contains the logon ID of the individual who last updated the campaign.
|
| OWNER
| VARCHAR(64)
| This field contains the name of the owner of the campaign.
|
| OBJECTIVE
| VARCHAR(254)
| This field contains the objectives and goals that the campaign intend to reach.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|