invantive documentation
Invantive Support ForumsLog In / Sign Up

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

PDF, 1 A0 sheet

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Discourse data model, Sheet 1 of 1Discourse data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026Admin · OtherSheet 1 of 1 · documentation.invantive.euAdminDiscourse.Badges.Admin_Badge_groupingsByBadges: Admin Badge Groupings by BadgesAdmin_Badge_groupingsByBadgesDiscourse.Badges.Admin_Badge_typesByBadges: Admin Badge Types by BadgesAdmin_Badge_typesByBadgesDiscourse.Badges.Admin_BadgesByBadges: Admin Badges by BadgesAdmin_BadgesByBadgesOther×2×2Discourse.Categories.Categories: CategoriesCategoriesDiscourse.Posts.Posts: Posts (Discourse.Posts.Posts_Latest_postsActions_summary)Posts+_Latest_postsActions_summaryDiscourse.Topics.Top: Top (Discourse.Topics.Top_Topic_listTopics, Discourse.Topics.Top_Topic_listTopicsPosters, Discourse.Topics.Top_Users)Top+_Topic_listTopics +_Topic_listTopicsPost…AdminDiscourse.AdminEmails.AdminCustomizeByEmailTemplates: Admin Customized Templates by EmailAdminCustomizeByEmailTemplatesDiscourse.UserFields.AdminCustomizeByUserFields: itgen_dce_admincustomizebyuserfields_pluralAdminCustomizeByUserFieldsDiscourse.Plugins.AdminPlugins: PluginsAdminPluginsDiscourse.Badges.Admin_Admin_badgesProtected_system_fieldsByBadges: Admin Badges Protected System Fields by BadgesAdmin_Admin_badgesProtected_system_fieldsByBa…Discourse.Badges.Admin_Badge_grouping_idsByBadges: itgen_dce_admin_badge_grouping_idsbybadges_pluralAdmin_Badge_grouping_idsByBadgesDiscourse.Badges.Admin_Badge_idsByBadges: itgen_dce_admin_badge_idsbybadges_pluralAdmin_Badge_idsByBadgesDiscourse.Badges.Admin_Badge_type_idsByBadges: itgen_dce_admin_badge_type_idsbybadges_pluralAdmin_Badge_type_idsByBadgesDiscourse.AdminEmails.Admin_SettingsByEmail: Admin Settings by EmailAdmin_SettingsByEmailDiscourse.Admin.Admin_Site_settingsBySiteSettings: Admin Site SettingsAdmin_Site_settingsBySiteSettingsDiscourse.Admin.Admin_Site_settingsChoicesBySiteSettings: Admin Site Setting ChoicesAdmin_Site_settingsChoicesBySiteSettingsDiscourse.Admin.Admin_Site_settingsValid_valuesBySiteSettings: Admin Site Settings Valid ValuesAdmin_Site_settingsValid_valuesBySiteSettingsAdministratorDiscourse.About.Administrators: AdministratorsAdministratorsBackupDiscourse.Backups.Backups: BackupsBackupsBadgeDiscourse.Badges.BadgeSettings: Badge SettingsBadgeSettingsCategoryDiscourse.Categories.CategorySettings: Category SettingsCategorySettingsEmailDiscourse.AdminEmails.EmailSettings: Email SettingsEmailSettingsGroupDiscourse.Groups.Groups: GroupsGroupsModeratorDiscourse.About.Moderators: ModeratorsModeratorsNATIVEPLATFORMSCALARREQUESTSDiscourse.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSSiteDiscourse.Admin.SiteSettings: Site SettingsSiteSettingsSystemDiscourse.About.SystemInformation: System InformationSystemInformationTagDiscourse.Tags.TagGroups: Tag GroupsTagGroupsDiscourse.Tags.Tags: TagsTagsDiscourseData dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsAdmin1Other1Tables without relations1LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n keys between the same tablesGenerated from the metadata of Invantive UniversalSQL 27.1.3-BETA+6294 on 01-11-2026. Every table links to itspage with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/discourse
The poster as text: tables per topic and their relations

Admin

Admin_Badge_groupingsByBadges, Admin_Badge_typesByBadges, Admin_BadgesByBadges

Other

Categories, Posts, Top

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)

Administrators

Backup (without relations)

Backups

Badge (without relations)

BadgeSettings

Category (without relations)

CategorySettings

Email (without relations)

EmailSettings

Group (without relations)

Groups

Moderator (without relations)

Moderators

NATIVEPLATFORMSCALARREQUESTS (without relations)

NATIVEPLATFORMSCALARREQUESTS

Site (without relations)

SiteSettings

System (without relations)

SystemInformation

Tag (without relations)

TagGroups, Tags

Relations

Tables

Discourse.About

Discourse.Admin

Discourse.AdminEmails

Discourse.Backups

Discourse.Badges

Discourse.Categories

Discourse.Emails

Discourse.Flags

Discourse.Groups

Discourse.Logs

Discourse.Native

Discourse.Notifications

Discourse.Plugins

Discourse.Posts

Discourse.PrivateMessages

Discourse.Reports

Discourse.Search

Discourse.Tags

Discourse.Topics

Discourse.UserFields

Discourse.Users

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: