Extension:ContributionTracking/contribution_tracking table
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).
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
