Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: ESMAPOBJ
This table contains objects scheduled to E-Marketing Spot.
Column Name Column Type Description ESMAPOBJ_ID INTEGER NOT NULL A system-generated primary key. ESMAPTYP_ID INTEGER NOT NULL The type ID of the object. This corresponds to the type IDs defined in the ESMAPTYP table. OBJECT_ID INTEGER NOT NULL The object ID of the object scheduled to display in the E-Marketing Spot. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000833 ESMAPTYP_ID+OBJECT_ID Unique Index SQL100520030333520 ESMAPOBJ_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1093 ESMAPTYP_ID ESMAPTYP ESMAPTYP_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_386 INITIATIVE_ID INTVSCHED ESMAPOBJ_ID Cascade _vcc_freeselect_bottom_