PostgreSQL database modeling

In Moon Modeler you can easily draw database structures for PostgreSQL. Many PostgreSQL specifics are supported, including visual definition of composite types or JSON objects. Let's start with the basics.

Database tables

Database tables are displayed as graphical boxes with all table columns. In the example below you will see table cart with three table columns: id, customer_id and items.

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 cart in column items.

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 column contact of datatype contact (JSON object named contact).
Inside the contact JSON object, you can find another JSON structure - address.

 # The end of the PostgreSQL database modeling page