# Graphical overviews/diagrams for the Mautic database schema? **URL:** \ **Category:** General Discussion\ **Created:** [February 19, 2018, 11:16am UTC](https://forum.mautic.org/t/graphical-overviews-diagrams-for-the-mautic-database-schema/10248 "2018-02-19T11:16:49Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![tmg\_g4u](https://avatars.discourse-cdn.com/v4/letter/t/e36b37/32.png) [@tmg\_g4u](https://forum.mautic.org/u/tmg_g4u)\ **Post date:** [February 19, 2018, 11:16am UTC](https://forum.mautic.org/t/graphical-overviews-diagrams-for-the-mautic-database-schema/10248/1 "2018-02-19T11:16:49Z")
Hi, we’re looking for aid to delevopers new to Mautic, as a starting point to help them understand the Mautic database schema and its objects and relationships. Thus we’re searching for graphical overviews / diagrams or similar for the Mautic database schema, i.e. all the database objects (tables, fields) and their relationships. What I have in mind is someting like the output of SchemaSpy, a tool which generates a visual representation of the metadata of a database schema, in a browser-displayable format. Is there something available for Mautic? Haven’t found anything in the Mautic documentations. Thank you, Thomas ---
**Author:** ![petertl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/petertl/32/511_2.png) [@petertl](https://forum.mautic.org/u/petertl)\ **Post date:** [February 20, 2018, 3:08am UTC](https://forum.mautic.org/t/graphical-overviews-diagrams-for-the-mautic-database-schema/10248/2 "2018-02-20T03:08:38Z")
Does Mautic use foreign key constraints? If yes, it should not be a problem to reverse engineer the schema. ---
**Author:** ![deejmer](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/deejmer/32/588_2.png) [@deejmer](https://forum.mautic.org/u/deejmer)\ **Post date:** [June 27, 2018, 6:36pm UTC](https://forum.mautic.org/t/graphical-overviews-diagrams-for-the-mautic-database-schema/10248/3 "2018-06-27T18:36:34Z")
This is of interest to me as well. I’d like to build more robust reporting outside of Mautic and being able to see data structures would take hours off of the process or reverse engineering everything. ---
**Author:** ![dbhurley](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dbhurley/32/2_2.png) [@dbhurley](https://forum.mautic.org/u/dbhurley)\ **Post date:** [June 28, 2018, 1:34pm UTC](https://forum.mautic.org/t/graphical-overviews-diagrams-for-the-mautic-database-schema/10248/4 "2018-06-28T13:34:17Z")
Let me know if these are helpful! [https://drive.google.com/file/d/1jZx\_y2e7aJQb0PtPzJ3xX6SJ8tOl6MnW/view?usp=sharing](https://drive.google.com/file/d/1jZx_y2e7aJQb0PtPzJ3xX6SJ8tOl6MnW/view?usp=sharing) [https://drive.google.com/file/d/102OCeBIe-hWpiD9SdlZbg1QmADNQsf0H/view?usp=sharing](https://drive.google.com/file/d/102OCeBIe-hWpiD9SdlZbg1QmADNQsf0H/view?usp=sharing) 🙂 ---
**Author:** ![dbhurley](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dbhurley/32/2_2.png) [@dbhurley](https://forum.mautic.org/u/dbhurley)\ **Post date:** [June 28, 2018, 1:39pm UTC](https://forum.mautic.org/t/graphical-overviews-diagrams-for-the-mautic-database-schema/10248/5 "2018-06-28T13:39:35Z")
Or if you prefer just a simple graphic: ![Mautic Database Schema Diagram](http://i.dbhurley.com/0u0V0o2p0u2l/mautic_db_schema.png) ---
**Author:** ![deejmer](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/deejmer/32/588_2.png) [@deejmer](https://forum.mautic.org/u/deejmer)\ **Post date:** [June 28, 2018, 2:42pm UTC](https://forum.mautic.org/t/graphical-overviews-diagrams-for-the-mautic-database-schema/10248/6 "2018-06-28T14:42:38Z")
Wow, ask and ye shall receive…Thank you for sharing this! ---
**Author:** ![ebehlmann](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ebehlmann/32/4151_2.png) [@ebehlmann](https://forum.mautic.org/u/ebehlmann)\ **Post date:** [December 23, 2020, 9:31pm UTC](https://forum.mautic.org/t/graphical-overviews-diagrams-for-the-mautic-database-schema/10248/7 "2020-12-23T21:31:34Z")
I know this is an old discussion, but if anyone still needs this - @dbhurley’s looks great, but I wanted to create a version that spaced out the tables a bit more to help me see the relationships more clearly. This was created by doing an import into Lucidchart and then doing a lot of rearranging, plus adding a few notes: [https://lucid.app/publicSegments/view/25fada45-fe09-408f-a0ec-05e6da7260dd/image.png](https://lucid.app/publicSegments/view/25fada45-fe09-408f-a0ec-05e6da7260dd/image.png)