DMCAMPAIGN

A group of activities to meet specific marketing objectives.

Column Descriptions:

NameTypeDescription
DMCAMPAIGN_IDINTEGER NOT NULLThe unique identifier of a marketing campaign.
STOREENT_IDINTEGER NOT NULLThe identifier of the store in which the campaign was created.
NAMEVARCHAR (64) NOT NULLThe name of the marketing campaign.
DESCRIPTIONVARCHAR (254)The description of the marketing campaign.
STATESMALLINT NOT NULL DEFAULT 0This column is not currently used. Was previously used to specify current state of a marketing campaign. Valid values include: 0 = inactive, 1 = active. The default value is 0.
SEASONVARCHAR (254)The season of the year in which the campaign should be run.
TYPEINTEGERThis column is not currently used. Was previously used to specify type of a marketing campaign.
STARTDATETIMESTAMPThis column is not currently used. Was previously used to specify start time for a campaign.
ENDDATETIMESTAMPThis column is not currently used. Was previously used to specify end time for a campaign.
CREATEDTIMESTAMPThe time when the marketing campaign was created.
LASTUPDATETIMESTAMPThe time when the marketing campaign was last updated.
LASTUPDATEDBYVARCHAR (254)The information about the individual who last updated the marketing campaign.
OWNERVARCHAR (64)The name of the business owner of the campaign.
OBJECTIVEVARCHAR (254)The objectives and goals that the marketing campaign intends to reach.
FIELD1INTEGERCustomizable field.
FIELD2BIGINTCustomizable field.
FIELD3DECIMAL (20,5)Customizable field.
FIELD4VARCHAR (254)Customizable field.
UP_NAMEVARCHAR (64)The equivalent value of the NAME column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
UP_DESCRIPTIONVARCHAR (254)The equivalent value of the DESCRIPTION column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>DMCAMPAIGN_IDPrimary Key
I0001139NAME+STOREENT_IDUnique Index
I0001140STOREENT_IDNon-Unique Index
IPF00014UP_NAMENon-Unique Index
IPF00015UP_DESCRIPTIONNon-Unique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3523DMCAMPAIGN_IDDMACTIVITYDMCAMPAIGN_IDCascade