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 Descriptions Column Name Column Type Description EXPERIMENT_ID INTEGER NOT NULL No EXPERIMENT_ID external description assigned yet SESSION_ID VARCHAR(64) NOT NULL No SESSION_ID external description assigned yet USERS_ID BIGINT NOT NULL No USERS_ID external description assigned yet RESULTNUMBER SMALLINT NOT NULL No RESULTNUMBER external description assigned yet OPTCOUNTER SMALLINT No OPTCOUNTER external description assigned yet
Indexes Index Name Indexed Column Names Index Type SQL060903235157240 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