A group of activities to meet specific marketing
objectives.
Column Descriptions:
Name | Type | Description |
DMCAMPAIGN_ID | INTEGER NOT NULL | The unique identifier of a marketing
campaign. |
STOREENT_ID | INTEGER NOT NULL | The identifier of the store in which the campaign
was created. |
NAME | VARCHAR (64) NOT NULL | The name of the marketing campaign. |
DESCRIPTION | VARCHAR (254) | The description of the marketing campaign. |
STATE | SMALLINT NOT NULL DEFAULT 0 | This 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. |
SEASON | VARCHAR (254) | The season of the year in which the campaign
should be run. |
TYPE | INTEGER | This column is not currently used. Was previously
used to specify type of a marketing campaign. |
STARTDATE | TIMESTAMP | This column is not currently used. Was previously
used to specify start time for a campaign. |
ENDDATE | TIMESTAMP | This column is not currently used. Was previously
used to specify end time for a campaign. |
CREATED | TIMESTAMP | The time when the marketing campaign was
created. |
LASTUPDATE | TIMESTAMP | The time when the marketing campaign was last
updated. |
LASTUPDATEDBY | VARCHAR (254) | The information about the individual who last
updated the marketing campaign. |
OWNER | VARCHAR (64) | The name of the business owner of the
campaign. |
OBJECTIVE | VARCHAR (254) | The objectives and goals that the marketing
campaign intends to reach. |
FIELD1 | INTEGER | Customizable field. |
FIELD2 | BIGINT | Customizable field. |
FIELD3 | DECIMAL (20,5) | Customizable field. |
FIELD4 | VARCHAR (254) | Customizable field. |
UP_NAME | VARCHAR (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_DESCRIPTION | VARCHAR (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. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | DMCAMPAIGN_ID | Primary Key |
I0001139 | NAME+STOREENT_ID | Unique Index |
I0001140 | STOREENT_ID | Non-Unique Index |
IPF00014 | UP_NAME | Non-Unique Index |
IPF00015 | UP_DESCRIPTION | Non-Unique Index |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_3523 | DMCAMPAIGN_ID | DMACTIVITY | DMCAMPAIGN_ID | Cascade |