Where can we get discourse database schema design diagram?

dev
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 Likes
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

1 Like