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:
Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | USERS_ID+EMLPROMO_ID | Primary Key |
I0000566 | EMLPROMO_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_961 | USERS_ID | USERS | USERS_ID | Cascade |
F_962 | EMLPROMO_ID | EMLPROMO | EMLPROMO_ID | Cascade |