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_


+

Search Tips   |   Advanced Search