Need Assistance to Dump Relationships or Foreign Keys

[wlieske]

I am currently trying to normalize my organization's data on Espo, but dumping the SQL database does not seem to provide the schema, which appears to be handled via Espo itself.

I have two questions regarding this:
1. How can I dump the schema for Espo and feed it to an ER diagram for easier analysis?
2. Is it considered best practice to handle relationships in Espo?

[victor]

If I understand you correctly, you are asking about the functionality of different types of Reports: https://docs.espocrm.com/user-guide/reports/, which can be used if you have the Advanced Pack extension.

[wlieske]

If I understand you correctly, you are asking about the functionality of different types of Reports: https://docs.espocrm.com/user-guide/reports/, which can be used if you have the Advanced Pack extension.

These are in a similar vein but not what I am looking for.

I'm trying to get something akin to a visual representation of the data you see in Administration > Entity Manager > [Entity Name] > Relationships, and for every entity at once.

[wlieske]

It would also be acceptable to dump the relationships for every entity.

[shalmaxb]

Perhaps this helps:
1. Go to custom->Espo->Custom->Resources->metadata->clientDefs and copy the JSON content of your entity.
2. Go to this website: https://jsoncrack.com/editor and insert the json. You will get a diagram of the content.

If you want a kind of table for your relationships, you can get this from AI (e.g. Gemini).