Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMELESTATS
Statistics of trigger, target and action campaign elements within an activity.
Column Name Column Type Description DMELEMENT_ID INTEGER NOT NULL The identifier of the campaign element. STOREENT_ID INTEGER NOT NULL DEFAULT 0 The identifier of the store. COUNTER INTEGER NOT NULL DEFAULT 0 The number of times the campaign element has been reached in the marketing activity by all customers. 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 SQL100520030326890 DMELEMENT_ID+STOREENT_ID Primary Key _vcc_freeselect_bottom_