Software to Create Mysql DB Relationship and Structure

Asked

Viewed 375 times

1

I have a project in mind and would like to map the data and create the relationship of the tables, even if only visually before developing the pages, could refer me a software (I think the concept is MER) preferably free that helps me visually create these tables and the relationship between them?

I would like something just to create the fields of the tables and the relationship between them, nothing complex like Microsoft Visio, no diagrams.

mysql database relationship
  • 1

    I like this tool: https://www.draw.io/

  • Too complex for my first experience, I would like something just to create the table fields and relate the tables to each other, nothing so complex, thanks for the tip, I’ll save the URL to learn more about it. Looks like Microsoft Visio right. Thanks.

  • 1

    If you are using Mysql Workbench, it itself has this type of functionality, to generate the diagramming of your database

  • I will download it, I’ve used for bank migration, but the relationship part never. Thanks for the tip.

  • Using this free online draw.io tool, just click on file > new. Select the Software tab and you can load an example ready, to start something already ready. The interesting thing about it is that there is already integration with several tools to save your diagrams and flowcharts. Like Gdrive and Github.

  • If you want, you can also use Phpmyadmin to generate the diagram..... In fact there are several ways to do it....

  • In Phpmyadmin: Select the database you want to create the diagram, and look for the "More" > "Designer" tab: https://i.stack.Imgur.com/lFGgy.png

Show 2 more comments

1 answer

1


If your intention is to use Mysql, the Mysql Workbench might be a good alternative. It is free (GPL license) and has good features for you to create the logical model and export as physical model or vice versa. It has versions for Windows, Linux and OS X. After installing, click File > New Model > Add Diagram.

  • Well, Workbench for the tips and for what I read is really what I need, thank you.

Browser other questions tagged mysql database relationship

You are not signed in. Login or sign up in order to post.