I’m study how discourse was implemented, and I hope to understand each fields in schemas of discourse database, so that I can quickly know the meaning of things done by ruby codes.Is there a suite document for me?

The best source of schema information is probably the annotations at the bottom of fiiles in the app/models directory. For example, the posts table columns are app/models/post.rb e7bad9f05 # == Schema Information # # Table name: posts …

Been a while here, but if you have the Data Explorer Plugin, you can also use the api to fetch everything: /admin/plugins/explorer/schema.json.

Is there a document introducing the database schema design?

Development

TallTrees November 30, 2020, 2:29pm 3

The Discourse Data Explorer might be worth a look too. It has the tables and columns listed out.

Topic		Replies	Views
Database's Data Model? Support	7	4137	August 6, 2020
Is there a data map for Discourse data? Data & reporting	2	525	September 19, 2023
Where can we get discourse database schema design diagram? Development	3	1915	July 17, 2022
Documentation of the entire database Data & reporting	5	939	July 24, 2023
A data model to make perusing the database easier Feature data-explorer	25	2541	June 25, 2025

Is there a document introducing the database schema design?

Related topics