# A data model to make perusing the database easier

**URL:** https://meta.discourse.org/t/a-data-model-to-make-perusing-the-database-easier/223486
**Category:** Feature
**Tags:** data-explorer
**Created:** [April 6, 2022, 11:05am UTC](https://meta.discourse.org/t/a-data-model-to-make-perusing-the-database-easier/223486 "2022-04-06T11:05:15Z")
**Posts on this page:** 6
**Page:** 2

<div class="post-metadata">

### Author: ![niledebunkr](https://avatars.discourse-cdn.com/v4/letter/n/8491ac/32.png) [@niledebunkr](https://meta.discourse.org/u/niledebunkr)
#### Post date: [July 19, 2022, 2:35pm UTC](https://meta.discourse.org/t/a-data-model-to-make-perusing-the-database-easier/223486/26 "2022-07-19T14:35:12Z")

</div>

thanks a lot @Falco

so `users` and `user_options` are the only tables with 1-1 in the whole schema?  
any other tables with 1-1?

asking because wanted to see the real use-cases of 1-1 table relationships as there are not many to check with online

---

<div class="post-metadata">

### Author: ![Dante\_Dante](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dante_dante/32/294295_2.png) [@Dante\_Dante](https://meta.discourse.org/u/Dante_Dante)
#### Post date: [February 20, 2023, 4:01pm UTC](https://meta.discourse.org/t/a-data-model-to-make-perusing-the-database-easier/223486/27 "2023-02-20T16:01:32Z")

</div>

Hey @niledebunkr , @lju where you able to find a solution, I would be very interested to see the result if it is possible, thank in advance

---

<div class="post-metadata">

### Author: ![Dante\_Dante](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dante_dante/32/294295_2.png) [@Dante\_Dante](https://meta.discourse.org/u/Dante_Dante)
#### Post date: [May 25, 2023, 12:31pm UTC](https://meta.discourse.org/t/a-data-model-to-make-perusing-the-database-easier/223486/28 "2023-05-25T12:31:34Z")

</div>

Hey is it possible to delete some tables and leave only the main ones using rails-erd? I am only interested to get the main tables for a research regarding discourse.

---

<div class="post-metadata">

### Author: ![Canapin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/canapin/32/119591_2.png) [@Canapin](https://meta.discourse.org/u/Canapin)
#### Post date: [May 25, 2023, 12:57pm UTC](https://meta.discourse.org/t/a-data-model-to-make-perusing-the-database-easier/223486/29 "2023-05-25T12:57:19Z")

</div>

Hi!  
How would you define “main” in this context? 🤔

---

<div class="post-metadata">

### Author: ![Dante\_Dante](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dante_dante/32/294295_2.png) [@Dante\_Dante](https://meta.discourse.org/u/Dante_Dante)
#### Post date: [May 25, 2023, 1:44pm UTC](https://meta.discourse.org/t/a-data-model-to-make-perusing-the-database-easier/223486/30 "2023-05-25T13:44:14Z")

</div>

Main table referes to User, Topic, Post, Reply, Group, Poll ,PollOption , pollVote, Draft, Message, Badge, Category, Search, Invite and Tag

I am trying to draw a small data model of Discourse (based on the tables mentioned), I only need to cover these components

---

<div class="post-metadata">

### Author: ![SStrong](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@SStrong](https://meta.discourse.org/u/SStrong)
#### Post date: [June 25, 2025, 12:44pm UTC](https://meta.discourse.org/t/a-data-model-to-make-perusing-the-database-easier/223486/31 "2025-06-25T12:44:29Z")

</div>

Am I to assume that this never became a reality? Having something to understand relationships would be super useful

[Previous page](https://meta.discourse.org/t/a-data-model-to-make-perusing-the-database-easier/223486.md?page=1)