Discourse Data Model
Discourse is een open source discussieplatform voor forums, chatrooms en community building.
Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/discourse
Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.
Platform
- Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
- Type: een applicatie die via de API toegankelijk is.
- De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
- Gegevens kunnen zowel worden geschreven als gelezen.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Cijfers
| Figure | Count |
|---|---|
| Tables | 104 |
| Columns | 2,665 |
| Tabeller med invoegsel | 7 |
| Tabeller med update | 0 |
| Tabellen met de functie 'verwijderen' | 0 |
| Tabeller gedocumenteerd | 104 |
Poster met datamodel
Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden
Beheerder
Admin_Badge_groupingsByBadges, Admin_Badge_typesByBadges, Admin_BadgesByBadges
Overige
Beheerder (zonder relaties)
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 (zonder relaties)
Back-up (zonder relaties)
Badge (zonder relaties)
Categorie (zonder relaties)
E-mail (zonder relaties)
Groeperen (zonder relaties)
Moderator (zonder relaties)
NATIVEPLATFORMSCALARREQUESTS (zonder relaties)
Site (zonder relaties)
Systeem (zonder relaties)
Label (zonder relaties)
Relaties
- Admin_BadgesByBadges → Admin_Badge_groupingsByBadges (sleutel)
- Admin_BadgesByBadges → Admin_Badge_typesByBadges (sleutel)
- Posts → Categories (kandidaat, 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 (kandidaat, 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.
Tabellen
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
Attributen
The attributes of this platform are on the page Attributes.
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: