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 |