---
title: "Discourse Data Model"
description: "Discourse is an open source discussion platform for forums, chat rooms and community building."
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/discourse
original: https://documentation.invantive.eu/en/datamodels/discourse
updated: 2026-11-16T20:48:03Z
license: https://documentation.invantive.eu/fr/
---

# Discourse Data Model

Discourse est une plateforme de discussion open source destinée aux forums, aux salons de discussion et à la création de communautés.

Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/discourse

Les comparaisons de texte sur cette plateforme tiennent compte de la casse.

## Plate-forme

- Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
- Type : une application accessible via son API.
- Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
- Les données peuvent être aussi bien écrites que lues.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

## Chiffres

| Figure | Count |
|---|---:|
| Tables | 104 |
| Columns | 2,665 |
| Tableaux avec insert | 7 |
| Tables avec mise à jour | 0 |
| Tables avec la clause DELETE | 0 |
| Tableaux documentés | 104 |

## Tableaux

### Discourse.About

- [Administrators](Discourse.About.Administrators): Administrators
- [Moderators](Discourse.About.Moderators): Moderators
- [SystemInformation](Discourse.About.SystemInformation): System Information

### Discourse.Admin

- [AdminUsersById](Discourse.Admin.AdminUsersById): Admin Users by ID
- [AdminUsers_GroupsById](Discourse.Admin.AdminUsers_GroupsById): Admin Users Groups by ID
- [Admin_Site_settingsBySiteSettings](Discourse.Admin.Admin_Site_settingsBySiteSettings): Admin Site Settings
- [Admin_Site_settingsChoicesBySiteSettings](Discourse.Admin.Admin_Site_settingsChoicesBySiteSettings): Admin Site Setting Choices
- [Admin_Site_settingsValid_valuesBySiteSettings](Discourse.Admin.Admin_Site_settingsValid_valuesBySiteSettings): Admin Site Settings Valid Values
- [GroupsByGroupNameMembers](Discourse.Admin.GroupsByGroupNameMembers): itgen_dce_groupsbygroupnamemembers_plural
- [GroupsByGroupName_MembersMembers](Discourse.Admin.GroupsByGroupName_MembersMembers): itgen_dce_groupsbygroupname_membersmembers_plural
- [GroupsByGroupName_OwnersMembers](Discourse.Admin.GroupsByGroupName_OwnersMembers): itgen_dce_groupsbygroupname_ownersmembers_plural
- [SiteSettings](Discourse.Admin.SiteSettings): Site Settings

### Discourse.AdminEmails

- [AdminCustomizeByEmailTemplates](Discourse.AdminEmails.AdminCustomizeByEmailTemplates): Admin Customized Templates by Email
- [Admin_SettingsByEmail](Discourse.AdminEmails.Admin_SettingsByEmail): Admin Settings by Email
- [EmailSettings](Discourse.AdminEmails.EmailSettings): Email Settings

### Discourse.Backups

- [Backups](Discourse.Backups.Backups): Backups

### Discourse.Badges

- [Admin_Admin_badgesProtected_system_fieldsByBadges](Discourse.Badges.Admin_Admin_badgesProtected_system_fieldsByBadges): Admin Badges Protected System Fields by Badges
- [Admin_Badge_grouping_idsByBadges](Discourse.Badges.Admin_Badge_grouping_idsByBadges): itgen_dce_admin_badge_grouping_idsbybadges_plural
- [Admin_Badge_groupingsByBadges](Discourse.Badges.Admin_Badge_groupingsByBadges): Admin Badge Groupings by Badges
- [Admin_Badge_idsByBadges](Discourse.Badges.Admin_Badge_idsByBadges): itgen_dce_admin_badge_idsbybadges_plural
- [Admin_Badge_type_idsByBadges](Discourse.Badges.Admin_Badge_type_idsByBadges): itgen_dce_admin_badge_type_idsbybadges_plural
- [Admin_Badge_typesByBadges](Discourse.Badges.Admin_Badge_typesByBadges): Admin Badge Types by Badges
- [Admin_BadgesByBadges](Discourse.Badges.Admin_BadgesByBadges): Admin Badges by Badges
- [BadgeSettings](Discourse.Badges.BadgeSettings): Badge Settings
- [UserBadgesByUsername](Discourse.Badges.UserBadgesByUsername): itgen_dce_userbadgesbyusername_plural
- [UserBadges_Badge_typesByUsername](Discourse.Badges.UserBadges_Badge_typesByUsername): User Badges Badge Types by Username
- [UserBadges_BadgesByUsername](Discourse.Badges.UserBadges_BadgesByUsername): User Badges Badges by Username
- [UserBadges_Granted_biesByUsername](Discourse.Badges.UserBadges_Granted_biesByUsername): User Badges Granted Granters by Username
- [UserBadges_TopicsByUsername](Discourse.Badges.UserBadges_TopicsByUsername): itgen_dce_userbadges_topicsbyusername_plural
- [UserBadges_User_badgesByUsername](Discourse.Badges.UserBadges_User_badgesByUsername): User Badges by Username
- [UserBadges_UsersByUsername](Discourse.Badges.UserBadges_UsersByUsername): itgen_dce_userbadges_usersbyusername_plural

