Discourse Data Model
Discourse is an open source discussion platform for forums, chat rooms and community building.
Set up this platform in Invantive Cloud: https://cloud.invantive.com/discourse
Text comparisons on this platform are case sensitive.
Platform
- Used from: Invantive Cloud and the Invantive products on your own computer or server.
- Kind: an application reached over its API.
- The data is partitioned, such as per company or administration.
- Data can be written as well as read.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Figures
| Figure | Count |
|---|---|
| Tables | 104 |
| Columns | 2,665 |
| Tables with insert | 7 |
| Tables with update | 0 |
| Tables with delete | 0 |
| Tables documented | 104 |
Data Model Poster
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
The poster as text: tables per topic and their relations
Admin
Admin_Badge_groupingsByBadges, Admin_Badge_typesByBadges, Admin_BadgesByBadges
Other
Admin (without relations)
AdminCustomizeByEmailTemplates, AdminCustomizeByUserFields, AdminPlugins, Admin_Admin_badgesProtected_system_fieldsByBadges, Admin_Badge_grouping_idsByBadges, Admin_Badge_idsByBadges, Admin_Badge_type_idsByBadges, Admin_SettingsByEmail, Admin_Site_settingsBySiteSettings, Admin_Site_settingsChoicesBySiteSettings, Admin_Site_settingsValid_valuesBySiteSettings
Administrator (without relations)
Backup (without relations)
Badge (without relations)
Category (without relations)
Email (without relations)
Group (without relations)
Moderator (without relations)
NATIVEPLATFORMSCALARREQUESTS (without relations)
Site (without relations)
System (without relations)
Tag (without relations)
Relations
- Admin_BadgesByBadges → Admin_Badge_groupingsByBadges (key)
- Admin_BadgesByBadges → Admin_Badge_typesByBadges (key)
- Posts → Categories (candidate, 2 keys): Not stated by Discourse; found on the data of the smoke forum on 2026-10-31, where every filled value is in the referenced table.
- Top → Categories (candidate, 2 keys): Not stated by Discourse; found on the data of the smoke forum on 2026-10-31, where every filled value is in the referenced table.
Tables
Discourse.About
- Administrators: Administrators
- Moderators: Moderators
- SystemInformation: System Information
Discourse.Admin
- AdminUsersById: Admin Users by ID
- AdminUsers_GroupsById: Admin Users Groups by ID
- Admin_Site_settingsBySiteSettings: Admin Site Settings
- Admin_Site_settingsChoicesBySiteSettings: Admin Site Setting Choices
- Admin_Site_settingsValid_valuesBySiteSettings: Admin Site Settings Valid Values
- GroupsByGroupNameMembers: itgen_dce_groupsbygroupnamemembers_plural
- GroupsByGroupName_MembersMembers: itgen_dce_groupsbygroupname_membersmembers_plural
- GroupsByGroupName_OwnersMembers: itgen_dce_groupsbygroupname_ownersmembers_plural
- SiteSettings: Site Settings
Discourse.AdminEmails
- AdminCustomizeByEmailTemplates: Admin Customized Templates by Email
- Admin_SettingsByEmail: Admin Settings by Email
- EmailSettings: Email Settings
Discourse.Backups
- Backups: Backups
Discourse.Badges
- Admin_Admin_badgesProtected_system_fieldsByBadges: Admin Badges Protected System Fields by Badges
- Admin_Badge_grouping_idsByBadges: itgen_dce_admin_badge_grouping_idsbybadges_plural
- Admin_Badge_groupingsByBadges: Admin Badge Groupings by Badges
- Admin_Badge_idsByBadges: itgen_dce_admin_badge_idsbybadges_plural
- Admin_Badge_type_idsByBadges: itgen_dce_admin_badge_type_idsbybadges_plural
- Admin_Badge_typesByBadges: Admin Badge Types by Badges
- Admin_BadgesByBadges: Admin Badges by Badges
- BadgeSettings: Badge Settings
- UserBadgesByUsername: itgen_dce_userbadgesbyusername_plural
- UserBadges_Badge_typesByUsername: User Badges Badge Types by Username
- UserBadges_BadgesByUsername: User Badges Badges by Username
- UserBadges_Granted_biesByUsername: User Badges Granted Granters by Username
- UserBadges_TopicsByUsername: itgen_dce_userbadges_topicsbyusername_plural
- UserBadges_User_badgesByUsername: User Badges by Username
- UserBadges_UsersByUsername: itgen_dce_userbadges_usersbyusername_plural
Discourse.Categories
- Categories: Categories
- CategoryById: itgen_dce_categorybyid_plural
- CategorySettings: Category Settings
- c_Topic_listTopicsById: itgen_dce_c_topic_listtopicsbyid_plural
- c_Topic_listTopicsPostersById: itgen_dce_c_topic_listtopicspostersbyid_plural
- c_UsersById: itgen_dce_c_usersbyid_plural
Discourse.Emails
- AdminEmailsByAction: itgen_dce_adminemailsbyaction_plural
Discourse.Flags
- AdminFlagsByType: itgen_dce_adminflagsbytype_plural
- AdminFlags_PostsByType: itgen_dce_adminflags_postsbytype_plural
- AdminFlags_TopicsByType: itgen_dce_adminflags_topicsbytype_plural
- AdminFlags_UsersByType: itgen_dce_adminflags_usersbytype_plural
Discourse.Groups
- Groups: Groups
- GroupsByName: Group by Name
- Groups_ExtrasVisible_group_namesByName: Group Extras Visible Group Names by Name
Discourse.Logs
- AdminLogsByStaffActionLogs: Staff Action Logs
Discourse.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Discourse.Notifications
- Notifications: Notifications
- Notifications_Notifications: Notification Entries
Discourse.Plugins
- AdminPlugins: Plugins
Discourse.Posts
- Posts: Posts
- PostsById: Post by ID
- Posts_Actions_summaryById: Post Actions Summary by ID
- Posts_Latest_postsActions_summary: Posts Latest Post Actions Summary
Discourse.PrivateMessages
- TopicsPrivateMessagesByUsername: Private Messages by Username
- TopicsPrivateMessagesSentByUsername: Private Messages Sent by Username
- TopicsPrivateMessagesSent_Topic_listTopicsByUsername: Private Messages Sent Topics by Username
- TopicsPrivateMessagesSent_Topic_listTopicsParticipantsByUsername: Private Messages Sent Topics Participants by Username
- TopicsPrivateMessagesSent_Topic_listTopicsPostersByUsername: Private Messages Sent Topic Posters by Username
- TopicsPrivateMessagesSent_UsersByUsername: Private Messages Sent Users by Username
- TopicsPrivateMessages_Topic_listTopicsByUsername: Private Messages Topics by Username
- TopicsPrivateMessages_Topic_listTopicsParticipantsByUsername: Private Messages Topics Participants by Username
- TopicsPrivateMessages_Topic_listTopicsPostersByUsername: Private Messages Topic Posters by Username
Discourse.Reports
- PageViewTotalReqs: Page View Total Requests
- PageViewTotalReqs_ReportData: Page View Total Requests Report Data
Discourse.Search
- SearchQuery: itgen_dce_searchquery_plural
- Search_CategoriesQuery: itgen_dce_search_categoriesquery_plural
- Search_Grouped_search_resultCategory_idsQuery: itgen_dce_search_grouped_search_resultcategory_idsquery_plural
- Search_Grouped_search_resultPost_idsQuery: itgen_dce_search_grouped_search_resultpost_idsquery_plural
- Search_Grouped_search_resultUser_idsQuery: itgen_dce_search_grouped_search_resultuser_idsquery_plural
- Search_PostsQuery: itgen_dce_search_postsquery_plural
- Search_TopicsPostersQuery: itgen_dce_search_topicspostersquery_plural
- Search_TopicsQuery: itgen_dce_search_topicsquery_plural
- Search_UsersQuery: itgen_dce_search_usersquery_plural
Discourse.Tags
- TagGroups: Tag Groups
- TagGroupsById: Tag Group by ID
- TagGroups_Tag_groupParent_tag_nameById: Tag Group Parent Tag Name by ID
- TagGroups_Tag_groupTag_namesById: Tag Group Tag Names by ID
- TagGroups_Tag_groupsTag_names: Tag Group Tags
- Tags: Tags
- TagsByTag: itgen_dce_tagsbytag_plural
Discourse.Topics
- Latest: Latest
- Latest_Topic_listTopics: Latest Topics
- Latest_Topic_listTopicsPosters: Latest Topic Posters
- Latest_Users: Latest Users
- Top: Top
- TopByFlag: itgen_dce_topbyflag_plural
- Top_Topic_listTopics: Top Topics
- Top_Topic_listTopicsPosters: Top Topic Posters
- Top_Users: Top Users
- tById: Topic by ID
- tByIdPosts: Topic Posts by ID
- tById_Post_streamPostsPosts: Topic Post Stream Posts Posts by ID
- t_Actions_summaryById: Topic Actions Summary by ID
- t_DetailsParticipantsById: Topic Details Participants by ID
- t_DetailsSuggested_topicsById: itgen_dce_t_detailssuggested_topicsbyid_plural
- t_DetailsSuggested_topicsPostersById: itgen_dce_t_detailssuggested_topicspostersbyid_plural
- t_Post_streamPostsActions_summaryById: Topic Post Stream Posts Actions Summary by ID
- t_Post_streamPostsById: Topic Post Stream Posts by ID
- t_Post_streamPostsPollsPollOptionsById: itgen_dce_t_post_streampostspollspolloptionsbyid_plural
- t_Post_streamPostsPolls_votesPollById: itgen_dce_t_post_streampostspolls_votespollbyid_plural
- t_Post_streamStreamById: Topic Post Stream Stream by ID
- t_Timeline_lookup0ById: itgen_dce_t_timeline_lookup0byid_plural
- t_Timeline_lookupById: Topic Timeline Lookup by ID
Discourse.UserFields
- AdminCustomizeByUserFields: itgen_dce_admincustomizebyuserfields_plural
Discourse.Users
- AdminUsersListByFlag: Admin Users List by Flag
- DirectoryItems: Directory Items
- DirectoryItems_Directory_items: Directory Item Entries
- UserActions: User Actions
- UsersByUsername: itgen_dce_usersbyusername_plural
- Users_UserFeatured_user_badge_idsByUsername: itgen_dce_users_userfeatured_user_badge_idsbyusername_plural
- Users_UserGroupsByUsername: itgen_dce_users_usergroupsbyusername_plural
- Users_User_badgesByUsername: itgen_dce_users_user_badgesbyusername_plural
- uByExternalByExternalId: User by External ID
- uByExternal_UserFeatured_user_badge_idsByExternalId: User Featured User Badge IDs by External ID
- uByExternal_UserGroupsByExternalId: User Groups by External ID
- uByExternal_User_badgesByExternalId: User Badges by External ID
Attributes
The attributes of this platform are on the page Attributes.
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: