WebSphere Commerce database table: EXPTYPE

This table stores all the available types of marketing experiment that a business user can choose.

Column Descriptions
Column Name Column Type Description
EXPTYPE_ID INTEGER NOT NULL No EXPTYPE_ID external description assigned yet
NAME VARCHAR(64) NOT NULL No NAME external description assigned yet
DESCRIPTION VARCHAR(254) No DESCRIPTION external description assigned yet
IMPLCLS VARCHAR(254) NOT NULL No IMPLCLS external description assigned yet
OBJCLS VARCHAR(254) NOT NULL No OBJCLS external description assigned yet
FIELD1 VARCHAR(254) Customizable.
FIELD2 VARCHAR(254) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235157600 EXPTYPE_ID Primary Key

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