Could anyone give a database schema dump?

Product Support

AI-generated summary

The discussion revolves around a request for a database schema dump. fzyzcjy asks for the SQL schema dump as they are unable to install the environment. Falco responds by providing the schema dump (dump.txt) and notes that most foreign keys are defined in Ruby, not in the SQL dump. fzyzcjy thanks Falco and expresses interest in exploring RubyMine’s database schema generation feature.

1

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!

6

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 better for our use case.

7

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