Fivetran documentation

Search the docs

/

Trustpilot

Explore the interactive ERD

Table & Field Reference

business_unit_category

Column	Type	Keys
`id`	String	PK
`business_unit_id`	Unknown	PKFK
`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	PKFK
`private_product_review_id`	String	PKFK
`dimension`	Unknown
`mime_type`	Unknown
`url`	Unknown

private_product_review_attachment

Column	Type	Keys
`index`	Unknown	PK
`private_product_review_id`	String	PKFK
`id`	Unknown
`state`	Unknown

private_product_review_attribute_rating

Column	Type	Keys
`index`	Unknown	PK
`private_product_review_id`	String	PKFK
`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	PKFK
`id`	Unknown
`name`	Unknown

private_business_unit_product_processed_image

Column	Type	Keys
`index`	Unknown	PK
`private_business_unit_product_id`	String	PKFK
`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	PKFK
`ds_business_unit_detail_id`	String	PKFK
`ds_business_unit_id`	String	PKFK
`is_primary`	Boolean

ds_business_unit_detail

Column	Type	Keys
`id`	String	PK
`ds_business_unit_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`locale`	String	FK
`is_default_template`	Boolean
`name`	String
`review_language`	String
`type`	String

category_business_unit

Column	Type	Keys
`business_unit_id`	String	PKFK
`category_id`	String	PKFK
`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	PKFK
`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