WebSphere Commerce database table: EMLGRPREL

This table stores the relationship between an e-mail activity and its target customer segment.

Column Descriptions

Column Name	Column Type	Description
MBRGRP_ID	BIGINT NOT NULL	The ID of the customer segment targeted by the related e-mail activity.
EMLPROMO_ID	INTEGER NOT NULL	The ID of the e-mail activity in the relationship.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235154940	EMLPROMO_ID	Primary Key
I0000563	MBRGRP_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_963	EMLPROMO_ID	EMLPROMO	EMLPROMO_ID	Cascade
F_964	MBRGRP_ID	MBRGRP	MBRGRP_ID	Cascade