### Discourse.Categories

- [Categories](Discourse.Categories.Categories): Categories
- [CategoryById](Discourse.Categories.CategoryById): itgen_dce_categorybyid_plural
- [CategorySettings](Discourse.Categories.CategorySettings): Category Settings
- [c_Topic_listTopicsById](Discourse.Categories.c_Topic_listTopicsById): itgen_dce_c_topic_listtopicsbyid_plural
- [c_Topic_listTopicsPostersById](Discourse.Categories.c_Topic_listTopicsPostersById): itgen_dce_c_topic_listtopicspostersbyid_plural
- [c_UsersById](Discourse.Categories.c_UsersById): itgen_dce_c_usersbyid_plural

### Discourse.Emails

- [AdminEmailsByAction](Discourse.Emails.AdminEmailsByAction): itgen_dce_adminemailsbyaction_plural

### Discourse.Flags

- [AdminFlagsByType](Discourse.Flags.AdminFlagsByType): itgen_dce_adminflagsbytype_plural
- [AdminFlags_PostsByType](Discourse.Flags.AdminFlags_PostsByType): itgen_dce_adminflags_postsbytype_plural
- [AdminFlags_TopicsByType](Discourse.Flags.AdminFlags_TopicsByType): itgen_dce_adminflags_topicsbytype_plural
- [AdminFlags_UsersByType](Discourse.Flags.AdminFlags_UsersByType): itgen_dce_adminflags_usersbytype_plural

### Discourse.Groups

- [Groups](Discourse.Groups.Groups): Groups
- [GroupsByName](Discourse.Groups.GroupsByName): Group by Name
- [Groups_ExtrasVisible_group_namesByName](Discourse.Groups.Groups_ExtrasVisible_group_namesByName): Group Extras Visible Group Names by Name

### Discourse.Logs

- [AdminLogsByStaffActionLogs](Discourse.Logs.AdminLogsByStaffActionLogs): Staff Action Logs

### Discourse.Native

- [NATIVEPLATFORMSCALARREQUESTS](Discourse.Native.NATIVEPLATFORMSCALARREQUESTS): Native Platform Scalar Requests

### Discourse.Notifications

- [Notifications](Discourse.Notifications.Notifications): Notifications
- [Notifications_Notifications](Discourse.Notifications.Notifications_Notifications): Notification Entries

### Discourse.Plugins

- [AdminPlugins](Discourse.Plugins.AdminPlugins): Plugins

### Discourse.Posts

- [Posts](Discourse.Posts.Posts): Posts
- [PostsById](Discourse.Posts.PostsById): Post by ID
- [Posts_Actions_summaryById](Discourse.Posts.Posts_Actions_summaryById): Post Actions Summary by ID
- [Posts_Latest_postsActions_summary](Discourse.Posts.Posts_Latest_postsActions_summary): Posts Latest Post Actions Summary

### Discourse.PrivateMessages

