Database Modeling with dbdiagram.io
Today I would like to briefly introduce you to a Web application, which I have been stumpled across. I’ve tried several tools for db modeling, some more and some less appealing. Well, the tool doesn’t offer explicit ER modeling, but a SQL-like structure and allows you to import and export directly to SQL and other formats. You can find the app I’m talking about on dbdiagram.io. The website offers a simple graphical interface, which includes a code editor and a graphical representation of the table structure. You can edit your table structure directly in the code editor. You can then create relations between the tables using the drag-and-drop function. These are represented in the editor by the schema ref “table_a”. “column_a” > “table_b”. “column_b”. Cardinalities are represented by > (n:1) , < (1:n) and - (1:1). ...