# 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:** 1
**Showing post:** 6

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@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")

</div>

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.

---

_[View the full topic](https://meta.discourse.org/t/could-anyone-give-a-database-schema-dump/142749)._