civicrm_mailing_event_trackable_url_open


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
event_queue_id INT UNSIGNED 10 null
civicrm_mailing_event_queue.id FK_civicrm_mailing_event_trackable_url_open_event_queue_id C

FK to EventQueue

trackable_url_id INT UNSIGNED 10 null
civicrm_mailing_trackable_url.id FK_civicrm_mailing_event_trackable_url_open_trackable_url_id C

FK to TrackableURL

time_stamp DATETIME 19 null

When this trackable URL open occurred.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_mailing_event_trackable_url_open_event_queue_id Performance Asc event_queue_id
FK_civicrm_mailing_event_trackable_url_open_trackable_url_id Performance Asc trackable_url_id

Relationships