Fivetran documentation

Search the docs

/

Friendbuy

Explore the interactive ERD

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	PKFK
`current_balance`	Unknown

purchase_product

Column	Type	Keys
`index`	Unknown	PK
`purchase_order_id`	Unknown	PKFK
`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