WebSphere Commerce database table: ESMAPTYP

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000832 NAME Unique Index
SQL050212031226430 ESMAPTYP_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1093 ESMAPTYP_ID ESMAPOBJ ESMAPTYP_ID Cascade

Feedback