MySQL database modeling

In Moon Modeler you can easily draw MySQL structures.

Database tables

Database tables are displayed as graphical boxes with all column fields.

JSON

One of the main advantages of Moon Modeler is the possibility to visually display nested structures.
The structures are displayed inside tables and also as separate graphical objects. Modifications made to JSON structures are automatically propagated to all table columns where the JSON structure is used.

See the item JSON structure. It is used in table order in column order_item.

JSON defined for MySQL

If you wish to see that the content of the JSON is an array of documents, turn the Array switch on.

JSON arrays in MySQL projects

One JSON can appear inside another JSON. See table customer. The table contains the column contact of datatype contact (JSON named contact).
Inside the contact JSON object, you can find another JSON structure – address.

MySQL ERD with JSON

 # The end of the MySQL database modeling page