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 Descriptions
| 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.
|