Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMTRIGLSTN
List of triggers that are being listened for in marketing activities.
Column Name Column Type Description DMELEMENT_ID INTEGER NOT NULL The identifier of the campaign element. NAME VARCHAR(64) NOT NULL The name of the Trigger to detect. STOREENT_ID INTEGER NOT NULL The identifier of the store in which to detect the Trigger. DMACTIVITY_ID INTEGER NOT NULL The identifier of the marketing activity to which to send the Trigger when it is detected. ALLUSERS SMALLINT A flag that specifies if all customers can be waiting for this Trigger, or if only specific customers are waiting for this Trigger. Valid values include: 0 = check that the specific customer is waiting for the Trigger, 1 = all customers are waiting for this Trigger. 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 SQL100520030328960 DMELEMENT_ID Primary Key I0001152 NAME+STOREENT_ID Non-Unique Index I0001153 DMACTIVITY_ID Non-Unique Index I0001154 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3530 DMACTIVITY_ID DMACTIVITY DMACTIVITY_ID Cascade F_3531 DMELEMENT_ID DMELEMENT DMELEMENT_ID Cascade _vcc_freeselect_bottom_