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 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 NOT NULL DEFAULT 0 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