# ShareASale schema ERD

Table and field reference for the Fivetran ShareASale connector.

## 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 |  |

## Relationships

- transaction(user_id) → affiliate_list(user_id)