# Friendbuy schema ERD

Table and field reference for the Fivetran Friendbuy connector.

## Table & Field Reference

### signup

| Column | Type | Keys |
| --- | --- | --- |
| created_on | Unknown | PK |
| customer_id | Unknown | PK |
| campaign_id | Unknown | FK |
| referral_code | Unknown | FK |
| advocate_customer_id | Unknown |  |
| advocate_email | Unknown |  |
| advocate_name | Unknown |  |
| campaign_name | Unknown |  |
| channel | Unknown |  |
| email | Unknown |  |
| ip_address | Unknown |  |
| name | Unknown |  |
| new_customer | Unknown |  |
| user_agent | Unknown |  |

### distributed_friend_incentive

| Column | Type | Keys |
| --- | --- | --- |
| friend_email | Unknown | PK |
| campaign_id | Unknown | FK |
| referral_code | Unknown | FK |
| advocate_name | Unknown |  |
| campaign_name | Unknown |  |
| coupon_code | Unknown |  |
| friend_name | Unknown |  |
| incentive_amount | Unknown |  |
| incentive_type | Unknown |  |
| trigger | Unknown |  |

### distributed_advocate_reward

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| referral_code | Unknown | FK |
| advocate_customer_id | Unknown |  |
| advocate_name | Unknown |  |
| friend_customer_id | Unknown |  |
| reward_amount | Unknown |  |
| reward_type | Unknown |  |
| trigger | Unknown |  |

### widget_view

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK |
| created_on | Unknown | PK |
| customer_id | Unknown | FK |
| campaign_name | Unknown |  |
| email | Unknown |  |
| ip_address | Unknown |  |
| user_agent | Unknown |  |
| widget_name | Unknown |  |
| widget_type | Unknown |  |

### click

| Column | Type | Keys |
| --- | --- | --- |
| destination_url | Unknown | PK |
| campaign_id | Unknown | FK |
| referral_code | Unknown | FK |
| advocate_name | Unknown |  |

### share

| Column | Type | Keys |
| --- | --- | --- |
| created_on | Unknown | PK |
| referral_code | Unknown | PK |
| campaign_id | Unknown | FK |
| advocate_email | Unknown |  |
| channel | Unknown |  |

### email_capture

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| campaign_name | Unknown |  |
| created_on | Unknown |  |
| email | Unknown |  |
| email_capture_type | Unknown |  |
| ip_address | Unknown |  |
| name | Unknown |  |
| newsletter_opt_in | Unknown |  |
| widget_name | Unknown |  |

### ledger_head

| Column | Type | Keys |
| --- | --- | --- |
| currency | Unknown | PK |
| customer_id | Unknown | PK, FK |
| current_balance | Unknown |  |

### purchase_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| name | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |

### purchase

| Column | Type | Keys |
| --- | --- | --- |
| order_id | Unknown | PK |
| campaign_id | Unknown | FK |
| referral_code | Unknown | FK |
| advocate_name | Unknown |  |
| amount | Unknown |  |
| coupon_code | Unknown |  |
| customer_id | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| new_customer | Unknown |  |

## Relationships

- signup(campaign_id) → widget_view(campaign_id)
- signup(referral_code) → share(referral_code)
- distributed_friend_incentive(campaign_id) → widget_view(campaign_id)
- distributed_friend_incentive(referral_code) → share(referral_code)
- distributed_advocate_reward(campaign_id) → widget_view(campaign_id)
- distributed_advocate_reward(referral_code) → share(referral_code)
- widget_view(customer_id) → signup(customer_id)
- click(campaign_id) → widget_view(campaign_id)
- click(referral_code) → share(referral_code)
- share(campaign_id) → widget_view(campaign_id)
- email_capture(campaign_id) → widget_view(campaign_id)
- ledger_head(customer_id) → signup(customer_id)
- purchase_product(purchase_order_id) → purchase(order_id)
- purchase(campaign_id) → widget_view(campaign_id)
- purchase(referral_code) → share(referral_code)