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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031225750 USERS_ID+EMLPROMO_ID Primary Key
I0000566 EMLPROMO_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_962 EMLPROMO_ID EMLPROMO EMLPROMO_ID Cascade
F_961 USERS_ID USERS USERS_ID Cascade

Feedback