Database Table: EMLGRPREL

This table stores the relationship between an e-mail activity and its assigned member group (customer profile).

Column Name Column Type Column Description
EMLPROMO_ID INTEGER
NOT NULL
The ID of the e-mail activity in the relationship.
MBRGRP_ID BIGINT
NOT NULL
The ID of the member group (customer profile) that will be sent the related e-mail activity.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034923700 EMLPROMO_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable