Graphical overviews/diagrams for the Mautic database schema?

General Discussion
1

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

2

Does Mautic use foreign key constraints? If yes, it should not be a problem to reverse engineer the schema.

3

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.

4

Let me know if these are helpful!

https://drive.google.com/file/d/1jZx_y2e7aJQb0PtPzJ3xX6SJ8tOl6MnW/view?usp=sharing
https://drive.google.com/file/d/102OCeBIe-hWpiD9SdlZbg1QmADNQsf0H/view?usp=sharing

:slight_smile:

1 Like
5

Or if you prefer just a simple graphic:

Mautic Database Schema Diagram

6

Wow, ask and ye shall receive…Thank you for sharing this!

7

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