Discourse Data Model
Discourse es una plataforma de debate de código abierto para foros, salas de chat y la creación de comunidades.
Configura esta plataforma en Invantive Cloud: https://cloud.invantive.com/discourse
Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.
Plataforma
- Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
- Tipo: una aplicación a la que se accede a través de su API.
- Los datos se agrupan por categorías, como por empresa o por administración.
- Los datos se pueden leer y escribir.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Cifras
| Figure | Count |
|---|---|
| Tables | 104 |
| Columns | 2,665 |
| Tablas con inserciones | 7 |
| Tablas con actualización | 0 |
| Tablas con la instrucción «DELETE» | 0 |
| Tablas documentadas | 104 |
Póster del Modelo de Datos
En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.
El póster en forma de texto: tablas por tema y sus relaciones
Admin
Admin_Badge_groupingsByBadges, Admin_Badge_typesByBadges, Admin_BadgesByBadges
Otro
Admin (sin relaciones)
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
Administrador (sin relaciones)
Copia de seguridad (sin relaciones)
Badge (sin relaciones)
Categoría (sin relaciones)
E-mail (sin relaciones)
Grupo (sin relaciones)
Moderador (sin relaciones)
NATIVEPLATFORMSCALARREQUESTS (sin relaciones)
Sitio (sin relaciones)
Sistema (sin relaciones)
Etiqueta (sin relaciones)
Relaciones
- Admin_BadgesByBadges → Admin_Badge_groupingsByBadges (clave)
- Admin_BadgesByBadges → Admin_Badge_typesByBadges (clave)
- Posts → Categories (candidato, 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 (candidato, 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.
Tablas
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
Atributos
The attributes of this platform are on the page Attributes.
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: