Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EXPRESULT
This table stores the randomly generated number, known as the experiment result, which is used to determine the control or test element to be used in the marketing experiment.
Column Name Column Type Description EXPERIMENT_ID INTEGER NOT NULL The experiment identifier as described in the EXPERIMENT_ID column of the EXPERIMENT table. SESSION_ID VARCHAR(64) NOT NULL Persistent session ID. USERS_ID BIGINT NOT NULL Reference to the ID of the user in the USERS table. RESULTNUMBER SMALLINT NOT NULL The randomly generated number used as the result for this experiment and user. OPTCOUNTER SMALLINT Reserved IBM Internal Use.
Indexes Index Name Indexed Column Names Index Type SQL100520030334290 EXPERIMENT_ID+SESSION_ID+USERS_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1502 EXPERIMENT_ID EXPERIMENT EXPERIMENT_ID Cascade _vcc_freeselect_bottom_