Fivetran documentation

Search the docs

/

PowerReviews Enterprise

Explore the interactive ERD

Table & Field Reference

question_answer

Column	Type	Keys
`id`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`merchant_group_id`	Unknown	FK
`merchant_id`	Unknown	FK
`question_id`	Unknown	FK
`answer`	Unknown
`author_type`	Unknown
`client_publication_status`	Unknown
`created_date`	Unknown
`email`	Unknown
`helpful_votes`	Unknown
`is_expert`	Unknown
`is_verified_buyer`	Unknown
`locale`	Unknown
`location`	Unknown
`nickname`	Unknown
`not_helpful_votes`	Unknown
`originating_product_page_id`	Unknown
`product_page_id`	Unknown
`profile_id`	Unknown
`pwr_publication_status`	Unknown
`source`	Unknown
`type`	Unknown
`updated_date`	Unknown

question

Column	Type	Keys
`_fivetran_id`	String	PK
`merchant_id`	Unknown	FK
`product_page_id`	Unknown	FK
`product_page_id_variant`	Unknown	FK
`category`	Unknown
`client_publication_status`	Unknown
`created_date`	Unknown
`device_id`	Unknown
`email`	Unknown
`helpful_votes`	Unknown
`id`	Unknown
`locale`	Unknown
`location`	Unknown
`merchant_group_id`	Unknown
`nickname`	Unknown
`not_helpful_votes`	Unknown
`originating_product_page_id`	Unknown
`pwr_publication_status`	Unknown
`question`	Unknown
`question_type`	Unknown
`type`	Unknown
`updated_date`	Instant

specific_moderation_question_observation

Column	Type	Keys
`observation_id`	Unknown	PK
`id`	Unknown	PKFK
`code`	Unknown
`created_date`	Unknown
`merchant_group_id`	Unknown
`merchant_id`	Unknown
`updated_date`	Unknown

specific_moderation_review_observation

Column	Type	Keys
`observation_id`	Unknown	PK
`id`	Unknown	PKFK
`code`	Unknown
`created_date`	Unknown
`merchant_group_id`	Unknown
`merchant_id`	Unknown
`updated_date`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`add_to_cart_url`	Unknown
`asin`	Unknown
`brand`	Unknown
`category`	Unknown
`created_date`	Unknown
`description`	Unknown
`image_url`	Unknown
`in_stock`	Unknown
`manufacturer_id`	Unknown
`merchant_id`	Unknown
`name`	Unknown
`price`	Unknown
`product_page_id`	Unknown
`product_page_id_variant`	Unknown
`product_url`	Unknown
`upc`	Unknown
`updated_date`	Instant

orders

Column	Type	Keys
`id`	Unknown	PK
`merchant_id`	Unknown	FK
`product_page_id`	Unknown	FK
`product_page_id_variant`	Unknown	FK
`created_date`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`locale`	Unknown
`order_date`	Unknown
`updated_date`	Instant

review_badge

Column	Type	Keys
`badge`	Unknown	PK
`_fivetran_id`	Unknown	PKFK

review_media

Column	Type	Keys
`id`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`merchant_group_id`	Unknown	FK
`merchant_id`	Unknown	FK
`review_id`	Unknown	FK
`bytes`	Unknown
`caption`	Unknown
`client_publication_status`	Unknown
`created_date`	Unknown
`featured`	Unknown
`height`	Unknown
`helpful_votes`	Unknown
`locale`	Unknown
`location`	Unknown
`nickname`	Unknown
`not_helpful_votes`	Unknown
`originating_product_page_id`	Unknown
`product_page_id`	Unknown
`pwr_publication_status`	Unknown
`thumbnail_uri`	Unknown
`type`	Unknown
`updated_date`	Unknown
`uri`	Unknown
`width`	Unknown

review_merchant_response

Column	Type	Keys
`id`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`merchant_group_id`	Unknown	FK
`merchant_id`	Unknown	FK
`review_id`	Unknown	FK
`client_publication_status`	Unknown
`created_date`	Unknown
`email`	Unknown
`helpful_votes`	Unknown
`locale`	Unknown
`location`	Unknown
`nickname`	Unknown
`not_helpful_votes`	Unknown
`originating_product_page_id`	Unknown
`product_page_id`	Unknown
`profile_id`	Unknown
`pwr_publication_status`	Unknown
`response`	Unknown
`type`	Unknown
`updated_date`	Unknown

review_custom_question_name

Column	Type	Keys
`name`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`value`	Unknown

review

Column	Type	Keys
`_fivetran_id`	String	PK
`order_id`	Unknown	FK
`product_page_id`	Unknown	FK
`bottom_line`	Unknown
`campaign_id`	Unknown
`client_publication_status`	Unknown
`comments`	Unknown
`created_date`	Unknown
`device_id`	Unknown
`disclosure_code`	Unknown
`email`	Unknown
`headline`	Unknown
`helpful_score`	Unknown
`helpful_votes`	Unknown
`id`	Unknown
`locale`	Unknown
`location`	Unknown
`merchant_group_id`	Unknown
`merchant_id`	Unknown
`nickname`	Unknown
`not_helpful_votes`	Unknown
`originating_product_page_id`	Unknown
`product_page_id_variant`	Unknown
`promo_code`	Unknown
`pwr_publication_status`	Unknown
`rating`	Unknown
`review_source`	Unknown
`service_comments`	Unknown
`sub_ratings`	Unknown
`submission_id`	Unknown
`syndicated`	Unknown
`syndicated_date`	Unknown
`syndicating_client`	Unknown
`syndicating_client_logo`	Unknown
`syndicating_client_url`	Unknown
`tags_cons_choice`	Json
`tags_cons_selected`	Json
`tags_pros_choice`	Json
`tags_pros_selected`	Json
`type`	Unknown
`updated_date`	Instant
`user_id`	Unknown

moderation_observation

Column	Type	Keys
`_fivetran_id`	String	PK
`custom`	Unknown
`description`	Unknown
`merchant_group_id`	Unknown
`merchant_postable`	Unknown
`name`	Unknown
`observation`	Unknown