WebSphere Commerce database table: EMLMCREL

WebSphere Commerce database table: EMLMCREL

Stores the relationship between EMLMSG and EMLCONTENT table.

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

SQL060903235155100 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

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.

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