WebSphere Commerce database table: DMACTIVITY

DMACTIVITY

A definition of the interaction with a customer to market content.

Column Descriptions:

Name Type Description
DMACTIVITY_ID INTEGER NOT NULL The unique identifier of a marketing activity.
STOREENT_ID INTEGER NOT NULL The unique identifier of the store in which the marketing activity was created.
NAME VARCHAR (64) NOT NULL The name of the marketing activity.
VERSION INTEGER NOT NULL DEFAULT 1 The current version number of the marketing activity. If changes are made to the content of the marketing activity, then the version number will be incremented. The default value is 1.
PUBLISHED INTEGER NOT NULL DEFAULT 0 The published version number of the marketing activity. This is the version running on the storefront. The default value is 0.
STATE SMALLINT NOT NULL DEFAULT 0 The current state of the marketing activity. Valid values include: 0 = inactive, 1 = active, 2 = archived. The default value is 0.
STARTDATE TIMESTAMP The start time for the marketing activity. If the start time is null, then the marketing activity can start immediately.
ENDDATE TIMESTAMP The end time for the marketing activity. If the end time is null, then the marketing activity will run indefinitely.
PRIORITY SMALLINT NOT NULL DEFAULT 0 The priority of the marketing activity. The default value is 0.
DMCAMPAIGN_ID INTEGER The campaign associated with the marketing activity.
DMACTTYPE_ID SMALLINT NOT NULL DEFAULT 0 The type of the marketing activity. Possible types are web, dialog, e-mail, search, and pageLayout. The default value is 0 (web).
DMTEMPLATETYPE_ID SMALLINT The type of this marketing activity template. If this value is not null, then this activity is a template marketing activity used as a starting point for creating activities.
DMEXPTYPE_ID SMALLINT The type of this marketing activity experiment. If this value is not null, then this activity is an experiment.
REPEATABLE SMALLINT NOT NULL DEFAULT 1 This activity is repeatable by customers.
CREATED TIMESTAMP The time when the marketing activity was created.
LASTUPDATE TIMESTAMP The time when the marketing activity was last updated.
LASTUPDATEDBY VARCHAR (254) The information about the individual who last updated the marketing activity.
DESCRIPTION VARCHAR (254) The description of the marketing activity.
FLOWXML CLOB (1000000) The XML definition of the flow associated with the marketing activity. This column is deprecated and is no longer used.
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.
BEHAVIOR SMALLINT NOT NULL DEFAULT 1 If this web activity displays the same results to all customers, then set this value to 0. If this web activity has dynamic behavior that can display different results, then set this value to 1. The associated e-Marketing Spot can use this setting to determine how to cache the e-Marketing Spot results.
UIDISPLAYABLE SMALLINT Indicates if this element should be displayed in CMC. Null/1: means Yes. 0: means No.
MANAGINGTOOL SMALLINT Indicates what tools manages that element. Null/0: means Marketing tool. 1: means Page Layout.
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> DMACTIVITY_ID Primary Key
I0001141 NAME+STOREENT_ID Unique Index
I0001142 STOREENT_ID Non-Unique Index
I0001143 DMCAMPAIGN_ID Non-Unique Index
I0001144 DMACTTYPE_ID Non-Unique Index
I0001145 DMTEMPLATETYPE_ID Non-Unique Index
I0001146 DMEXPTYPE_ID Non-Unique Index
I0001193 STARTDATE Non-Unique Index
IPF00012 UP_NAME Non-Unique Index
IPF00013 UP_DESCRIPTION Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_3523 DMCAMPAIGN_ID DMCAMPAIGN DMCAMPAIGN_ID Cascade
F_3524 DMACTTYPE_ID DMACTTYPE DMACTTYPE_ID Cascade
F_3525 DMTEMPLATETYPE_ID DMTEMPLATETYPE DMTEMPLATETYPE_ID Cascade
F_3526 DMEXPTYPE_ID DMEXPTYPE DMEXPTYPE_ID Cascade

Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_3529 DMACTIVITY_ID DMELEMENT DMACTIVITY_ID Cascade
F_3530 DMACTIVITY_ID DMTRIGLSTN DMACTIVITY_ID Cascade
F_3550 DMACTIVITY_ID DMEXPFAMILY DMACTIVITY_ID Cascade
F_3761 DMACTIVITY_ID PLLOCATION DMACTIVITY_ID Cascade

Related reference
Commerce Composer data model

