ShareASale

Explore the interactive ERD

Table & Field Reference

transaction

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`banner_name`	Unknown
`banner_number`	Unknown
`banner_page`	Unknown
`banner_type`	Unknown
`comment`	Unknown
`commission`	Unknown
`commission_type`	Unknown
`coupon_code`	Unknown
`date_of_click`	Unknown
`date_of_reversal`	Unknown
`date_of_transaction`	Unknown
`is_mobile`	Unknown
`last_ip`	Unknown
`last_referer`	Unknown
`lock_date`	Unknown
`locked`	Unknown
`merchant_defined_type`	Unknown
`new_customer_flag`	Unknown
`order_number`	Unknown
`original_currency`	Unknown
`original_currency_amount`	Unknown
`parent_transaction`	Unknown
`pending`	Unknown
`price_list`	Unknown
`quantity_list`	Unknown
`reference_transaction`	Unknown
`return_day`	Unknown
`sku_list`	Unknown
`ss_amount`	Unknown
`store_id`	Unknown
`time_of_click`	Unknown
`tool_id`	Unknown
`transaction_amount`	Unknown
`transaction_date`	Unknown
`transaction_type`	Unknown
`used_a_coupon`	Unknown
`user_agent`	Unknown
`voided`	Unknown

weekly_progress

Column	Type	Keys
`date`	Unknown	PK
`active_affiliate`	Unknown
`affiliate`	Unknown
`bonus_commission`	Unknown
`click`	Unknown
`commission`	Unknown
`gross_sale`	Unknown
`lead_commission`	Unknown
`leap_frog_commission`	Unknown
`manual_credit`	Unknown
`net_sale`	Unknown
`number_bonus`	Unknown
`number_lead`	Unknown
`number_leap_frog`	Unknown
`number_of_sale`	Unknown
`number_pay_per_call`	Unknown
`number_sale`	Unknown
`number_two_tier`	Unknown
`pay_per_call_commission`	Unknown
`sale_commission`	Unknown
`two_tier_commission`	Unknown
`void`	Unknown

affiliate_list

Column	Type	Keys
`user_id`	Unknown	PK
`address`	Unknown
`address_2`	Unknown
`apply_date`	Unknown
`city`	Unknown
`commission_bonus_last_month`	Unknown
`commission_bonus_month`	Unknown
`commission_bonus_today`	Unknown
`commission_last_month`	Unknown
`commission_lead_last_month`	Unknown
`commission_lead_month`	Unknown
`commission_lead_today`	Unknown
`commission_leap_frog_last_month`	Unknown
`commission_leap_frog_month`	Unknown
`commission_leap_frog_today`	Unknown
`commission_month`	Unknown
`commission_pp_call_last_month`	Unknown
`commission_pp_call_month`	Unknown
`commission_pp_call_today`	Unknown
`commission_sale_last_month`	Unknown
`commission_sale_month`	Unknown
`commission_sale_today`	Unknown
`commission_today`	Unknown
`commission_total`	Unknown
`commission_two_tier_last_month`	Unknown
`commission_two_tier_month`	Unknown
`commission_two_tier_today`	Unknown
`country`	Unknown
`email`	Unknown
`feedback_ave`	Unknown
`feedback_count`	Unknown
`feedback_rating`	Unknown
`groups`	Unknown
`hit_commission`	Unknown
`hit_last_month`	Unknown
`hit_month`	Unknown
`hit_today`	Unknown
`hit_total`	Unknown
`lead_commission`	Unknown
`note`	Unknown
`number_of_bonus_last_month`	Unknown
`number_of_bonus_month`	Unknown
`number_of_bonus_today`	Unknown
`number_of_lead_last_month`	Unknown
`number_of_lead_month`	Unknown
`number_of_lead_today`	Unknown
`number_of_leap_frog_last_month`	Unknown
`number_of_leap_frog_month`	Unknown
`number_of_leap_frog_today`	Unknown
`number_of_pp_call_last_month`	Unknown
`number_of_pp_call_month`	Unknown
`number_of_pp_call_today`	Unknown
`number_of_sale_last_month`	Unknown
`number_of_sale_month`	Unknown
`number_of_sale_today`	Unknown
`number_of_two_tier_last_month`	Unknown
`number_of_two_tier_month`	Unknown
`number_of_two_tier_today`	Unknown
`organization`	Unknown
`phone`	Unknown
`referred`	Unknown
`sale_commission`	Unknown
`sale_last_month`	Unknown
`sale_month`	Unknown
`sale_today`	Unknown
`sale_total`	Unknown
`signup_campaign`	Unknown
`state`	Unknown
`status`	Unknown
`tags`	Unknown
`website`	Unknown
`zip`	Unknown