Stores the content of the e-mail template.
Column Descriptions:
Name | 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 (10000000) NOT NULL | The body of the e-mail message. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | EMLCONTENT_ID | Primary Key |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_1211 | EMLCONTENT_ID | EMLMCREL | EMLCONTENT_ID | Cascade |