civicrm_mailing_event_trackable_url_open

0 rows


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_idC

FK to EventQueue
trackable_url_id INT UNSIGNED 10 null
civicrm_mailing_trackable_url.id FK_civicrm_mailing_event_trackable_url_open_trackable_url_idC

FK to TrackableURL
time_stamp TIMESTAMP 19 √ CURRENT_TIMESTAMP

When this trackable URL open occurred.

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

Close relationships within degrees of separation