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:

#
Read articles about ERD creation in Moon Modeler. Tips and tricks, articles about how to create ER diagrams for various databases.
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:
Each object has its default color that can be changed. Objects can be repositioned, aligned, enlarged, 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. New modal opens. Click Save Scripts and select a location where the files should be stored.
Option Overwrite existing files allows you to ignore existing scripts and overwrite them without getting a warning.
#
All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select MariaDB and enter the connection details.
When you are finished, click the Save Connection button.
Your new MariaDB connection will appear in the list of all database connections.… Read the rest
Quick-start guide for MySQL DB database design
To create a new project, click the New icon on the main toolbar and select the MySQL project type.
New database tables can be added into projects by clicking Table on the toolbar and then by clicking the main diagram area.… 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
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 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.… Read the rest
Moon Modeler is a data modeling tool for MongoDB, PostgreSQL, MariaDB, MySQL, SQLite, Mongoose and GraphQL. It can also be used for solutions like Cosmos DB or Heroku Postgres and others. The software belongs to the data modeling and schema design tools category and can be used to model hierarchical database structures.… Read the rest
Quick start guide for MariaDB database design in Moon Modeler.
To create a new project, click New on the toolbar and select the MariaDB project type.
New database tables can be inserted into projects by clicking Table on the toolbar and then by clicking the main diagram area.… Read the rest