Can anyone help with a way to get the db schema diagram for discourse? showing the table relationships
Will like to research the table relationships and all
The db dump file is not ready to be imported to draw up the schema diagram
like the one
@Falco shared here Could anyone give a database schema dump? - #6 by Falco when i tried to import it and run the sql file, it doesn’t work, partly because of the extensions, users and functions in the file
so anyone able to share there schema diagram? or a ready to use sql dump file we can import?
This has been asked before, take a look at:
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?
Today I was playing around with ERD and installed it in my Discourse dev setup on the mac and ran it. Was a bit buggy and had to reload it a few times, but was able to get it going, but needs work.
[Screen Shot 2020-08-17 at 11.37.06 AM]
[Screen Shot 2020-08-17 at 1.02.56 PM]
Obviously it’s huge, and needs work.
Is anyone else on the Discourse dev team or plugin developers are using ERD or another package similar to ERD to create entity-relationship diagrams for Discourse?
is it possible to get a ready to import sql dump file?
it seems the ruby dependency is touch
for example will like to know what are primary keys and foreign keys et cetera
i am more interested in the relationships and connections between these tables
thanks this is the most useful of the links you shared