Discourse
Explore the interactive ERD
Table & Field Reference
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_name | Unknown | PK |
active | Unknown | |
admin | Unknown | |
avatar_template | Unknown | |
can_be_deleted | Unknown | |
created_at | Unknown | |
created_at_age | Unknown | |
days_visited | Unknown | |
email | Unknown | |
last_emailed_age | Unknown | |
last_emailed_at | Unknown | |
last_seen_age | Unknown | |
last_seen_at | Unknown | |
manual_locked_trust_level | Unknown | |
moderator | Unknown | |
name | Unknown | |
post_count | Unknown | |
posts_read_count | Unknown | |
secondary_emails | Json | |
silence_reason | Unknown | |
staged | Unknown | |
suspended_at | Unknown | |
suspended_till | Unknown | |
time_read | Unknown | |
title | Unknown | |
topics_entered | Unknown | |
trust_level | Unknown |
post_mentioned_user
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
post_id | Unknown | PKFK |
avatar_template | Unknown | |
name | Unknown | |
user_name | Unknown |
post_action_summary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
post_id | Unknown | PKFK |
can_act | Unknown |
post
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_id | Unknown | FK |
reply_to_user_id | Unknown | FK |
topic_id | Unknown | FK |
user_id | Unknown | FK |
accepted_answer | Unknown | |
admin | Unknown | |
avatar_template | Unknown | |
badges_granted | Json | |
bookmarked | Unknown | |
can_accept_answer | Unknown | |
can_delete | Unknown | |
can_edit | Unknown | |
can_recover | Unknown | |
can_see_hidden_post | Unknown | |
can_unaccept_answer | Unknown | |
can_view_edit_history | Unknown | |
can_vote | Unknown | |
can_wiki | Unknown | |
cooked | Unknown | |
count | Unknown | |
created_at | Unknown | |
current_user_reaction | Unknown | |
current_user_used_main_reaction | Unknown | |
deleted_at | Unknown | |
deleted_by_avatar_template | Unknown | |
deleted_by_id | Unknown | |
deleted_by_name | Unknown | |
deleted_by_username | Unknown | |
display_username | Unknown | |
edit_reason | Unknown | |
excerpt | Unknown | |
flair_bg_color | Unknown | |
flair_color | Unknown | |
flair_group_id | Unknown | |
flair_name | Unknown | |
flair_url | Unknown | |
hidden | Unknown | |
incoming_link_count | Unknown | |
moderator | Unknown | |
name | Unknown | |
number | Unknown | |
primary_group_name | Unknown | |
quote_count | Unknown | |
raws | Unknown | |
reaction_users_count | Unknown | |
reactions | Json | |
readers_count | Unknown | |
reads | Unknown | |
reply_count | Unknown | |
reply_to_post_number | Unknown | |
reviewable_id | Unknown | |
reviewable_score_count | Unknown | |
reviewable_score_pending_count | Unknown | |
score | Unknown | |
staff | Unknown | |
title_is_group | Unknown | |
topic_accepted_answer | Unknown | |
topic_html_title | Unknown | |
truncated | Unknown | |
trust_level | Unknown | |
type | Unknown | |
updated_at | Unknown | |
url | Unknown | |
user_birthdate | Unknown | |
user_cakedate | Unknown | |
user_deleted | Unknown | |
user_status_description | Unknown | |
user_status_emoji | Unknown | |
user_status_ends_at | Unknown | |
user_status_message_bus_last_id | Unknown | |
version | Unknown | |
wiki | Unknown | |
yours | Unknown |
group_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
group_name | Unknown | FK |
user_name | Unknown | FK |
added_at | Unknown | |
admin | Unknown | |
avatar_template | Unknown | |
flair_group_id | Unknown | |
flair_name | Unknown | |
flair_url | Unknown | |
last_posted_at | Unknown | |
last_seen_at | Unknown | |
name | Unknown | |
primary_group_name | Unknown | |
temp_group_member_group_name | Unknown | |
timezone | Unknown | |
title | Unknown | |
trust_level | Unknown |
group_owner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
group_name | Unknown | PKFK |
added_at | Unknown | |
avatar_template | Unknown | |
last_posted_at | Unknown | |
last_seen_at | Unknown | |
name | Unknown | |
temp_group_member_group_name | Unknown | |
timezone | Unknown | |
title | Unknown | |
user_name | Unknown |
badge
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
badge_grouping_id | Unknown | FK |
badge_type_id | Unknown | FK |
allow_title | Unknown | |
auto_revoke | Unknown | |
description | Unknown | |
enabled | Unknown | |
grant_count | Unknown | |
i_18_n_name | Unknown | |
icon | Unknown | |
image_upload_id | Unknown | |
image_url | Unknown | |
listable | Unknown | |
long_description | Unknown | |
manually_grantable | Unknown | |
multiple_grant | Unknown | |
name | Unknown | |
query | Unknown | |
show_in_post_header | Unknown | |
show_posts | Unknown | |
slug | Unknown | |
systems | Unknown | |
target_posts | Unknown | |
trigger | Unknown |
badge_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
sort_order | Unknown |
badge_grouping
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
name | Unknown | |
position | Unknown | |
systems | Unknown |
user_badge
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_name | Unknown | PK |
badge_id | Unknown | PKFK |
badge_grouping_id | Unknown | FK |
badge_type_id | Unknown | FK |
granted_by_id | Unknown | FK |
can_favorite | Unknown | |
granted_at | Unknown | |
grouping_position | Unknown | |
is_favorite | Unknown |
granted_bies
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_name | Unknown | PK |
admin | Unknown | |
avatar_template | Unknown | |
moderator | Unknown | |
name | Unknown | |
trust_level | Unknown |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | PK |
allow_membership_requests | Unknown | |
automatic | Unknown | |
bio_cooked | Unknown | |
bio_excerpt | Unknown | |
bio_raw | Unknown | |
can_admin_group | Unknown | |
can_edit_group | Unknown | |
can_see_members | Unknown | |
default_notification_level | Unknown | |
display_name | Unknown | |
flair_bg_color | Unknown | |
flair_color | Unknown | |
flair_url | Unknown | |
full_name | Unknown | |
grant_trust_level | Unknown | |
has_messages | Unknown | |
incoming_email | Unknown | |
is_group_owner | Unknown | |
is_group_user | Unknown | |
members_visibility_level | Unknown | |
membership_request_template | Unknown | |
mentionable_level | Unknown | |
messageable_level | Unknown | |
primary_group | Unknown | |
public_admission | Unknown | |
public_exit | Unknown | |
publish_read_state | Unknown | |
title | Unknown | |
user_count | Unknown | |
visibility_level | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
count | Unknown | |
description | Unknown | |
name | Unknown | |
pm_only | Unknown | |
target_tag | Unknown | |
text | Unknown |
topic_poster
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
topic_id | Unknown | PKFK |
user_id | Unknown | FK |
description | Unknown | |
extras | Unknown | |
flair_group_id | Unknown | |
primary_group_id | Unknown |
topic
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_id | Unknown | FK |
archetype | Unknown | |
archived | Unknown | |
bookmarked | Unknown | |
bumped | Unknown | |
bumped_at | Unknown | |
can_vote | Unknown | |
closed | Unknown | |
created_at | Unknown | |
excerpt | Unknown | |
fancy_title | Unknown | |
featured_link | Unknown | |
has_accepted_answer | Unknown | |
has_summary | Unknown | |
highest_post_number | Unknown | |
image_url | Unknown | |
last_posted_at | Unknown | |
last_poster_username | Unknown | |
like_count | Unknown | |
liked | Unknown | |
pinned | Unknown | |
pinned_globally | Unknown | |
posts_count | Unknown | |
reply_count | Unknown | |
slug | Unknown | |
tags | Json | |
tags_descriptions | Json | |
title | Unknown | |
unpinned | Unknown | |
unseen | Unknown | |
views | Unknown | |
visible | Unknown |
subcategory_list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_id | Unknown | PKFK |
can_edit | Unknown | |
color | Unknown | |
count | Unknown | |
default_list_filter | Unknown | |
default_top_period | Unknown | |
default_view | Unknown | |
description | Unknown | |
description_excerpt | Unknown | |
description_text | Unknown | |
has_children | Unknown | |
icon | Unknown | |
list_style | Unknown | |
minimum_required_tags | Unknown | |
name | Unknown | |
navigate_to_first_post_after_read | Unknown | |
notification_level | Unknown | |
num_featured_topics | Unknown | |
permission | Unknown | |
position | Unknown | |
post_count | Unknown | |
read_restricted | Unknown | |
show_subcategory_list | Unknown | |
slug | Unknown | |
sort_ascending | Unknown | |
sort_order | Unknown | |
style_type | Unknown | |
text_color | Unknown | |
topic_count | Unknown | |
topic_template | Unknown | |
topic_url | Unknown | |
uploaded_background | Unknown | |
uploaded_background_dark | Unknown | |
uploaded_logo | Unknown | |
uploaded_logo_dark | Unknown |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
can_edit | Unknown | |
color | Unknown | |
default_list_filter | Unknown | |
default_top_period | Unknown | |
default_view | Unknown | |
description | Unknown | |
description_excerpt | Unknown | |
description_text | Unknown | |
has_children | Unknown | |
icon | Unknown | |
is_uncategorized | Unknown | |
minimum_required_tags | Unknown | |
name | Unknown | |
navigate_to_first_post_after_read | Unknown | |
notification_level | Unknown | |
num_featured_topics | Unknown | |
permission | Unknown | |
position | Unknown | |
post_count | Unknown | |
read_restricted | Unknown | |
show_subcategory_list | Unknown | |
slug | Unknown | |
sort_ascending | Unknown | |
sort_order | Unknown | |
style_type | Unknown | |
subcategory_count | Unknown | |
subcategory_list_style | Unknown | |
text_color | Unknown | |
topic_count | Unknown | |
topic_template | Unknown | |
topic_url | Unknown | |
topics_all_time | Unknown | |
topics_day | Unknown | |
topics_month | Unknown | |
topics_week | Unknown | |
topics_year | Unknown | |
uploaded_background | Unknown | |
uploaded_background_dark | Unknown | |
uploaded_logo | Unknown | |
uploaded_logo_dark | Unknown | |
custom_** |