# Bazaarvoice schema ERD

Table and field reference for the Fivetran Bazaarvoice connector.

## Table & Field Reference

### review_client_response

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_id | Unknown | PK, FK |
| date | Unknown |  |
| department | Unknown |  |
| name | Unknown |  |
| response | Unknown |  |
| source | Unknown |  |
| source_client_name | Unknown |  |
| type | Unknown |  |

### review

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| additional_fields | Json |  |
| additional_fields_order | Json |  |
| author_id | Unknown |  |
| badges | Json |  |
| badges_order | Json |  |
| campaign_id | Unknown |  |
| cid | Unknown |  |
| comment_ids | Json |  |
| cons | Unknown |  |
| content_locale | Unknown |  |
| context_data_values | Json |  |
| context_data_values_order | Json |  |
| helpfulness | Unknown |  |
| inappropriate_feedback_list | Json |  |
| is_featured | Unknown |  |
| is_ratings_only | Unknown |  |
| is_recommended | Unknown |  |
| is_syndicated | Unknown |  |
| last_moderated_time | Unknown |  |
| last_modification_time | Instant |  |
| moderation_status | Unknown |  |
| original_product_name | Unknown |  |
| photos | Json |  |
| product_recommendation_ids | Unknown |  |
| pros | Unknown |  |
| rating | Unknown |  |
| rating_range | Unknown |  |
| review_text | Unknown |  |
| secondary_ratings | Json |  |
| secondary_ratings_order | Json |  |
| source_client | Unknown |  |
| submission_id | Unknown |  |
| submission_time | Unknown |  |
| tag_dimensions | Json |  |
| tag_dimensions_order | Json |  |
| title | Unknown |  |
| total_client_response_count | Unknown |  |
| total_comment_count | Unknown |  |
| total_feedback_count | Unknown |  |
| total_inappropriate_feedback_count | Unknown |  |
| total_negative_feedback_count | Unknown |  |
| total_positive_feedback_count | Unknown |  |
| user_location | Unknown |  |
| user_nickname | Unknown |  |
| videos | Json |  |
| custom_** |  |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| active | Unknown |  |
| attributes | Json |  |
| attributes_order | Json |  |
| brand | Json |  |
| brand_external_id | Json |  |
| description | Unknown |  |
| disabled | Unknown |  |
| eans | Json |  |
| family_ids | Json |  |
| image_url | Unknown |  |
| isbns | Json |  |
| manufacturer_part_numbers | Json |  |
| model_numbers | Json |  |
| name | Unknown |  |
| product_page_url | Json |  |
| question_ids | Json |  |
| story_ids | Json |  |
| upcs | Json |  |

### product_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| attributes | Json |  |
| attributes_order | Json |  |
| category_page_url | Unknown |  |
| disabled | Unknown |  |
| image_url | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| product_ids | Json |  |
| question_ids | Json |  |
| story_ids | Json |  |

## Relationships

- review_client_response(review_id) → review(id)
- review(product_id) → product(id)
- product(category_id) → product_category(id)