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_