# Uservoice schema ERD

Table and field reference for the Fivetran Uservoice connector.

## Table & Field Reference

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| suggestion_id | Unknown | FK |
| body | Unknown |  |
| created_at | Unknown |  |
| updated_at | Unknown |  |

### request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| suggestion_id | Unknown | FK |
| supporter_id | Unknown | FK |
| user_id | Unknown | FK |
| body | Unknown |  |
| channel | Unknown |  |
| created_at | Unknown |  |
| prompt | Unknown |  |
| referrer | Unknown |  |
| severity | Unknown |  |
| source_guid | Unknown |  |
| source_title | Unknown |  |
| source_type | Unknown |  |
| source_url | Unknown |  |
| updated_at | Unknown |  |

### feature_suggestion

| Column | Type | Keys |
| --- | --- | --- |
| feature_id | Unknown | PK, FK |
| suggestion_id | Unknown | PK, FK |

### suggestion_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Unknown | PK, FK |
| suggestion_id | Unknown | PK, FK |

### suggestion_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| created_by_id | Unknown | FK |
| forum_id | Unknown | FK |
| parent_suggestion_id | Unknown | FK |
| status_id | Unknown | FK |
| approved_at | Unknown |  |
| average_engagement | Unknown |  |
| body | Unknown |  |
| channel | Unknown |  |
| closed_at | Unknown |  |
| created_at | Unknown |  |
| engagement_trend | Unknown |  |
| first_support_at | Unknown |  |
| inappropriate_flags_count | Unknown |  |
| is_blocker | Unknown |  |
| recent_engagement | Unknown |  |
| state | Unknown |  |
| title | Unknown |  |
| unmergeable | Unknown |  |
| updated_at | Instant |  |

### feature_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| created_at | Unknown |  |
| is_default | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### nps_rating

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| body | Unknown |  |
| created_at | Unknown |  |
| prompt | Unknown |  |
| rating | Unknown |  |
| updated_at | Unknown |  |

### feature_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| feature_status_id | Unknown | FK |
| product_area_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |
| custom_** |  |  |

### custom_field_enum_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| is_default | Unknown |  |
| label | Unknown |  |
| numeric_value | Unknown |  |

### label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| created_at | Unknown |  |
| full_name | Unknown |  |
| level | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment_id | Unknown | FK |
| note_id | Unknown | FK |
| request_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| is_email_reply | Unknown |  |
| stripped_html | Unknown |  |
| stripped_text | Unknown |  |
| thread_updated_at | Unknown |  |

### product_area

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### supporter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| suggestion_id | Unknown | FK |
| user_id | Unknown | FK |
| channel | Unknown |  |
| created_at | Unknown |  |
| how | Unknown |  |
| is_subscribed | Unknown |  |
| updated_at | Unknown |  |

### forum

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_required | Unknown |  |
| classic_voting | Unknown |  |
| created_at | Unknown |  |
| example | Unknown |  |
| is_private | Unknown |  |
| is_public | Unknown |  |
| name | Unknown |  |
| prompt | Unknown |  |
| updated_at | Unknown |  |
| welcome_message | Unknown |  |

### external_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| external_created_at | Unknown |  |
| external_id | Unknown |  |
| is_blocking | Unknown |  |
| last_active_at | Unknown |  |
| ltv_cents | Unknown |  |
| mrr_cents | Unknown |  |
| name | Unknown |  |
| plan | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### external_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| external_account_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| email | Unknown |  |
| external_created_at | Unknown |  |
| external_id | Unknown |  |
| ip | Unknown |  |
| last_seen_at | Unknown |  |
| name | Unknown |  |
| seen_days | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| suggestion_id | Unknown | FK |
| body | Unknown |  |
| channel | Unknown |  |
| created_at | Unknown |  |
| inappropriate_flags_count | Unknown |  |
| is_admin_comment | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| forum_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### supporter_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| suggestion_id | Unknown | FK |
| body | Unknown |  |
| created_at | Unknown |  |
| mail_clicked_count | Unknown |  |
| mail_opened_count | Unknown |  |
| mail_sent_count | Unknown |  |
| notification_email_address | Unknown |  |
| updated_at | Unknown |  |

### status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_comments | Unknown |  |
| created_at | Unknown |  |
| is_open | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### internal_status_update_external_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| internal_status_update_users_id | Unknown | PK, FK |
| external_user_id | Unknown | FK |

### internal_status_update_team

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| internal_status_update_users_id | Unknown | PK, FK |
| team_id | Unknown | FK |

