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 |
Affiche sur le modèle de données
Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.
L'affiche sous forme de texte : tableaux par thème et leurs relations
Admin
Admin_Badge_groupingsByBadges, Admin_Badge_typesByBadges, Admin_BadgesByBadges
Autre
Admin (sans 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
Administrateur (sans relations)
Sauvegarde (sans relations)
Badge (sans relations)
Catégorie (sans relations)
Courriel (sans relations)
Groupe (sans relations)
Modérateur (sans relations)
NATIVEPLATFORMSCALARREQUESTS (sans relations)
Site (sans relations)
Système (sans relations)
Balise (sans relations)
Relations
- Admin_BadgesByBadges → Admin_Badge_groupingsByBadges (clé)
- Admin_BadgesByBadges → Admin_Badge_typesByBadges (clé)
- Posts → Categories (candidat, 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 (candidat, 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.
Tableaux
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
Attributs
The attributes of this platform are on the page 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 :