Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EXPTYPE
This table stores all the available types of marketing experiment that a business user can choose.
Column Name Column Type Description EXPTYPE_ID INTEGER NOT NULL Primary Key. NAME VARCHAR(64) NOT NULL Name of the experiment type. DESCRIPTION VARCHAR(254) Description of the experiment type. IMPLCLS VARCHAR(254) NOT NULL The name of the class that implements the evaluation logic of this type of experiment. OBJCLS VARCHAR(254) NOT NULL The name of the class that implements the data object of this type of experiment. FIELD1 VARCHAR(254) Customizable. FIELD2 VARCHAR(254) Customizable. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030334590 EXPTYPE_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1501 EXPTYPE_ID EXPERIMENT EXPTYPE_ID Cascade F_1506 EXPTYPE_ID EXPSTATS EXPTYPE_ID Cascade _vcc_freeselect_bottom_