WebSphere Commerce database table: EXPLOG
This table records the relevant data of a recommendation event. It captures which marketing experiment was run, which experimental element was used, the e-Marketing Spot and what was recommended to the customer.
Column Descriptions Column Name Column Type Description EXPLOG_ID BIGINT NOT NULL No EXPLOG_ID external description assigned yet EXPERIMENT_ID INTEGER NOT NULL No EXPERIMENT_ID external description assigned yet STOREENT_ID INTEGER NOT NULL No STOREENT_ID external description assigned yet SESSIONID CHAR(64) NOT NULL No SESSIONID external description assigned yet CREATED TIMESTAMP NOT NULL No CREATED external description assigned yet TESTELEMENT_ID INTEGER NOT NULL No TESTELEMENT_ID external description assigned yet RESULTTYPE CHAR(1) No RESULTTYPE external description assigned yet CLICKED CHAR(1) DEFAULT '0' No CLICKED external description assigned yet RESULTS VARCHAR(254) No RESULTS external description assigned yet OPTCOUNTER SMALLINT No OPTCOUNTER external description assigned yet
Indexes Index Name Indexed Column Names Index Type SQL060903235157080 EXPLOG_ID Primary Key I0001502 SESSIONID+STOREENT_ID Non-Unique Index