Extension:ContributionTracking/contribution_tracking table

Fields

id

Primary key.

Schema summary

mysql> describe contribution_tracking;
+-----------------+---------------------+------+-----+---------+----------------+
| Field           | Type                | Null | Key | Default | Extra          |
+-----------------+---------------------+------+-----+---------+----------------+
| id              | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| contribution_id | int(10) unsigned    | YES  | UNI | NULL    |                |
| form_amount     | varchar(20)         | YES  |     | NULL    |                |
| usd_amount      | decimal(20,2)       | YES  |     | NULL    |                |
| note            | text                | YES  |     | NULL    |                |
| referrer        | varchar(4096)       | YES  |     | NULL    |                |
| anonymous       | tinyint(1) unsigned | YES  |     | NULL    |                |
| utm_source      | varchar(128)        | YES  |     | NULL    |                |
| utm_medium      | varchar(128)        | YES  |     | NULL    |                |
| utm_campaign    | varchar(128)        | YES  |     | NULL    |                |
| utm_key         | varchar(128)        | YES  |     | NULL    |                |
| payments_form   | varchar(50)         | YES  |     | NULL    |                |
| optout          | tinyint(1) unsigned | YES  |     | NULL    |                |
| language        | varchar(8)          | YES  |     | NULL    |                |
| country         | varchar(2)          | YES  |     | NULL    |                |
| ts              | char(14)            | YES  | MUL | NULL    |                |
| owa_session     | varbinary(255)      | YES  |     | NULL    |                |
| owa_ref         | int(11)             | YES  |     | NULL    |                |
+-----------------+---------------------+------+-----+---------+----------------+

(see source here).