- [TopicsPrivateMessagesByUsername](Discourse.PrivateMessages.TopicsPrivateMessagesByUsername): Private Messages by Username
- [TopicsPrivateMessagesSentByUsername](Discourse.PrivateMessages.TopicsPrivateMessagesSentByUsername): Private Messages Sent by Username
- [TopicsPrivateMessagesSent_Topic_listTopicsByUsername](Discourse.PrivateMessages.TopicsPrivateMessagesSent_Topic_listTopicsByUsername): Private Messages Sent Topics by Username
- [TopicsPrivateMessagesSent_Topic_listTopicsParticipantsByUsername](Discourse.PrivateMessages.TopicsPrivateMessagesSent_Topic_listTopicsParticipantsByUsername): Private Messages Sent Topics Participants by Username
- [TopicsPrivateMessagesSent_Topic_listTopicsPostersByUsername](Discourse.PrivateMessages.TopicsPrivateMessagesSent_Topic_listTopicsPostersByUsername): Private Messages Sent Topic Posters by Username
- [TopicsPrivateMessagesSent_UsersByUsername](Discourse.PrivateMessages.TopicsPrivateMessagesSent_UsersByUsername): Private Messages Sent Users by Username
- [TopicsPrivateMessages_Topic_listTopicsByUsername](Discourse.PrivateMessages.TopicsPrivateMessages_Topic_listTopicsByUsername): Private Messages Topics by Username
- [TopicsPrivateMessages_Topic_listTopicsParticipantsByUsername](Discourse.PrivateMessages.TopicsPrivateMessages_Topic_listTopicsParticipantsByUsername): Private Messages Topics Participants by Username
- [TopicsPrivateMessages_Topic_listTopicsPostersByUsername](Discourse.PrivateMessages.TopicsPrivateMessages_Topic_listTopicsPostersByUsername): Private Messages Topic Posters by Username

### Discourse.Reports

- [PageViewTotalReqs](Discourse.Reports.PageViewTotalReqs): Page View Total Requests
- [PageViewTotalReqs_ReportData](Discourse.Reports.PageViewTotalReqs_ReportData): Page View Total Requests Report Data

### Discourse.Search

- [SearchQuery](Discourse.Search.SearchQuery): itgen_dce_searchquery_plural
- [Search_CategoriesQuery](Discourse.Search.Search_CategoriesQuery): itgen_dce_search_categoriesquery_plural
- [Search_Grouped_search_resultCategory_idsQuery](Discourse.Search.Search_Grouped_search_resultCategory_idsQuery): itgen_dce_search_grouped_search_resultcategory_idsquery_plural
- [Search_Grouped_search_resultPost_idsQuery](Discourse.Search.Search_Grouped_search_resultPost_idsQuery): itgen_dce_search_grouped_search_resultpost_idsquery_plural
- [Search_Grouped_search_resultUser_idsQuery](Discourse.Search.Search_Grouped_search_resultUser_idsQuery): itgen_dce_search_grouped_search_resultuser_idsquery_plural
- [Search_PostsQuery](Discourse.Search.Search_PostsQuery): itgen_dce_search_postsquery_plural
- [Search_TopicsPostersQuery](Discourse.Search.Search_TopicsPostersQuery): itgen_dce_search_topicspostersquery_plural
- [Search_TopicsQuery](Discourse.Search.Search_TopicsQuery): itgen_dce_search_topicsquery_plural
- [Search_UsersQuery](Discourse.Search.Search_UsersQuery): itgen_dce_search_usersquery_plural

### Discourse.Tags

- [TagGroups](Discourse.Tags.TagGroups): Tag Groups
- [TagGroupsById](Discourse.Tags.TagGroupsById): Tag Group by ID
- [TagGroups_Tag_groupParent_tag_nameById](Discourse.Tags.TagGroups_Tag_groupParent_tag_nameById): Tag Group Parent Tag Name by ID
- [TagGroups_Tag_groupTag_namesById](Discourse.Tags.TagGroups_Tag_groupTag_namesById): Tag Group Tag Names by ID
- [TagGroups_Tag_groupsTag_names](Discourse.Tags.TagGroups_Tag_groupsTag_names): Tag Group Tags
- [Tags](Discourse.Tags.Tags): Tags
- [TagsByTag](Discourse.Tags.TagsByTag): itgen_dce_tagsbytag_plural

### Discourse.Topics

