WebSphere Commerce database table: EMLCONTENT

WebSphere Commerce database table: EMLCONTENT

Stores the content of the e-mail template.

Column Descriptions
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.

Indexes
Index Name Indexed Column Names Index Type

SQL060903235154760 EMLCONTENT_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type

F_1211 EMLCONTENT_ID EMLMCREL EMLCONTENT_ID Cascade

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.