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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034925370 | USERS_ID, EMLPROMO_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|