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 HCL 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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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