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 Descriptions:

NameTypeDescription
EMLMSG_IDINTEGER NOT NULLThe primary key.
JSPPATHVARCHAR (254)The absolute URL used to find e-mail message content.
PROPERTYFILEVARCHAR (254) NOT NULLReserved for IBM internal use.
NAMEVARCHAR (254) NOT NULLThe name of the e-mail activity template.
DESCRIPTIONVARCHAR (254)A description of the e-mail activity template.
STOREENT_IDINTEGER NOT NULLThe store to which the e-mail activity template is registered.
STATUSSMALLINT NOT NULL DEFAULT 1Represents the current state of the e-mail template. Possible values include: 0 - Deleted 1 - Active
EMLBODYTYPESMALLINT NOT NULL DEFAULT 0The type of the e-mail body. Possible values include: 0-HTML 1-Plain text
UP_NAMEVARCHAR (254)The equivalent value of the NAME column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
UP_DESCRIPTIONVARCHAR (254)The equivalent value of the DESCRIPTION column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EMLMSG_IDPrimary Key
I0000288STOREENT_ID+NAMEUnique Index
IPF00004UP_NAMENon-Unique Index
IPF00005UP_DESCRIPTIONNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_973STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1210EMLMSG_IDEMLMCRELEMLMSG_IDCascade
F_957EMLMSG_IDEMLPROMOEMLMSG_IDCascade