Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMELEMENTTYPE
Types of trigger, target and action campaign elements for an activity.
Column Name Column Type Description DMELEMENTTYPE_ID INTEGER NOT NULL The unique identifier of a campaign element type. Valid values include: 1 = Trigger, 2 = Target, 3 = Action, 4 = Branch, 5 = Path. TYPE VARCHAR(64) NOT NULL The name of the type of campaign element. DESCRIPTION VARCHAR(254) The description of the campaign element type. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030326760 DMELEMENTTYPE_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3527 DMELEMENTTYPE_ID DMELETEMPLATE DMELEMENTTYPE_ID Cascade _vcc_freeselect_bottom_