Discourse Data Model
Discourse ist eine Open-Source-Diskussionsplattform für Foren, Chatrooms und den Aufbau von Communitys.
Richten Sie diese Plattform in der Invantive Cloud ein: https://cloud.invantive.com/discourse
Bei Textvergleichen auf dieser Plattform wird zwischen Groß- und Kleinschreibung unterschieden.
Plattform
- Verwendung über: Invantive Cloud und die Invantive-Produkte auf Ihrem eigenen Computer oder Server.
- Art: Eine Anwendung, auf die über ihre API zugegriffen wird.
- Die Daten sind partitioniert, beispielsweise nach Unternehmen oder Verwaltungsbereich.
- Daten können sowohl geschrieben als auch gelesen werden.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Angaben
| Figure | Count |
|---|---|
| Tables | 104 |
| Columns | 2,665 |
| Tabellen mit Einfügung | 7 |
| Tabellen mit Aktualisierung | 0 |
| Tabellen mit Löschfunktion | 0 |
| Tabellen dokumentiert | 104 |
Poster zum Daten Muster
Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge
Admin
Admin_Badge_groupingsByBadges, Admin_Badge_typesByBadges, Admin_BadgesByBadges
Anderes
Admin (ohne Beziehungen)
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
Verwalter (ohne Beziehungen)
Sicherung (ohne Beziehungen)
Badge (ohne Beziehungen)
Kategorie (ohne Beziehungen)
E-Mail (ohne Beziehungen)
Gruppe (ohne Beziehungen)
Moderator (ohne Beziehungen)
NATIVEPLATFORMSCALARREQUESTS (ohne Beziehungen)
Standort (ohne Beziehungen)
System (ohne Beziehungen)
Etikett (ohne Beziehungen)
Beziehungen
- Admin_BadgesByBadges → Admin_Badge_groupingsByBadges (Schlüssel)
- Admin_BadgesByBadges → Admin_Badge_typesByBadges (Schlüssel)
- Posts → Categories (Kandidat, 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 (Kandidat, 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
Attribute
The attributes of this platform are on the page Attributes.
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: