# Yotpo schema ERD

Table and field reference for the Fivetran Yotpo connector.

## Table & Field Reference

### product_gtin

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| yotpo_product_id | Unknown | PK, FK |
| 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 | PK, FK |
| yotpo_product_id | Unknown | PK, FK |
| declared_type | Unknown |  |
| value | Unknown |  |

### product_variant_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_variant_yotpo_id | Unknown | PK, FK |
| yotpo_product_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### product_variant

| Column | Type | Keys |
| --- | --- | --- |
| yotpo_id | Unknown | PK |
| product_yotpo_product_id | Unknown | PK, FK |
| 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 | PK, FK |
| since | Unknown |  |

### customer_ugc_top_topic

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_fivetran_id | Unknown | PK, FK |
| topic | Unknown |  |

### customer_sms_response_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_fivetran_id | Unknown | PK, FK |
| 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 | PK, FK |
| clicked | Unknown |  |
| converted | Unknown |  |

### customer_subscription

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| type | Unknown | PK |
| customer_fivetran_id | Unknown | PK, FK |
| external_product_id | Unknown |  |
| external_variant_id | Unknown |  |

### customer_flow

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type | Unknown | PK |
| customer_fivetran_id | Unknown | PK, FK |
| clicked | Unknown |  |
| converted | Unknown |  |
| opened | Unknown |  |

## Relationships

- product_gtin(yotpo_product_id) → product(yotpo_product_id)
- product_variant_gtin(product_variant_yotpo_id) → product_variant(yotpo_id)
- product_variant_gtin(yotpo_product_id) → product_variant(yotpo_id)
- product_variant_option(product_variant_yotpo_id) → product_variant(yotpo_id)
- product_variant_option(yotpo_product_id) → product_variant(yotpo_id)
- product_variant(product_yotpo_product_id) → product(yotpo_product_id)
- review(product_id) → product(yotpo_product_id)
- customer_list(customer_fivetran_id) → customer(_fivetran_id)
- customer_ugc_top_topic(customer_fivetran_id) → customer(_fivetran_id)
- customer_sms_response_message(customer_fivetran_id) → customer(_fivetran_id)
- customer_campaign(customer_fivetran_id) → customer(_fivetran_id)
- customer_subscription(customer_fivetran_id) → customer(_fivetran_id)
- customer_flow(customer_fivetran_id) → customer(_fivetran_id)