WebSphere Commerce database table: ESMAPTYP

This table contains object types that can be scheduled to E-Marketing Spot.

Column Descriptions

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
SQL060903235156590	ESMAPTYP_ID	Primary Key

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_1093	ESMAPTYP_ID	ESMAPOBJ	ESMAPTYP_ID	Cascade