Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EMLCONTENT
Stores the content of the e-mail template.
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 SQL100520030331850 EMLCONTENT_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1211 EMLCONTENT_ID EMLMCREL EMLCONTENT_ID Cascade _vcc_freeselect_bottom_