Yotpo

Explore the interactive ERD

Table & Field Reference

product_gtin

Column	Type	Keys
`index`	Unknown	PK
`yotpo_product_id`	Unknown	PKFK
`declared_type`	Unknown
`value`	Unknown

product

Column	Type	Keys
`yotpo_product_id`	Unknown	PK
`brand`	Unknown
`compare_at_price`	Unknown
`created_at`	Unknown
`currency`	Unknown
`description`	Unknown
`external_id`	Unknown
`group_name`	Unknown
`handle`	Unknown
`image_url`	Unknown
`inventory_quantity`	Unknown
`is_discontinued`	Unknown
`is_valid_url`	Unknown
`mpn`	Unknown
`name`	Unknown
`price`	Unknown
`sku`	Unknown
`status`	Unknown
`updated_at`	Unknown
`url`	Unknown
`custom_`

product_variant_gtin

Column	Type	Keys
`index`	Unknown	PK
`product_variant_yotpo_id`	Unknown	PKFK
`yotpo_product_id`	Unknown	PKFK
`declared_type`	Unknown
`value`	Unknown

product_variant_option

Column	Type	Keys
`index`	Unknown	PK
`product_variant_yotpo_id`	Unknown	PKFK
`yotpo_product_id`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

product_variant

Column	Type	Keys
`yotpo_id`	Unknown	PK
`product_yotpo_product_id`	Unknown	PKFK
`compare_at_price`	Unknown
`created_at`	Unknown
`currency`	Unknown
`description`	Unknown
`external_id`	Unknown
`image_url`	Unknown
`inventory_quantity`	Unknown
`is_discontinued`	Unknown
`is_valid_url`	Unknown
`name`	Unknown
`price`	Unknown
`sku`	Unknown
`updated_at`	Unknown
`url`	Unknown

review

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	FK
`comment`	Unknown
`content`	Unknown
`created_at`	Unknown
`external_order_id`	Unknown
`external_product_id`	Unknown
`images_data`	Json
`incentive_type`	Unknown
`is_incentivized`	Unknown
`order_id`	Unknown
`published`	Unknown
`score`	Unknown
`source_review_id`	Unknown
`title`	Unknown
`user_display_name`	Unknown
`user_email`	Unknown
`user_id`	Unknown
`user_last_email_sent`	Unknown
`user_social_image`	Unknown
`user_type`	Unknown
`verified_buyer`	Unknown
`votes_down`	Unknown
`votes_up`	Unknown
`custom_`

customer_list

Column	Type	Keys
`id`	Unknown	PK
`customer_fivetran_id`	Unknown	PKFK
`since`	Unknown

customer_ugc_top_topic

Column	Type	Keys
`index`	Unknown	PK
`customer_fivetran_id`	Unknown	PKFK
`topic`	Unknown

customer_sms_response_message

Column	Type	Keys
`id`	Unknown	PK
`customer_fivetran_id`	Unknown	PKFK
`flow_id`	Unknown
`keyword`	Unknown
`timestamps`	Unknown

customer

Column	Type	Keys
`_fivetran_id`	String	PK
`accepts_email_marketing`	Unknown
`accepts_sms_marketing`	Unknown
`account_created_at`	Unknown
`account_status`	Unknown
`account_updated_at`	LocalDateTime
`address_1`	Unknown
`address_2`	Unknown
`address_city`	Unknown
`address_company`	Unknown
`address_country_code`	Unknown
`address_phone_number`	Unknown
`address_province_code`	Unknown
`address_state`	Unknown
`address_zip`	Unknown
`default_currency`	Unknown
`default_language`	Unknown
`email`	Unknown
`email_last_converted`	Unknown
`email_last_delivered`	Unknown
`email_last_engaged`	Unknown
`email_last_opened`	Unknown
`email_last_promotional_sent`	Unknown
`email_last_sent`	Unknown
`email_last_spam`	Unknown
`email_marketing_consent`	Unknown
`email_marketing_suppression_reason`	Unknown
`email_marketing_suppression_timestamp`	Unknown
`email_marketing_timestamp`	Unknown
`external_id`	Unknown
`first_name`	Unknown
`gender`	Unknown
`last_name`	Unknown
`loyalty_credit_balance_amount`	Unknown
`loyalty_credit_balance_customer_currency`	Unknown
`loyalty_has_store_account`	Unknown
`loyalty_is_opt_in`	Unknown
`loyalty_is_referred_by_other_customer`	Unknown
`loyalty_last_seen_at`	Unknown
`loyalty_opt_in_date`	Unknown
`loyalty_opt_out_date`	Unknown
`loyalty_points_balance`	Unknown
`loyalty_points_earned`	Unknown
`loyalty_points_expire_date`	Unknown
`loyalty_referrals_made_and_clicked`	Unknown
`loyalty_referred_by_customer`	Unknown
`loyalty_successful_referral`	Unknown
`loyalty_total_points_redeemed`	Unknown
`loyalty_total_redemption`	Unknown
`loyalty_vip_entry_date`	Unknown
`loyalty_vip_expiration_date`	Unknown
`loyalty_vip_tier_name`	Unknown
`phone_number`	Unknown
`sms_last_converted`	Unknown
`sms_last_engaged`	Unknown
`sms_last_sent`	Unknown
`sms_marketing_consent`	Unknown
`sms_marketing_timestamp`	Unknown
`tags`	Unknown
`ugc_avg_product_rating`	Unknown
`ugc_avg_site_rating`	Unknown
`ugc_last_review_date`	Unknown
`ugc_last_sentiment`	Unknown
`ugc_last_star_rating`	Unknown
`ugc_sentiment_avg_product`	Unknown
`ugc_sentiment_avg_site`	Unknown
`ugc_total_avg_rating`	Unknown
`ugc_total_avg_sentiment`	Unknown
`ugc_total_reviews`	Unknown
`custom_`

customer_campaign

Column	Type	Keys
`id`	Unknown	PK
`type`	Unknown	PK
`customer_fivetran_id`	Unknown	PKFK
`clicked`	Unknown
`converted`	Unknown

customer_subscription

Column	Type	Keys
`index`	Unknown	PK
`type`	Unknown	PK
`customer_fivetran_id`	Unknown	PKFK
`external_product_id`	Unknown
`external_variant_id`	Unknown

customer_flow

Column	Type	Keys
`id`	Unknown	PK
`type`	Unknown	PK
`customer_fivetran_id`	Unknown	PKFK
`clicked`	Unknown
`converted`	Unknown
`opened`	Unknown