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 - Active |
EMLBODYTYPE | SMALLINT NOT NULL DEFAULT 0 | The type of the e-mail body. Possible values include: 0-HTML 1-Plain text |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000288 | STOREENT_ID+NAME | Unique Index |
SQL050212031225230 | EMLMSG_ID | Primary Key |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_973 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1210 | EMLMSG_ID | EMLMCREL | EMLMSG_ID | Cascade |
F_957 | EMLMSG_ID | EMLPROMO | EMLMSG_ID | Cascade |