Hi, I’ve recently started performing analytics on the Community feature of our product. In the plugins, I can see the codes and the list of tables, which expands to the column name and type. However, there are many columns that store data directly set by the ‘Discourse’ team. So, is there any docum…

There’s also a handy info box in the data explorer tree as well if you didn’t want to go digging in the code: [user_action - action_type]

[图片] Abhishek Agarwal: is there any documentation of the entire database We do not keep any documentation of our database and its usages. The only form of documentation we keep is https://docs.discourse.org/ , which is solely for our API. Perhaps it would be more productive to expand on what…

Hey, thanks for the reply. My analysis involves segregating the responses (likes, posts, etc) by user type (admins/customers). Also, there’s one table named ‘user_actions’ which has a column named ‘action_type’. This column contains numerical values like 1,2,3… upto 15. But, there’s no mention what…

I think it would help if you have someone on your side who may have some understanding of Rails. The database records you talk about typically maps to an ActiveRecord model in https://github.com/discourse/discourse/tree/main/app/models [图片] Abhishek Agarwal: This column contains numerical value…

Both are useful solutions, but can only mark one as a ‘Solution’ so selected the easier one, however having the code directory will be useful in future deep dives. Thanks @JammyDodger and @nat :smile:

整个数据库的文档

社区数据与报告

nat (Natalie T) 2023 年7 月 21 日 13:43 2

我们不保留数据库及其用法的任何文档。

我们保留的唯一文档形式是 https://docs.discourse.org/，这仅用于我们的 API。

也许更具成效的是详细说明您正在进行的分析类型。

1 个赞

话题		回复	浏览量
Description of fields returned by Discourse API Dev rest-api	5	1614	2020 年11 月 6 日
User actions - action types Data & reporting sql-query	6	253	2024 年9 月 21 日
Is there a document introducing the database schema design? Dev	3	3240	2025 年1 月 23 日
Discourse data analysis - Not able to understand some of the column names Support	3	590	2019 年11 月 6 日
Documentation for features listed on about page? Feature	5	1251	2025 年12 月 4 日

整个数据库的文档

相关话题