WebSphere Commerce database table: ESMAPOBJ

This table contains objects scheduled to E-Marketing Spot.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000833 ESMAPTYP_ID+OBJECT_ID Unique Index
SQL050212031226290 ESMAPOBJ_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1093 ESMAPTYP_ID ESMAPTYP ESMAPTYP_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_386 INITIATIVE_ID INTVSCHED ESMAPOBJ_ID Cascade

Feedback