Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
yotpo_product_id 🔑
brand
compare_at_price
created_at
currency
description
external_created_at
external_id
external_updated_at
group_name
handle
image_url
inventory_quantity
is_discontinued
is_valid_url
is_valid_url_format
mpn
name
price
sku
status
store_id
updated_at
url
custom_property*
PRODUCT ⇱
yotpo_product_id 🔑 ➤ PRODUCT
yotpo_order_id ➤ ORDERS
coupon_code
external_product_id
quantity
subtotal_price
total_price
custom_property*
ORDER_LINE_ITEM ⇱
_fivetran_id 🔑
yotpo_product_id ➤ PRODUCT
declared_type
value
PRODUCT_GTIN ⇱
_fivetran_id 🔑
yotpo_order_id ➤ ORDER_FULFILLMENT
yotpo_product_id
external_product_id
quantity
ORDER_FULFILLED_ITEM ⇱
external_id 🔑
accepts_email_marketing
accepts_sms_marketing
account_created_at
account_status
address_address1
address_address2
address_city
address_company
address_country_code
address_phone_number
address_province_code
address_state
address_zip
default_currency
default_language
first_name
gender
last_name
phone_number
tags
CUSTOMER ⇱
yotpo_id 🔑
yotpo_product_id ➤ PRODUCT
compare_at_price
created_at
currency
description
external_id
image_url
inventory_quantity
is_discontinued
is_valid_url
name
price
sku
updated_at
url
PRODUCT_VARIANT ⇱
_fivetran_id 🔑
yotpo_id ➤ PRODUCT_VARIANT
declared_type
value
PRODUCT_VARIANT_GTIN ⇱
_fivetran_id 🔑
yotpo_id ➤ PRODUCT_VARIANT
name
value
OPTION ⇱
yotpo_collection_id 🔑
created_at
external_id
name
updated_at
COLLECTION ⇱
yotpo_collection_id 🔑 ➤ COLLECTION
yotpo_product_id 🔑 ➤ PRODUCT
PRODUCT_COLLECTION ⇱
_fivetran_id 🔑
yotpo_product_id ➤ PRODUCT_COLLECTION
declared_type
value
PRODUCT_COLLECTION_GTIN ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
yotpo_order_id 🔑
customer_external_id ➤ CUSTOMER
billing_address_address1
billing_address_address2
billing_address_city
billing_address_company
billing_address_country_code
billing_address_phone_number
billing_address_province_code
billing_address_state
billing_address_zip
cancellation_date
checkout_token
created_at
currency
customer_custom_properties
external_id
landing_site_url
order_date
order_name
payment_method
payment_status
shipping_address_address1
shipping_address_address2
shipping_address_city
shipping_address_company
shipping_address_country_code
shipping_address_phone_number
shipping_address_province_code
shipping_address_state
shipping_address_zip
source
store_id
subtotal_price
total_price
updated_at
custom_property*
ORDERS ⇱
yotpo_order_id🔑 ➤ ORDERS
yotpo_id 🔑
created_at
external_id
fulfillment_date
shipment_info_shipment_status
shipment_info_tracking_company
shipment_info_tracking_url
shipment_info_tracking_number
status
updated_at
ORDER_FULFILLMENT ⇱
REVIEW_METADATA_FILTER_VALUE ⇱
_fivetran_id 🔑
product_id ➤ REVIEW_ID_PRODUCT
orders
UNSUBSCRIBER ⇱
id 🔑
email_type_id
unsubscirbed_by_name
user_email
COUPON_STAT ⇱
_fivetran_id 🔑
map_review
map_review_share
REVIEW_DETAIL_PRODUCT_IMAGE ⇱
id 🔑
product_id 🔑 ➤ REVIEW_DETAIL_PRODUCT
review_id 🔑 ➤ REVIEW_DETAIL
big_image_url
image_url
REVIEW_DETAIL_LOCATION ⇱
_fivetran_id 🔑
review_id ➤ REVIEW_DETAIL
location_id
REVIEW_DETAIL_PRODUCT ⇱
product_id 🔑
review_id ➤ REVIEW_DETAIL
product_facebook_testemonials_page_product_url
product_name
product_url
product_slug
social_network_links_facebook
social_network_links_google_oauth_2
social_network_links_linkedin
social_network_links_twitter
REVIEW_DETAIL_USER_BADGE ⇱
id 🔑
review_id 🔑 ➤ REVIEW_DETAIL
description
image_100
image_300
name
REVIEW_DETAIL_PRODUCT_APP ⇱
id 🔑
review_id 🔑 ➤ REVIEW_DETAIL
product_id ➤ PRODUCT
domain_key
REVIEW_DETAIL ⇱
id 🔑 ➤ REVIEW
account_domain
account_id
account_map_created_at
account_map_id
account_map_image_content_type
account_map_image_file_name
account_map_image_file_size
account_map_image_fingerprint
account_map_image_height
account_map_image_updated_at
account_map_image_width
account_map_imageable_id
account_map_imageable_type
account_map_kind
account_map_published
account_map_updated_at
account_map_url
account_map_user_id
account_map_yotpo_resource_id
created_at
deleted
facebook_pushed
news
social_pushed
twitter_pushed
user_display_name
user_id
user_is_social_connected
user_score
user_slug
user_type
user_vote
users
verified_buyer
COUPON ⇱
code 🔑
PRODUCT_BOTTOM_LINE ⇱
domain_key 🔑
product_score
total_review
REVIEW ⇱
id 🔑
archived
content
created_at
deleted
escalated
is_incentivized
name
reviewer_type
score
sentiment
sku
title
updated_at
user_reference
votes_down
votes_up
REVIEW_METADATA ⇱
_fivetran_id 🔑
review_id ➤ REVIEW
payload_customer_address
payload_customer_country
payload_customer_email
payload_customer_phone_number
payload_customer_state
Payload_customer_name
payload_order_date
payload_order_delivery_type
payload_order_external_order_id
payload_product_description
payload_product_name
payload_product_size
payload_product_url
specs_external_sku
SITE_REVIEW_BOTTOM_LINE ⇱
_fivetran_id 🔑
average_score
total_review
_fivetran_id 🔑
order_id ➤ ORDER
product_id ➤ PRODUCT
email_address
order_timestamp
sku
email_type
reminder_num
trr_bundle_id
trr_bundle_subject
review_type
coupon_code
email_sent_timestamp
opened_timestamp
clicked_through_timestamp
content_creation_timestamp
platform
invalid_address_timestamp
failed_timestamp
unsubcribed_timestamp
marked_spam_timestamp
arrived_early_timestamp
EMAIL_ANALYTICS_RAW_DATA ⇱