Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EMLGRPREL
This table stores the relationship between an e-mail activity and its target customer segment.
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 SQL100520030332000 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 _vcc_freeselect_bottom_