Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EMLRCPTS
This table records the recipients of an e-mail activity.
Column Name Column Type Description EMLPROMO_ID INTEGER NOT NULL Foreign key to the EMLPROMO table. COUNT INTEGER NOT NULL The total number of email addresses to which the e-mail activity was sent. RECIPIENTS CLOB Contains the e-mail address and ID information of the users to which the e-mail activity was sent. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030332720 EMLPROMO_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_960 EMLPROMO_ID EMLPROMO EMLPROMO_ID Cascade _vcc_freeselect_bottom_