Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: ESMAPTYP
This table contains object types that can be scheduled to E-Marketing Spot.
Column Name Column Type Description ESMAPTYP_ID INTEGER NOT NULL The ID representing the object type. NAME VARCHAR(20) NOT NULL The name of the object type to be scheduled to an E-marketing spot. By default the possible values are:
1. Initiative
2. Content
DESCRIPTION VARCHAR(100) The full description of the object type. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000832 NAME Unique Index SQL100520030333680 ESMAPTYP_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1093 ESMAPTYP_ID ESMAPOBJ ESMAPTYP_ID Cascade _vcc_freeselect_bottom_