WebSphere Commerce database table: ESMAPOBJ

WebSphere Commerce database table: ESMAPOBJ

This table contains objects scheduled to E-Marketing Spot.
Column Descriptions
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
SQL060903235156450 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

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_386 INITIATIVE_ID INTVSCHED ESMAPOBJ_ID Cascade

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.

Index Name	Indexed Column Names	Index Type
I0000833	ESMAPTYP_ID+OBJECT_ID	Unique Index
SQL060903235156450	ESMAPOBJ_ID	Primary Key