# Trustpilot schema ERD

Table and field reference for the Fivetran Trustpilot connector.

## Table & Field Reference

### business_unit_category

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| business_unit_id | Unknown | PK, FK |
| display_name | String |  |
| is_primary | Boolean |  |
| name | String |  |
| predicted_top_category | Boolean |  |
| ranking_cardinality | Long |  |
| ranking_position | Long |  |
| relevance | String |  |
| source | String |  |

### resource_country

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| locale | String | FK |
| country | String |  |
| english_name | String |  |
| translated_name | String |  |

### private_product_review_attachment_processed_file

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| private_product_review_attachment_index | Unknown | PK, FK |
| private_product_review_id | String | PK, FK |
| dimension | Unknown |  |
| mime_type | Unknown |  |
| url | Unknown |  |

### private_product_review_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| private_product_review_id | String | PK, FK |
| id | Unknown |  |
| state | Unknown |  |

### private_product_review_attribute_rating

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| private_product_review_id | String | PK, FK |
| attribute_id | String |  |
| attribute_name | String |  |
| rating | Double |  |

### private_product_review

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| business_unit_id | String | FK |
| locale | Unknown | FK |
| product_id | String | FK |
| consumer_email | String |  |
| consumer_id | String |  |
| content | Unknown |  |
| conversation_id | String |  |
| created_at | Unknown |  |
| has_moderation_history | Boolean |  |
| languages | Unknown |  |
| product_url | String |  |
| redirect_uri | String |  |
| reference_id | String |  |
| stars | Double |  |
| state | String |  |
| updated_at | Unknown |  |

### private_business_unit_product_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| private_business_unit_product_id | String | PK, FK |
| id | Unknown |  |
| name | Unknown |  |

### private_business_unit_product_processed_image

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| private_business_unit_product_id | String | PK, FK |
| type | Unknown |  |
| url | Unknown |  |

### private_business_unit_product

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| business_unit_id | String | FK |
| age_group | String |  |
| brand | String |  |
| color | String |  |
| currency | String |  |
| description | Unknown |  |
| gender | String |  |
| google_merchant_center_product_id | String |  |
| group_id | String |  |
| gtin | String |  |
| image_link | String |  |
| link | String |  |
| material | String |  |
| mpn | String |  |
| pattern | String |  |
| price | String |  |
| product_category_id | String |  |
| product_category_name | String |  |
| size | String |  |
| sku | String |  |
| title | String |  |

### business_unit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| country | String |  |
| display_name | String |  |
| identifying_name | String |  |
| referring | Json |  |

### resource_locale

| Column | Type | Keys |
| --- | --- | --- |
| locale | String | PK |
| country_id | Long | FK |
| about_trustpilot_url | String |  |
| blog | Unknown |  |
| business_signup_url | String |  |
| business_web_app | String |  |
| commercial_url | String |  |
| consumer_web_app | String |  |
| help_center_url | String |  |
| investors_url | String |  |
| is_default_for_language | Boolean |  |
| is_supported_in_business_web_app | Boolean |  |
| jobs_url | String |  |
| legal_url | String |  |
| locale_language | String |  |
| native_name | String |  |
| press_url | String |  |
| region | String |  |
| status_page_url | String |  |
| support_url | String |  |
| tld | String |  |
| translated_name | String |  |

### ds_business_unit_detail_category

| Column | Type | Keys |
| --- | --- | --- |
| category_id | String | PK, FK |
| ds_business_unit_detail_id | String | PK, FK |
| ds_business_unit_id | String | PK, FK |
| is_primary | Boolean |  |

### ds_business_unit_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ds_business_unit_id | String | PK, FK |
| address_city | String |  |
| address_country | String |  |
| address_country_code | String |  |
| address_postcode | String |  |
| address_state | String |  |
| address_street | String |  |
| contact_email | String |  |
| contact_phone_number | String |  |
| description_header | String |  |
| description_text | String |  |
| display_name | String |  |
| five_star_reviews | Long |  |
| four_star_reviews | Long |  |
| is_claimed | Boolean |  |
| is_subscriber | Boolean |  |
| name_identifying | String |  |
| name_referring | Json |  |
| one_star_reviews | Long |  |
| score_stars | Double |  |
| social_media | Json |  |
| status | String |  |
| three_star_reviews | Long |  |
| total_reviews | Long |  |
| trust_score | Double |  |
| two_star_reviews | Long |  |
| used_for_trust_score_calculation | Long |  |
| website_url | String |  |

