Uservoice
Explore the interactive ERD
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 | PKFK |
suggestion_id | Unknown | PKFK |
suggestion_label
| Column | Type | Keys |
|---|---|---|
label_id | Unknown | PKFK |
suggestion_id | Unknown | PKFK |
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 | PKFK |
external_user_id | Unknown | FK |
internal_status_update_team
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
internal_status_update_users_id | Unknown | PKFK |
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 | PKFK |
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 |