Not all editors allow you to visualize the mappings that exist in the database, but there are some who do it, so as a developer you should get programs that make your work easier.
You can not lose the overview, the bigger a project grows or you need better structures. This is not only true for programs you use but much more about the software you develop. Again and again you see that projects are underestimated and not created with the right structures, this has the consequence that the project gets completely out of control, but the development is published in spite of everything. No matter which system you set up or left to others, each system can be optimized and freed of unnecessary ones.
Even giant companies are using an open source CMS which in my opinion is absurd for a company, as this company either has no development department or does not appreciate it. After all, a company should have its own system and thus be independent, efficient, optimally flexible in order to be able to react to all changes in the rapidly growing web. Every system can be documented, with the right tools you can do everything without a lot of work. So any developer who comes to this can still understand everything, as e.g. every function he moves with the mouse fades in a function docu;)
But here is a paid program PhpStorm what I like to use to visualize ORM (object-relational mapping), because I have not found a free program for it or know.
MySQL database connect
You can connect any number of databases, even those that are not exactly your current project. To access the database, proceed as follows on the screenshot.
Now you can see the database listing which should be empty the first time you call this or restart PhpStorm. Now go to the top left on the plus sign with the arrow down, see screenshot.
If you are now on e.g. MySQL clicks will pop up a window to enter the database connection. Here you fill out as well as with PhpMyAdmin the user data and additionally you can specify a database directly and then confirm with OK.
Visualization of the database
Now that you have done this, you can right-click on the created database and select the following.
Mapping in the database
Now the visualization of your database will appear and be mapped, you can see the mapping and more Primary Keys, One To Many, Many To One, or Many To Many. Among other things, you can also read database tables from the edit and edit directly.
That's all, more is not necessary to make sure that the desired connection has been made, you can use this very well.