Reference > Database > WebSphere Commerce database tables > D


WebSphere Commerce database table: DMACTTYPE

Types of marketing activities. These include web, e-mail, and dialog.

Column Name Column Type Description
DMACTTYPE_ID SMALLINT NOT NULL The unique identifier of the type of a marketing activity. Valid values include: 0 = web, 1 = dialog, 2 = e-mail
TYPE VARCHAR(64) NOT NULL The type of the marketing activity template.
DESCRIPTION VARCHAR(254) The description of the type of marketing activity.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030326170 DMACTTYPE_ID Primary Key

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_3524 DMACTTYPE_ID DMACTIVITY DMACTTYPE_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search