### private_product_review_summary

| Column | Type | Keys |
| --- | --- | --- |
| sku | String | PK |
| business_unit_id | Unknown | PK, FK |
| number_of_reviews | Long |  |
| stars_average | Double |  |

### ds_business_unit

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| address_country_code | String |  |
| name_display | String |  |
| name_identifying | String |  |

### consumer_profile

| Column | Type | Keys |
| --- | --- | --- |
| business_unit_all_review_consumer_id | String | PK |
| id | String | PK |
| locale | String | FK |
| about | String |  |
| birth_year | Long |  |
| city | String |  |
| country | String |  |
| created_at | Instant |  |
| display_name | String |  |
| gender | String |  |
| has_image | Boolean |  |
| profile_image_** |  |  |

### ds_business_service_unit_review

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ds_business_unit_id | String | PK, FK |
| created_at | Instant |  |
| experienced_at | Instant |  |
| is_verified | Boolean |  |
| languages | String |  |
| reviewed_location_name | String |  |
| source | String |  |
| stars | Long |  |
| text | String |  |
| title | String |  |
| updated_at | Instant |  |

### invitation_template

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| business_unit_id | Unknown | PK, FK |
| locale | String | FK |
| is_default_template | Boolean |  |
| name | String |  |
| review_language | String |  |
| type | String |  |

### category_business_unit

| Column | Type | Keys |
| --- | --- | --- |
| business_unit_id | String | PK, FK |
| category_id | String | PK, FK |
| location_address | String |  |
| location_city | String |  |
| location_zip_code | String |  |
| logo_url | String |  |
| number_of_reviews | Long |  |
| rank | Unknown |  |
| trust_score | Double |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| display_name | String |  |
| name | String |  |

### business_unit_all_review

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| business_unit_id | Unknown | PK, FK |
| company_reply_created_at | Unknown |  |
| company_reply_text | String |  |
| company_reply_updated_at | Unknown |  |
| consumer_display_location | String |  |
| consumer_display_name | String |  |
| consumer_id | String |  |
| created_at | Instant |  |
| experienced_at | Instant |  |
| is_verified | Boolean |  |
| location_id | String |  |
| location_name | String |  |
| review_language | String |  |
| stars | Long |  |
| text | String |  |
| title | String |  |
| updated_at | Instant |  |

## Relationships

- business_unit_category(business_unit_id) → business_unit(id)
- resource_country(locale) → resource_locale(locale)
- private_product_review_attachment_processed_file(private_product_review_id) → private_product_review_attachment(private_product_review_id)
- private_product_review_attachment_processed_file(private_product_review_attachment_index) → private_product_review_attachment(index)
- private_product_review_attachment(private_product_review_id) → private_product_review(id)
- private_product_review_attribute_rating(private_product_review_id) → private_product_review(id)
- private_product_review(product_id) → private_business_unit_product(id)
- private_product_review(business_unit_id) → business_unit(id)
- private_product_review(locale) → resource_locale(locale)
- private_business_unit_product_attribute(private_business_unit_product_id) → private_business_unit_product(id)
- private_business_unit_product_processed_image(private_business_unit_product_id) → private_business_unit_product(id)
- private_business_unit_product(business_unit_id) → business_unit(id)
- resource_locale(country_id) → resource_country(id)
- ds_business_unit_detail_category(category_id) → category(id)
- ds_business_unit_detail_category(ds_business_unit_id) → ds_business_unit_detail(ds_business_unit_id)
- ds_business_unit_detail_category(ds_business_unit_detail_id) → ds_business_unit_detail(id)
- ds_business_unit_detail(ds_business_unit_id) → ds_business_unit(id)
- private_product_review_summary(business_unit_id) → business_unit(id)
- consumer_profile(locale) → resource_locale(locale)
- ds_business_service_unit_review(ds_business_unit_id) → ds_business_unit(id)
- invitation_template(locale) → resource_locale(locale)
- invitation_template(business_unit_id) → business_unit(id)
- category_business_unit(business_unit_id) → business_unit(id)
- category_business_unit(category_id) → category(id)
- business_unit_all_review(business_unit_id) → business_unit(id)