Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EMLRPTEVTS
This table records e-mail events for each recipient of a particular e-mail activity. If a row does not exist for a recipient of an e-mail activity, the user has not yet caused an event.
Column Name Column Type Description USERS_ID BIGINT NOT NULL Foreign key to the USERS table. Identifies the recipient user that caused an e-mail event. EMLPROMO_ID INTEGER NOT NULL Foreign key to the EMLPROMO table. Identifies the e-mail activity that was sent to the e-mail recipient. OPENED TIMESTAMP The time at which is was determined the recipient opened the e-mail. CLICKED TIMESTAMP The time at which it was determined the recipient clicked on a URL within the e-mail. BOUNCED TIMESTAMP The time at which it was determined the recipient did not receive the e-mail. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030332890 USERS_ID+EMLPROMO_ID Primary Key I0000566 EMLPROMO_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_962 EMLPROMO_ID EMLPROMO EMLPROMO_ID Cascade F_961 USERS_ID USERS USERS_ID Cascade _vcc_freeselect_bottom_