# Discourse schema ERD

Table and field reference for the Fivetran Discourse connector.

## 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 | PK, FK |
| avatar_template | Unknown |  |
| name | Unknown |  |
| user_name | Unknown |  |

### post_action_summary

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| post_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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_** |  |  |

## Relationships

- post_mentioned_user(post_id) → post(id)
- post_action_summary(post_id) → post(id)
- post(user_id) → users(id)
- post(category_id) → category(id)
- post(topic_id) → topic(id)
- post(reply_to_user_id) → users(id)
- group_member(user_name) → users(user_name)
- group_member(group_name) → groups(name)
- group_owner(group_name) → groups(name)
- badge(badge_type_id) → badge_type(id)
- badge(badge_grouping_id) → badge_grouping(id)
- user_badge(badge_id) → badge(id)
- user_badge(granted_by_id) → granted_bies(id)
- user_badge(badge_type_id) → badge_type(id)
- user_badge(badge_grouping_id) → badge_grouping(id)
- topic_poster(user_id) → users(id)
- topic_poster(topic_id) → topic(id)
- topic(category_id) → category(id)
- subcategory_list(category_id) → category(id)