Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMACTIVITY
A definition of the interaction with a customer to market content.
Column Name Column 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. 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, and e-mail. 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 Is this activity 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 The XML defintion 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. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001141 NAME+STOREENT_ID Unique Index SQL100520030326030 DMACTIVITY_ID Primary Key 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
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3524 DMACTTYPE_ID DMACTTYPE DMACTTYPE_ID Cascade F_3523 DMCAMPAIGN_ID DMCAMPAIGN DMCAMPAIGN_ID Cascade F_3526 DMEXPTYPE_ID DMEXPTYPE DMEXPTYPE_ID Cascade F_3525 DMTEMPLATETYPE_ID DMTEMPLATETYPE DMTEMPLATETYPE_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3529 DMACTIVITY_ID DMELEMENT DMACTIVITY_ID Cascade F_3550 DMACTIVITY_ID DMEXPFAMILY DMACTIVITY_ID Cascade F_3530 DMACTIVITY_ID DMTRIGLSTN DMACTIVITY_ID Cascade