### internal_status_update_users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| internal_status_id | Unknown | FK |
| new_internal_status_id | Unknown | FK |
| old_internal_status_id | Unknown | FK |
| suggestion_id | Unknown | FK |
| avatar_url | Unknown |  |
| current_nps_rating | Unknown |  |
| expected_send_count | Unknown |  |
| html_text | Unknown |  |
| importance_score | Unknown |  |
| is_subscribed | Unknown |  |
| is_validation_admin | Unknown |  |
| last_ip | Unknown |  |
| mail_clicked_count | Unknown |  |
| mail_opened_count | Unknown |  |
| mail_sent_count | Unknown |  |
| permissions_billing | Unknown |  |
| permissions_features | Unknown |  |
| permissions_id | Unknown |  |
| permissions_knowledgebase | Unknown |  |
| permissions_license_type | Unknown |  |
| permissions_settings | Unknown |  |
| permissions_state | Unknown |  |
| permissions_suggestions | Unknown |  |
| permissions_tickets | Unknown |  |
| previous_nps_rating | Unknown |  |
| satisfaction_score | Unknown |  |
| suggestion_votes | Unknown |  |
| supported_suggestions_count | Unknown |  |
| supporter | Unknown |  |
| teams_notified | Unknown |  |
| text | Unknown |  |
| thumbs_down_count | Unknown |  |
| thumbs_up_count | Unknown |  |
| traits_account_created_at | Unknown |  |
| traits_account_id | Unknown |  |
| traits_account_internal_id | Unknown |  |
| traits_account_ltv | Unknown |  |
| traits_account_monthly_rate | Unknown |  |
| traits_account_name | Unknown |  |
| traits_account_plan | Unknown |  |
| traits_browser_name | Unknown |  |
| traits_created_at | Unknown |  |
| traits_email | Unknown |  |
| traits_id | Unknown |  |
| traits_ip | Unknown |  |
| traits_location_city | Unknown |  |
| traits_location_country | Unknown |  |
| traits_location_region | Unknown |  |
| traits_name | Unknown |  |
| traits_os_name | Unknown |  |
| traits_type | Unknown |  |

### internal_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| is_default | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| updated_at | Instant |  |

### user_team

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK |
| user_id | Unknown | PK, FK |
| id | Unknown | FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allowed_state | Unknown |  |
| city | Unknown |  |
| comment_notifications | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| email_address | Unknown |  |
| email_confirmed | Unknown |  |
| guid | Unknown |  |
| is_admin | Unknown |  |
| is_owner | Unknown |  |
| job_title | Unknown |  |
| last_login | Unknown |  |
| name | Unknown |  |
| region | Unknown |  |
| state | Unknown |  |
| status_notifications | Unknown |  |
| support_created_at | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- note(created_by_id) → users(id)
- note(suggestion_id) → suggestion_history(id)
- request(user_id) → users(id)
- request(supporter_id) → supporter(id)
- request(suggestion_id) → suggestion_history(id)
- feature_suggestion(feature_id) → feature_history(id)
- feature_suggestion(suggestion_id) → suggestion_history(id)
- suggestion_label(label_id) → label(id)
- suggestion_label(suggestion_id) → suggestion_history(id)
- suggestion_history(category_id) → category(id)
- suggestion_history(parent_suggestion_id) → suggestion_history(id)
- suggestion_history(created_by_id) → users(id)
- suggestion_history(status_id) → status(id)
- suggestion_history(forum_id) → forum(id)
- feature_status(created_by_id) → users(id)
- nps_rating(user_id) → users(id)
- feature_history(created_by_id) → users(id)
- feature_history(feature_status_id) → feature_status(id)
- feature_history(product_area_id) → product_area(id)
- label(parent_id) → label(id)
- message(user_id) → users(id)
- message(request_id) → request(id)
- message(comment_id) → comment(id)
- message(note_id) → note(id)
- product_area(created_by_id) → users(id)
- supporter(suggestion_id) → suggestion_history(id)
- supporter(user_id) → users(id)
- external_user(user_id) → users(id)
- external_user(external_account_id) → external_account(id)
- comment(created_by_id) → users(id)
- comment(suggestion_id) → suggestion_history(id)
- category(forum_id) → forum(id)
- supporter_message(created_by_id) → users(id)
- supporter_message(suggestion_id) → suggestion_history(id)
- internal_status_update_external_user(external_user_id) → external_user(id)
- internal_status_update_external_user(internal_status_update_users_id) → internal_status_update_users(id)
- internal_status_update_team(team_id) → team(id)
- internal_status_update_team(internal_status_update_users_id) → internal_status_update_users(id)
- internal_status_update_users(internal_status_id) → internal_status(id)
- internal_status_update_users(created_by_id) → users(id)
- internal_status_update_users(suggestion_id) → suggestion_history(id)
- internal_status_update_users(old_internal_status_id) → internal_status(id)
- internal_status_update_users(new_internal_status_id) → internal_status(id)
- user_team(user_id) → users(id)
- user_team(id) → team(id)