Stores the content of the e-mail template.
Column Description(s):
Column Name | Column Type | Description |
EMLCONTENT_ID |
INTEGER NOT NULL |
The primary key. |
LASTMODIFY |
TIMESTAMP |
The date on which the last modification was performed |
RECORDOPEN |
SMALLINT |
Indicates whether the open rate is recorded when the e-mail content is used: 1 - record the e-mail open 0 - do not record the e-mail open rate |
EMLSUBJECT |
VARCHAR(254) NOT NULL |
The subject of the e-mail message. |
EMLBODY |
CLOB NOT NULL |
The body of the e-mail message. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031224580 |
EMLCONTENT_ID |
Primary Key |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1211 |
EMLCONTENT_ID |
EMLMCREL |
EMLCONTENT_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.