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.