Uservoice

Explore the interactive ERD

Table & Field Reference

external_account

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`external_created_at`	Instant
`external_id`	String
`is_blocking`	Boolean
`last_active_at`	Instant
`ltv_cents`	Long
`mrr_cents`	Long
`name`	String
`plan`	String
`updated_at`	Instant

user_team

Column	Type	Keys
`team_id`	Long	PKFK
`user_id`	Long	PKFK

label

Column	Type	Keys
`id`	Long	PK
`parent_id`	Long	FK
`created_at`	Instant
`full_name`	String
`level`	Long
`name`	String
`updated_at`	Instant

comment

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`suggestion_id`	Long	FK
`body`	String
`channel`	String
`created_at`	Instant
`inappropriate_flags_count`	Long
`is_admin_comment`	Boolean
`state`	String
`updated_at`	Instant

team

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`updated_at`	Instant

custom_field_enum_value

Column	Type	Keys
`id`	Long	PK
`is_default`	Boolean
`label`	String
`numeric_value`	Double

supporter

Column	Type	Keys
`id`	Long	PK
`suggestion_id`	Long	FK
`user_id`	Long	FK
`channel`	String
`created_at`	Instant
`how`	String
`is_subscribed`	Boolean
`updated_at`	Instant

suggestion_label

Column	Type	Keys
`label_id`	Long	PKFK
`suggestion_id`	Long	PKFK

feature_status

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`created_at`	Instant
`is_default`	Boolean
`name`	String
`updated_at`	Instant

supporter_message

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`suggestion_id`	Long	FK
`body`	String
`created_at`	Instant
`mail_clicked_count`	Long
`mail_opened_count`	Long
`mail_sent_count`	Long
`notification_email_address`	String
`updated_at`	Instant

request

Column	Type	Keys
`id`	Long	PK
`suggestion_id`	Long	FK
`supporter_id`	Long	FK
`user_id`	Long	FK
`body`	String
`channel`	String
`created_at`	Instant
`prompt`	String
`referrer`	String
`severity`	Long
`source_guid`	String
`source_title`	String
`source_type`	String
`source_url`	String
`updated_at`	Instant

suggestion_history

Column	Type	Keys
`id`	Long	PK
`category_id`	Long	FK
`created_by_id`	Long	FK
`forum_id`	Long	FK
`parent_suggestion_id`	Long	FK
`status_id`	Long	FK
`approved_at`	Instant
`average_engagement`	Float
`body`	String
`channel`	String
`closed_at`	Instant
`created_at`	Instant
`engagement_trend`	Float
`first_support_at`	Instant
`inappropriate_flags_count`	Long
`is_blocker`	Boolean
`recent_engagement`	Long
`state`	String
`title`	String
`unmergeable`	Boolean
`updated_at`	Instant

message

Column	Type	Keys
`id`	Long	PK
`comment_id`	Long	FK
`note_id`	Long	FK
`request_id`	Long	FK
`user_id`	Long	FK
`created_at`	Instant
`is_email_reply`	Boolean
`stripped_html`	String
`stripped_text`	String
`thread_updated_at`	Instant

user

Column	Type	Keys
`id`	Long	PK
`allowed_state`	String
`city`	String
`comment_notifications`	Boolean
`country`	String
`created_at`	Instant
`email_address`	String
`email_confirmed`	Boolean
`guid`	String
`is_admin`	Boolean
`is_owner`	Boolean
`job_title`	String
`last_login`	Instant
`name`	String
`region`	String
`state`	String
`status_notifications`	Boolean
`support_created_at`	Instant
`updated_at`	Instant

forum

Column	Type	Keys
`id`	Long	PK
`category_required`	Boolean
`classic_voting`	Boolean
`created_at`	Instant
`example`	String
`is_private`	Boolean
`is_public`	Boolean
`name`	String
`prompt`	String
`updated_at`	Instant
`welcome_message`	String

external_user

Column	Type	Keys
`id`	Long	PK
`external_account_id`	Long	FK
`user_id`	Long	FK
`created_at`	Instant
`email`	String
`external_created_at`	Instant
`external_id`	String
`ip`	String
`last_seen_at`	Instant
`name`	String
`seen_days`	Long
`type`	String
`updated_at`	Instant

feature_suggestion

Column	Type	Keys
`feature_id`	Long	PKFK
`suggestion_id`	Long	PKFK

nps_rating

Column	Type	Keys
`id`	Long	PK
`user_id`	Long	FK
`body`	String
`created_at`	Instant
`prompt`	String
`rating`	Long
`updated_at`	Instant

note

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`suggestion_id`	Long	FK
`body`	String
`created_at`	Instant
`updated_at`	Instant

product_area

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`created_at`	Instant
`name`	String
`updated_at`	Instant

status

Column	Type	Keys
`id`	Long	PK
`allow_comments`	Boolean
`created_at`	Instant
`is_open`	Boolean
`name`	String
`updated_at`	Instant

feature_history

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`feature_status_id`	Long	FK
`product_area_id`	Long	FK
`created_at`	Instant
`description`	String
`is_blocker`	Boolean
`name`	String
`updated_at`	Instant

Uservoice

Explore the interactive ERD

Table & Field Reference

external_account

user_team

label

comment

team

custom_field_enum_value

supporter

suggestion_label

feature_status

supporter_message

request

suggestion_history

category

message

user

forum

external_user

feature_suggestion

nps_rating

note

product_area

status

feature_history