Name	Type	Description
DMACTIVITY_ID	INTEGER NOT NULL	The unique identifier of a marketing activity.
STOREENT_ID	INTEGER NOT NULL	The unique identifier of the store in which the marketing activity was created.
NAME	VARCHAR (64) NOT NULL	The name of the marketing activity.
VERSION	INTEGER NOT NULL DEFAULT 1	The current version number of the marketing activity. If changes are made to the content of the marketing activity, then the version number will be incremented. The default value is 1.
PUBLISHED	INTEGER NOT NULL DEFAULT 0	The published version number of the marketing activity. This is the version running on the storefront. The default value is 0.
STATE	SMALLINT NOT NULL DEFAULT 0	The current state of the marketing activity. Valid values include: 0 = inactive, 1 = active, 2 = archived. The default value is 0.
STARTDATE	TIMESTAMP	The start time for the marketing activity. If the start time is null, then the marketing activity can start immediately.
ENDDATE	TIMESTAMP	The end time for the marketing activity. If the end time is null, then the marketing activity will run indefinitely.
PRIORITY	SMALLINT NOT NULL DEFAULT 0	The priority of the marketing activity. The default value is 0.
DMCAMPAIGN_ID	INTEGER	The campaign associated with the marketing activity.
DMACTTYPE_ID	SMALLINT NOT NULL DEFAULT 0	The type of the marketing activity. Possible types are web, dialog, e-mail, search, and pageLayout. The default value is 0 (web).
DMTEMPLATETYPE_ID	SMALLINT	The type of this marketing activity template. If this value is not null, then this activity is a template marketing activity used as a starting point for creating activities.
DMEXPTYPE_ID	SMALLINT	The type of this marketing activity experiment. If this value is not null, then this activity is an experiment.
REPEATABLE	SMALLINT NOT NULL DEFAULT 1	This activity is repeatable by customers.
CREATED	TIMESTAMP	The time when the marketing activity was created.
LASTUPDATE	TIMESTAMP	The time when the marketing activity was last updated.
LASTUPDATEDBY	VARCHAR (254)	The information about the individual who last updated the marketing activity.
DESCRIPTION	VARCHAR (254)	The description of the marketing activity.
FLOWXML	CLOB (1000000)	The XML definition of the flow associated with the marketing activity. This column is deprecated and is no longer used.
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.
BEHAVIOR	SMALLINT NOT NULL DEFAULT 1	If this web activity displays the same results to all customers, then set this value to 0. If this web activity has dynamic behavior that can display different results, then set this value to 1. The associated e-Marketing Spot can use this setting to determine how to cache the e-Marketing Spot results.
UIDISPLAYABLE	SMALLINT	Indicates if this element should be displayed in CMC. Null/1: means Yes. 0: means No.
MANAGINGTOOL	SMALLINT	Indicates what tools manages that element. Null/0: means Marketing tool. 1: means Page Layout.
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.

Name	Column Names	Type
<SYSTEM-GENERATED>	DMACTIVITY_ID	Primary Key
I0001141	NAME+STOREENT_ID	Unique Index
I0001142	STOREENT_ID	Non-Unique Index
I0001143	DMCAMPAIGN_ID	Non-Unique Index
I0001144	DMACTTYPE_ID	Non-Unique Index
I0001145	DMTEMPLATETYPE_ID	Non-Unique Index
I0001146	DMEXPTYPE_ID	Non-Unique Index
I0001193	STARTDATE	Non-Unique Index
IPF00012	UP_NAME	Non-Unique Index
IPF00013	UP_DESCRIPTION	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_3523	DMCAMPAIGN_ID	DMCAMPAIGN	DMCAMPAIGN_ID	Cascade
F_3524	DMACTTYPE_ID	DMACTTYPE	DMACTTYPE_ID	Cascade
F_3525	DMTEMPLATETYPE_ID	DMTEMPLATETYPE	DMTEMPLATETYPE_ID	Cascade
F_3526	DMEXPTYPE_ID	DMEXPTYPE	DMEXPTYPE_ID	Cascade

Constraint	Columns	Child Table	Child Columns	Type
F_3529	DMACTIVITY_ID	DMELEMENT	DMACTIVITY_ID	Cascade
F_3530	DMACTIVITY_ID	DMTRIGLSTN	DMACTIVITY_ID	Cascade
F_3550	DMACTIVITY_ID	DMEXPFAMILY	DMACTIVITY_ID	Cascade
F_3761	DMACTIVITY_ID	PLLOCATION	DMACTIVITY_ID	Cascade