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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000288 | STOREENT_ID, NAME | Unique Index |
SQL030416034924000 | EMLMSG_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_973 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_957 | EMLMSG_ID | EMLPROMO | EMLMSG_ID | Cascade |