MySQL database modeling
In Moon Modeler you can easily draw MySQL structures.
Database tables are displayed as graphical boxes with all column fields.
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.
If you wish to see that the content of the JSON is an array of documents, turn the Array switch on.
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.
# The end of the MySQL database modeling page