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 documentation of the entire database like, the table- column name, column definition, and if it’s an id then how is it configured.
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 these numberical values signifies.
The example I shared above is one of the scenarios. But, more scenarios could come later hence I’m looking for a document where everything is properly defined.
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