# Could anyone give a database schema dump?
**URL:** https://meta.discourse.org/t/could-anyone-give-a-database-schema-dump/142749
**Category:** Support
**Created:** [February 27, 2020, 9:00am UTC](https://meta.discourse.org/t/could-anyone-give-a-database-schema-dump/142749 "2020-02-27T09:00:02Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@fzyzcjy](https://meta.discourse.org/u/fzyzcjy)
#### Post date: [February 27, 2020, 9:00am UTC](https://meta.discourse.org/t/could-anyone-give-a-database-schema-dump/142749/1 "2020-02-27T09:00:03Z")
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!
---
### Author:  [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [February 27, 2020, 2:48pm UTC](https://meta.discourse.org/t/could-anyone-give-a-database-schema-dump/142749/6 "2020-02-27T14:48:34Z")
Hi @fzyzcjy,
Here is the schema: [dump.txt](https://meta.discourse.org/uploads/short-url/mTnNOtCzylGICU8AYSauUkfemeq.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.
---
### Author:  [@fzyzcjy](https://meta.discourse.org/u/fzyzcjy)
#### Post date: [February 29, 2020, 2:09am UTC](https://meta.discourse.org/t/could-anyone-give-a-database-schema-dump/142749/7 "2020-02-29T02:09:35Z")
Thank you very much!! I will also have a look at RubyMine if possible 🙂
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [March 30, 2020, 2:09am UTC](https://meta.discourse.org/t/could-anyone-give-a-database-schema-dump/142749/8 "2020-03-30T02:09:50Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.