Extension:ContributionTracking/contribution_tracking table

From MediaWiki.org
Jump to navigation Jump to search


Fields[edit]

id[edit]

Primary key.

contribution_id[edit]

form_amount[edit]

usd_amount[edit]

note[edit]

referrer[edit]

anonymous[edit]

utm_source[edit]

utm_medium[edit]

utm_campaign[edit]

utm_key[edit]

payments_form[edit]

optout[edit]

language[edit]

country[edit]

ts[edit]

owa_session[edit]

owa_ref[edit]

Schema summary[edit]

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).