- [Latest](Discourse.Topics.Latest): Latest
- [Latest_Topic_listTopics](Discourse.Topics.Latest_Topic_listTopics): Latest Topics
- [Latest_Topic_listTopicsPosters](Discourse.Topics.Latest_Topic_listTopicsPosters): Latest Topic Posters
- [Latest_Users](Discourse.Topics.Latest_Users): Latest Users
- [Top](Discourse.Topics.Top): Top
- [TopByFlag](Discourse.Topics.TopByFlag): itgen_dce_topbyflag_plural
- [Top_Topic_listTopics](Discourse.Topics.Top_Topic_listTopics): Top Topics
- [Top_Topic_listTopicsPosters](Discourse.Topics.Top_Topic_listTopicsPosters): Top Topic Posters
- [Top_Users](Discourse.Topics.Top_Users): Top Users
- [tById](Discourse.Topics.tById): Topic by ID
- [tByIdPosts](Discourse.Topics.tByIdPosts): Topic Posts by ID
- [tById_Post_streamPostsPosts](Discourse.Topics.tById_Post_streamPostsPosts): Topic Post Stream Posts Posts by ID
- [t_Actions_summaryById](Discourse.Topics.t_Actions_summaryById): Topic Actions Summary by ID
- [t_DetailsParticipantsById](Discourse.Topics.t_DetailsParticipantsById): Topic Details Participants by ID
- [t_DetailsSuggested_topicsById](Discourse.Topics.t_DetailsSuggested_topicsById): itgen_dce_t_detailssuggested_topicsbyid_plural
- [t_DetailsSuggested_topicsPostersById](Discourse.Topics.t_DetailsSuggested_topicsPostersById): itgen_dce_t_detailssuggested_topicspostersbyid_plural
- [t_Post_streamPostsActions_summaryById](Discourse.Topics.t_Post_streamPostsActions_summaryById): Topic Post Stream Posts Actions Summary by ID
- [t_Post_streamPostsById](Discourse.Topics.t_Post_streamPostsById): Topic Post Stream Posts by ID
- [t_Post_streamPostsPollsPollOptionsById](Discourse.Topics.t_Post_streamPostsPollsPollOptionsById): itgen_dce_t_post_streampostspollspolloptionsbyid_plural
- [t_Post_streamPostsPolls_votesPollById](Discourse.Topics.t_Post_streamPostsPolls_votesPollById): itgen_dce_t_post_streampostspolls_votespollbyid_plural
- [t_Post_streamStreamById](Discourse.Topics.t_Post_streamStreamById): Topic Post Stream Stream by ID
- [t_Timeline_lookup0ById](Discourse.Topics.t_Timeline_lookup0ById): itgen_dce_t_timeline_lookup0byid_plural
- [t_Timeline_lookupById](Discourse.Topics.t_Timeline_lookupById): Topic Timeline Lookup by ID

### Discourse.UserFields

- [AdminCustomizeByUserFields](Discourse.UserFields.AdminCustomizeByUserFields): itgen_dce_admincustomizebyuserfields_plural

### Discourse.Users

- [AdminUsersListByFlag](Discourse.Users.AdminUsersListByFlag): Admin Users List by Flag
- [DirectoryItems](Discourse.Users.DirectoryItems): Directory Items
- [DirectoryItems_Directory_items](Discourse.Users.DirectoryItems_Directory_items): Directory Item Entries
- [UserActions](Discourse.Users.UserActions): User Actions
- [UsersByUsername](Discourse.Users.UsersByUsername): itgen_dce_usersbyusername_plural
- [Users_UserFeatured_user_badge_idsByUsername](Discourse.Users.Users_UserFeatured_user_badge_idsByUsername): itgen_dce_users_userfeatured_user_badge_idsbyusername_plural
- [Users_UserGroupsByUsername](Discourse.Users.Users_UserGroupsByUsername): itgen_dce_users_usergroupsbyusername_plural
- [Users_User_badgesByUsername](Discourse.Users.Users_User_badgesByUsername): itgen_dce_users_user_badgesbyusername_plural
- [uByExternalByExternalId](Discourse.Users.uByExternalByExternalId): User by External ID
- [uByExternal_UserFeatured_user_badge_idsByExternalId](Discourse.Users.uByExternal_UserFeatured_user_badge_idsByExternalId): User Featured User Badge IDs by External ID
- [uByExternal_UserGroupsByExternalId](Discourse.Users.uByExternal_UserGroupsByExternalId): User Groups by External ID
- [uByExternal_User_badgesByExternalId](Discourse.Users.uByExternal_User_badgesByExternalId): User Badges by External ID

## Attributs

The attributes of this platform are on the page [Attributes](attributes).


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

- [Discourse](/fr/release-notes/drivers?driver=discourse)
