Reference > Database > WebSphere Commerce database tables > E
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 Name Column Type Description 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 - ActiveEMLBODYTYPE SMALLINT NOT NULL DEFAULT 0 The type of the e-mail body. Possible values include:
0-HTML
1-Plain text
Indexes Index Name Indexed Column Names Index Type I0000288 STOREENT_ID+NAME Unique Index SQL100520030332290 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_1210 EMLMSG_ID EMLMCREL EMLMSG_ID Cascade F_957 EMLMSG_ID EMLPROMO EMLMSG_ID Cascade _vcc_freeselect_bottom_