# PowerReviews Enterprise schema ERD

Table and field reference for the Fivetran PowerReviews Enterprise connector.

## Table & Field Reference

### question_answer

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

### review_media

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

## Relationships

- question_answer(question_id) → question(id)
- question_answer(merchant_group_id) → question(merchant_group_id)
- question_answer(merchant_id) → question(merchant_id)
- question_answer(_fivetran_id) → question(_fivetran_id)
- question(product_page_id) → product(product_page_id)
- question(product_page_id_variant) → product(product_page_id_variant)
- question(merchant_id) → product(merchant_id)
- specific_moderation_question_observation(id) → question(id)
- specific_moderation_review_observation(id) → review(id)
- orders(product_page_id) → product(product_page_id)
- orders(product_page_id_variant) → product(product_page_id_variant)
- orders(merchant_id) → product(merchant_id)
- review_badge(_fivetran_id) → review(_fivetran_id)
- review_media(review_id) → review(id)
- review_media(merchant_group_id) → review(merchant_group_id)
- review_media(merchant_id) → review(merchant_id)
- review_media(_fivetran_id) → review(_fivetran_id)
- review_merchant_response(review_id) → review(id)
- review_merchant_response(merchant_group_id) → review(merchant_group_id)
- review_merchant_response(merchant_id) → review(merchant_id)
- review_merchant_response(_fivetran_id) → review(_fivetran_id)
- review_custom_question_name(_fivetran_id) → review(_fivetran_id)
- review(order_id) → orders(id)
- review(product_page_id) → product(product_page_id)