Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
forum_id ➤ FORUM
name
created_at
updated_at
CATEGORY ⇱
id 🔑
updated_at 🔑
forum_id ➤ FORUM
category_id ➤ CATEGORY
created_by_id ➤ USER
status_id ➤ STATUS
parent_suggestion_id ➤ SUGGESTION
approved_at
average_engagement
body
channel
closed_at
created_at
engagement_trend
first_support_at
inappropriate_flags_count
is_blocker
recent_engagement
state
title
unmergeable
created_at
SUGGESTION_HISTORY ⇱
id 🔑
name
is_private
is_public
category_required
classic_voting
example
prompt
welcome_message
created_at
updated_at
FORUM ⇱
id 🔑
suggestion_id ➤ SUGGESTION_HISTORY
created_by_id ➤ USER
body
state
inappropriate_flags_count
is_admin_comment
channel
created_at
updated_at
COMMENT ⇱
id 🔑
suggestion_id ➤ SUGGESTION_HISTORY
created_by_id ➤ USER
body
notification_email_address
mail_sent_count
mail_opened_count
mail_clicked_count
created_at
updated_at
SUPPORTER_MESSAGE ⇱
id 🔑
suggestion_id ➤ SUGGESTION_HISTORY
created_by_id ➤ USER
body
created_at
updated_at
NOTE ⇱
id 🔑
name
email_address
email_confirmed
job_title
last_login
country
region
city
allowed_state
state
is_admin
is_owner
comment_notifications
status_notifications
support_created_at
guid
created_at
updated_at
USER ⇱
id 🔑
updated_at 🔑
created_by_id ➤ USER
feature_status_id ➤ FEATURE_STATUS
product_area_id ➤ PRODUCT_AREA
name
description
is_blocker
supporter_mrr_cents
created_at
custom_*
FEATURE_HISTORY ⇱
id 🔑
created_by_id ➤ USER
name
is_default
created_at
updated_at
FEATURE_STATUS ⇱
id 🔑
created_by_id ➤ USER
name
created_at
updated_at
PRODUCT_AREA ⇱
id 🔑
parent_id ➤ LABEL
name
full_name
level
created_at
updated_at
LABEL ⇱
id 🔑
name
is_open
allow_comments
created_at
updated_at
STATUS ⇱
id 🔑
name
TEAM ⇱
user_id 🔑 ➤ USER
team_id 🔑 ➤ TEAM
USER_TEAM ⇱
id 🔑
suggestion_id ➤ SUGGESTION_HISTORY
user_id ➤ USER
channel
how
is_subscribed
created_at
updated_at
SUPPORTER ⇱
id 🔑
suggestion_id ➤ SUGGESTION_HISTORY
user_id ➤ USER
supporter_id ➤ SUPPORTER
body
source_url
source_type
source_guid
source_title
channel
severity
prompt
referrer
created_at
updated_at
REQUEST ⇱
id 🔑
external_id
name
plan
ltv_cents
mrr_cents
external_created_at
last_active_at
is_blocking
created_at
updated_at
custom_*
EXTERNAL_ACCOUNT ⇱
id 🔑
user_id ➤ USER
external_account_id ➤ EXTERNAL_ACCOUNT
external_created_at
external_id
ip
last_seen_at
name
seen_days
type
created_at
updated_at
custom_*
EXTERNAL_USER ⇱
id 🔑
user_id ➤ USER
rating
body
prompt
created_at
updated_at
NPS_RATING ⇱
suggestion_id 🔑 ➤ SUGGESTION_HISTORY
label_id 🔑 ➤ LABEL
SUGGESTION_LABEL ⇱
id 🔑
Rt
is_default
numeric_value
CUSTOM_FIELD_ENUM_VALUE ⇱
feature_id 🔑 ➤ FEATURE_HISTORY
suggestion_id 🔑 ➤ SUGGESTION_HISTORY
FEATURE_SUGGESTION ⇱
id 🔑
comment_id ➤ COMMENT�note_id ➤ NOTE�request_id ➤ REQUEST
user_id ➤ USER
created_at
is_email_reply
stripped_html
stripped_text
thread_updated_at
MESSAGE