# Okendo schema ERD

Table and field reference for the Fivetran Okendo connector.

## Table & Field Reference

### review_reviewer_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_id | Unknown | PK, FK |
| title | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### review_attribute_with_rating

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_id | Unknown | PK, FK |
| max_label | Unknown |  |
| mid_label | Unknown |  |
| min_label | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### review_product_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_id | Unknown | PK, FK |
| title | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### review_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_id | Unknown | PK, FK |
| tags | Unknown |  |

### review

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| body | Unknown |  |
| contains_profanity | Unknown |  |
| customer_id | Unknown |  |
| date_created | Instant |  |
| helpful_count | Unknown |  |
| is_recommended | Unknown |  |
| order_id | Unknown |  |
| order_number | Unknown |  |
| product_id | Unknown |  |
| product_name | Unknown |  |
| rating | Unknown |  |
| reply_body | Unknown |  |
| reply_date_created | Unknown |  |
| reply_is_private | Unknown |  |
| reply_raw_body | Unknown |  |
| reviewer_avatar_url | Unknown |  |
| reviewer_display_name | Unknown |  |
| reviewer_email | Unknown |  |
| reviewer_is_verified | Unknown |  |
| reviewer_location_country_code | Unknown |  |
| reviewer_location_country_name | Unknown |  |
| reviewer_location_zone_code | Unknown |  |
| reviewer_name | Unknown |  |
| reviewer_social_connection | Unknown |  |
| reviewer_verified_status | Unknown |  |
| reward_description | Unknown |  |
| reward_integration | Unknown |  |
| reward_is_coupon_upgrade | Unknown |  |
| reward_type | Unknown |  |
| reward_value | Unknown |  |
| sentiment | Unknown |  |
| status | Unknown |  |
| subscriber_id | Unknown |  |
| title | Unknown |  |
| unhelpful_count | Unknown |  |
| variant_id | Unknown |  |
| variant_name | Unknown |  |

### review_media

| Column | Type | Keys |
| --- | --- | --- |
| stream_id | Unknown | PK |
| review_id | Unknown | PK, FK |
| dynamic_key | Unknown |  |
| full_size_url | Unknown |  |
| is_hidden | Unknown |  |
| large_portrait_thumbnail_url | Unknown |  |
| large_url | Unknown |  |
| thumbnail_url | Unknown |  |
| type | Unknown |  |

## Relationships

- review_reviewer_attribute(review_id) → review(id)
- review_attribute_with_rating(review_id) → review(id)
- review_product_attribute(review_id) → review(id)
- review_tag(review_id) → review(id)
- review_media(review_id) → review(id)