EMLCONTENT

Stores the content of the e-mail template.

Column Descriptions:

NameTypeDescription
EMLCONTENT_IDINTEGER NOT NULLThe primary key.
LASTMODIFYTIMESTAMPThe date on which the last modification was performed
RECORDOPENSMALLINTIndicates 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
EMLSUBJECTVARCHAR (254) NOT NULLThe subject of the e-mail message.
EMLBODYCLOB (10000000) NOT NULLThe body of the e-mail message.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EMLCONTENT_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1211EMLCONTENT_IDEMLMCRELEMLCONTENT_IDCascade