Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
||||
| url | TEXT | 65535 | null |
|
|
The URL to be tracked. |
||||
| mailing_id | INT UNSIGNED | 10 | null |
|
|
FK to the mailing |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_mailing_trackable_url_mailing_id | Performance | Asc | mailing_id |

