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? thanks

This has been asked before, take a look at: [image] Is there a document introducing the database schema design? Development 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? [image] Using ERD to Create Entity-Relationship Diagrams for Discourse Development Hey, 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? Thank… [image] A data model to make perusing the database easier Feature You can generate one with relationships with rails-erd: GitHub - voormedia/rails-erd: Generate Entity-Relationship Diagrams for Rails applications [erd2] Not sure how useful this is though

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 users, user_options, api_keys, user_api_keys, user_auth_tokens, user_auth_token_logs, notifications thanks

thanks this is the most useful of the links you shared [image] A data model to make perusing the database easier Feature You can generate one with relationships with rails-erd: GitHub - voormedia/rails-erd: Generate Entity-Relationship Diagrams for Rails applications [erd2] Not sure how useful this is though

Where can we get discourse database schema design diagram?

Development

niledebunkr July 17, 2022, 6:30am 4

thanks this is the most useful of the links you shared

Topic		Replies	Views
Is there a data map for Discourse data? Data & reporting	2	560	September 19, 2023
Using ERD to Create Entity-Relationship Diagrams for Discourse Development	2	1479	May 21, 2021
Is there a document introducing the database schema design? Development	3	3446	January 23, 2025
A data model to make perusing the database easier Feature data-explorer	25	3006	June 25, 2025
Could anyone give a database schema dump? Product Support	2	1970	February 29, 2020

Where can we get discourse database schema design diagram?

Related topics