I am trying to identify links in the existing CMS to integrate it into a third-party solution, I encountered the problem of the inaccessibility of building links in the ACL. In this connection, I want to learn how to get a relational table schema in order to more quickly orient and integrate this system. So far I have found only this one https://www.mysql.com/products/workbench/design/

But there is not a word about generation based on an already existing base, so that you can more conveniently see the connection.

  • there is not a word about generation based on an already existing database, so that you can more conveniently see the connection. dev.mysql.com/doc/workbench/en/wb-reverse-engineer-live.html - Akina
  • Sadness trouble, and in general was someone a similar experience? - Basil Jimmy
  • The help describes the process of building an EER-diagram for a training database sakila. I see no reason to believe that the same process will not work for another DB ... - Akina

1 answer 1

You can use the dbForgeStudio for MySQL tool to build a MySQL database diagram.

1) Connect to the database;

2) Select the menu "Database" -> "Database Diagram"

my

3) Drag the database into the chart working area

The solution is under Windows, but there is a launch option in Linux.

There is also a tool called SchemaSpy . There is a description of use in Ubuntu.