Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EMLMCREL
Stores the relationship between EMLMSG and EMLCONTENT table.
Column Name Column Type Description EMLMSG_ID INTEGER NOT NULL Reference to the EMLMSG_ID in the EMLMSG table. EMLCONTENT_ID INTEGER NOT NULL Reference to the EMLCONTENT_ID in the EMLCONTENT table. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030332140 EMLMSG_ID+EMLCONTENT_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1211 EMLCONTENT_ID EMLCONTENT EMLCONTENT_ID Cascade F_1210 EMLMSG_ID EMLMSG EMLMSG_ID Cascade _vcc_freeselect_bottom_