Could you please give a dump of the SQL schema, because my computer cannot install the environment but I really want to know how the database schema is designed (since this project is sooooo famous and wonderful!) Thanks for the wonderful open-source application!

Hi @fzyzcjy , Here is the schema: dump.txt (274.1 KB) Just be aware that most of the “Foreign Keys” are only defined in Ruby, so a pure SQL dump doesn’t give you much to go on. Some tools, like JetBrain’s RubyMine, can generate a database schema which leverages Ruby relations, which would be bette…

Could anyone give a database schema dump?

Product Support

fzyzcjy (fzyzcjy) February 29, 2020, 2:09am 7

Thank you very much!! I will also have a look at RubyMine if possible

Topic		Replies	Views
Where can we get discourse database schema design diagram? Development	3	2029	July 17, 2022
Is there a document introducing the database schema design? Development	3	3414	January 23, 2025
Is there a data map for Discourse data? Data & reporting	2	555	September 19, 2023
Use a postgres schema Self-hosting	0	546	July 13, 2020
Database's Data Model? Product Support	7	4252	August 6, 2020

Could anyone give a database schema dump?

Related topics