Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMACTATTR
Attributes of a marketing activity.
Column Name Column Type Description DMACTIVITY_ID INTEGER NOT NULL The unique identifier of the marketing activity. STOREENT_ID INTEGER NOT NULL DEFAULT 0 The identifier of the store. PROCESSED TIMESTAMP For bulk e-mail activities, this is set to the time which the bulk e-mail was sent. The entry associated with DMACTIVITY_ID 0 and STOREENT_ID 0 indicates the last time the SendMarketingTriggers scheduled job processed the triggers that are sent once a day. This entry will be updated once a day.
For Dialog activities, the entry indicates the last time the SendMarketingTriggers scheduled job processed the triggers for this activity. This is for Dialog activities that contain triggers that have the runOnce or runDaily element name-value pair.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030325890 DMACTIVITY_ID+STOREENT_ID Primary Key _vcc_freeselect_bottom_