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 Name Column Type Column Description
DESCRIPTION VARCHAR (254)
NULL
A description of the e-mail activity template.
EMLMSG_ID INTEGER
NOT NULL
The primary key.
JSPPATH VARCHAR (254)
NOT NULL
The absolute URL used to find e-mail message content.
NAME VARCHAR (254)
NOT NULL
The name used to refer to this e-mail message template.
PROPERTYFILE VARCHAR (254)
NOT NULL
Reserved for IBM internal use.
STOREENT_ID INTEGER
NOT NULL
The store to which the e-mail message is registered.
Indexes:
Index Name Indexed Column Names Index Type
I0000288 STOREENT_ID, NAME Unique Index
SQL030416034924000 EMLMSG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_973 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_957 EMLMSG_ID EMLPROMO EMLMSG_ID Cascade