WebSphere Commerce database table: EMLMSG

This table stores e-mail message templates. Each row corresponds to an e-mail message template which can be used within an e-mail activity.


Column Description(s):
Column NameColumn TypeDescription
EMLMSG_ID INTEGER NOT NULL The primary key.
JSPPATH VARCHAR(254) The absolute URL used to find e-mail message content.
PROPERTYFILE VARCHAR(254) NOT NULL Reserved for IBM internal use.
NAME VARCHAR(254) NOT NULL The name of the e-mail activity template.
DESCRIPTION VARCHAR(254) A description of the e-mail activity template.
STOREENT_ID INTEGER NOT NULL The store to which the e-mail activity template is registered.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
STATUS SMALLINT NOT NULL DEFAULT 1 Represents the current state of the e-mail template. Possible values include:
0 - Deleted
1 - Active
EMLBODYTYPE SMALLINT NOT NULL DEFAULT 0 The type of the e-mail body. Possible values include:
0-HTML
1-Plain text
Index(es):
Index NameIndexed Column NamesIndex Type
I0000288 STOREENT_ID+NAME Unique Index
SQL050212031225230 EMLMSG_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_973 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1210 EMLMSG_ID EMLMCREL EMLMSG_ID Cascade
F_957 EMLMSG_ID EMLPROMO EMLMSG_ID Cascade

Feedback