Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EMLPROMO
This table stores e-mail activities. Each row corresponds to an e-mail activity which is sent to a given customer profile.
Column Name Column Type Description EMLPROMO_ID INTEGER NOT NULL The primary key. STATUS INTEGER NOT NULL DEFAULT 0 Represents the current state of the e-mail activity. Possible values include:
0 - unsent
1 - sent
2 - deletedMODIFIEDBY VARCHAR(254) The logon ID of the person who last modified the e-mail activity. MODDATE TIMESTAMP The date on which the last modification was performed. DESCRIPTION VARCHAR(254) The description of the e-mail activity. NAME VARCHAR(254) NOT NULL The name given to the e-mail activity. EMLMSG_ID INTEGER NOT NULL The e-mail message template to send to the target customer segment. STOREENT_ID INTEGER NOT NULL The ID of the store with which the e-mail activity is associated. SCCJOBREFNUM BIGINT NOT NULL Foreign key to SCHCONFIG table. REPLYTO VARCHAR(256) The reply-to e-mail address for the e-mail activity. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030332580 EMLPROMO_ID Primary Key I0000339 STOREENT_ID Non-Unique Index I0000564 EMLMSG_ID Non-Unique Index I0000565 SCCJOBREFNUM Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_957 EMLMSG_ID EMLMSG EMLMSG_ID Cascade F_959 SCCJOBREFNUM SCHCONFIG SCCJOBREFNUM Cascade F_958 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1034 EMLPROMO_ID EMLBOUNCED EMLPROMO_ID Cascade F_1040 EMLPROMO_ID EMLCAMPREL EMLPROMO_ID Cascade F_963 EMLPROMO_ID EMLGRPREL EMLPROMO_ID Cascade F_960 EMLPROMO_ID EMLRCPTS EMLPROMO_ID Cascade F_962 EMLPROMO_ID EMLRPTEVTS EMLPROMO_ID Cascade _vcc_freeselect_bottom_