Tag: mariadb

To create a new relationship between two tables, click Relationship on the toolbar and then click parent and child tables in your diagram.

In this example, click table customer and then table order.

The new relationship line appears in the diagram and column customer_id is added to the child table order automatically.… Read the rest

In MariaDB datatypes Enum and Set require additional specification. To define values for Enum/Set, expand column detail and specify necessary values in fields Enum/Set and Default value.

Usage:

#

Diagrams can also contain graphical representatives of various database objects. The following objects can be added to MariaDB diagrams:

• Views
• Stored procedures
• Functions
• Triggers
• Other objects (Events, Table check constraints, User/Role definitions)

Each object has its default color that can be changed. Objects can be re-positioned, aligned etc.

Usage:

To add a new object, click Other on the toolbar or right-click the diagram area and choose the desired object type, for example, Function.… Read the rest

To generate SQL script from your project click the Script icon on the main toolbar. The SQL Script modal form opens.

Click Save Script and select a location where the file should be stored.

Generation settings

You can control how the script will be generated on the Generation settings tab

Order of items

The order in which the objects will be in the resulting SQL script can be modified on the Order items tab.… Read the rest

To add a new index to a database table, edit your table, navigate to tab Indexes and click + Add Index.

Then it is necessary to add columns to the index. Click +Add Column to Index to display a dropdown with a list of available column names. Pick a column and then specify other index properties.… Read the rest

Primary keys

To define or edit table keys, edit your table and navigate to tab Keys or change values directly in the right-side panel in section Keys.

A primary key exists in every table. If you wish to add a new alternate key, click the button + Add Key.… Read the rest

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.… Read the rest