WebSphere Commerce database table: EMLCAMPREL

This table stores the relationship between an e-mail activity and a campaign. Each row represents the campaign to which the e-mail activity belongs.

Column Descriptions

Column Name	Column Type	Description
EMLPROMO_ID	INTEGER NOT NULL	Reference Key to the EMLPROMO table.
CAMPAIGN_ID	INTEGER NOT NULL	Reference Key to the CAMPAIGN table.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235154420	EMLPROMO_ID	Primary Key
I0000377	CAMPAIGN_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1041	CAMPAIGN_ID	CAMPAIGN	CAMPAIGN_ID	Cascade
F_1040	EMLPROMO_ID	EMLPROMO	EMLPROMO_ID	Cascade