Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMEXPLOG
This table contains the details of what was displayed to a customer on a store page in an e-Marketing Spot as a result of an experiment.
Column Name Column Type Description DMEXPLOG_ID BIGINT NOT NULL The unique identifier of the experiment log entry. STOREENT_ID INTEGER NOT NULL The ID of the store. EXPERIMENT_ID INTEGER NOT NULL The identifier of the experiment within the activity. TESTELEMENT_ID INTEGER NOT NULL The identifier of the experiment path in the marketing activity. PERSONALIZATIONID VARCHAR(30) NOT NULL The unique personalization identifier of a customer. CREATED TIMESTAMP NOT NULL The time this experiment log entry was created. CLICKED SMALLINT NOT NULL DEFAULT 0 Has the customer clicked on the item displayed in the eMarketing Spot. 0 - the customer has not clicked the item; 1- the customer has clicked the item. VALUE VARCHAR(254) NOT NULL The ID of the item that was displayed in the e-Marketing Spot. CONTENTTYPE VARCHAR(254) NOT NULL The type of content that was displayed. Valid values include: CatalogGroup, CatalogEntry, MarketingContent. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030328080 DMEXPLOG_ID Primary Key I0001198 STOREENT_ID+PERSONALIZATIONID+CREATED Non-Unique Index I0001199 STOREENT_ID+EXPERIMENT_ID+TESTELEMENT_ID+CREATED Non-Unique Index _vcc_freeselect_bottom_