Reference > Database > WebSphere Commerce database tables > E
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 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 SQL100520030331530 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 _vcc_freeselect_bottom_