Where can we get discourse database schema design diagram?

Development

AI-generated summary

The discussion revolves around obtaining the Discourse database schema design diagram. niledebunkr is seeking a way to get the db schema diagram or a ready-to-import SQL dump file to research table relationships. They found a shared schema diagram by @Falco, but it didn’t work due to extensions, users, and functions.

niledebunkr specifically wants to know the primary keys, foreign keys, and relationships between certain tables. merefield provided links to previous discussions on the topic, including a data model to make perusing the database easier, which niledebunkr found particularly useful.

1

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

2

This has been asked before, take a look at:

3

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

4

thanks this is the most useful of the links you shared