MariaDB database modeling

In Moon Modeler you can easily draw MariaDB 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.

Mariadb database modeling

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

Array JSON

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

Mariadb database modeling and json

 

 # The end of MariaDB database modeling page

Copyright: 2019 Datensen. All rights reserved.
This website is not endorsed by MongoDB, Inc.
This website uses cookies to ensure you get the best experience on our website.