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 Column Description
BOUNCED TIMESTAMP
NULL
The time at which it was determined the recipient did not receive the e-mail.
CLICKED TIMESTAMP
NULL
The time at which it was determined the recipient clicked on a URL within the e-mail.
EMLPROMO_ID INTEGER
NOT NULL
The foreign key to the e-mail promotion that was sent to the e-mail recipient.
OPENED TIMESTAMP
NULL
The time at which is was determined the recipient opened the e-mail.
USERS_ID BIGINT
NOT NULL
The foreign key to the recipient user that caused an e-mail event.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034925370 USERS_ID, EMLPROMO_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_961 USERS_ID USERS USERS_ID Cascade
F_962 EMLPROMO_ID EMLPROMO EMLPROMO_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable