https://answers.axonivy.com/questions/3284/where-to-get-an-entity-relation-diagram-erd-of-the-axon-ivy-system-db<p>Is there any schema documentation available that show the relations of the tables in the Axon.ivy system database?</p>enMon, 09 Sep 2019 04:24:35 -0400https://answers.axonivy.com/questions/3284/where-to-get-an-entity-relation-diagram-erd-of-the-axon-ivy-system-db/3966<p>Don't forget to mention <a href="https://dbeaver.io">dBeaver</a>, an eclipse based universal database client. It offers ERDs for all of the databases it supports, and comes in handy in order to have a common front end for various database systems.</p>phochstrMon, 09 Sep 2019 04:24:35 -0400https://answers.axonivy.com/questions/3284/where-to-get-an-entity-relation-diagram-erd-of-the-axon-ivy-system-db/3966https://answers.axonivy.com/questions/3284/where-to-get-an-entity-relation-diagram-erd-of-the-axon-ivy-system-db/3285<p>There is none in the official documentation. But you can use one of the tools that can generate such an ERD out of an existing installation. <a href="https://www.codediesel.com/data/5-tools-to-visualize-database-schemas/">https://www.codediesel.com/data/5-tools-to-visualize-database-schemas/</a></p> <p>For instance mysql workbench does that job nice and fast for mysql databases.<img alt="alt text" src="https://answers.axonivy.com/upfiles/mysqlWorkbench_erdReverseEngineering.png"></p> <p>Or MsSql server has this feature in the Diagrams section. <img alt="alt text" src="https://answers.axonivy.com/upfiles/mssql_erdDiagram.png"></p> <p>Here is a generated sample schema for 7.1.1. Generated with mysql workbench.</p> <p><img alt="alt text" src="https://answers.axonivy.com/upfiles/sysDb_711.png"></p>Reguel WermelingerThu, 24 May 2018 06:28:30 -0400https://answers.axonivy.com/questions/3284/where-to-get-an-entity-relation-diagram-erd-of-the-axon-ivy-system-db/3285