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:

データベース全体のドキュメント

コミュニティデータとレポート

JammyDodger 2023 年 7 月 21 日午後 3:35 5

コードを掘り下げる必要がない場合、データエクスプローラーツリーには便利な情報ボックスもあります。

トピック		返信	表示
Description of fields returned by Discourse API Development rest-api	5	1659	2020 年 11 月 6 日
User actions - action types Data & reporting sql-query	6	316	2024 年 9 月 21 日
Is there a document introducing the database schema design? Development	3	3270	2025 年 1 月 23 日
Discourse data analysis - Not able to understand some of the column names Support	3	601	2019 年 11 月 6 日
Documentation for features listed on about page? Feature	5	1274	2025 年 12 月 4 日

データベース全体のドキュメント

関連トピック