Reference > Database > WebSphere Commerce database tables > D


WebSphere Commerce database table: DMTRIGSND

Time based triggers to send when the specified time has elapsed.

Column Name Column Type Description
DMELEMENT_ID INTEGER NOT NULL The identifier of the associated Trigger campaign element.
PERSONALIZATIONID VARCHAR(30) NOT NULL The unique personalization identifier of a customer.
STOREENT_ID INTEGER NOT NULL DEFAULT 0 The identifier of the store.
TIMETOSEND TIMESTAMP NOT NULL The time to send the Trigger to the marketing activity.
PARAMETERS CLOB The parameters associated with this Trigger.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030329100 DMELEMENT_ID+PERSONALIZATIONID+STOREENT_ID Primary Key
I0001195 TIMETOSEND Non-Unique Index

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search