MongoDB ER diagram graphics

Settings for MongoDB ER diagram graphics can be defined on two levels in Moon Modeler. On a project level and on a selected object level.

Project graphics

Click the MongoDB ER diagram area to make sure no object is selected. Then change the colors in section Graphics. Alternatively, edit Project properties and specify settings on tab Graphics of the modal form.… Read the rest

What is Entity Relationship Diagram (ERD)?

Entity relationship diagram describes the structure of the database. The entity relationship diagram shows entities (tables in relational databases) and relationships between tables that exist in the database. For a good database design, it is very important to have an entity relationship diagram.

In an entity relationship diagram, the basic elements are:

  • Entities (tables)
  • Attributes (table columns)
  • Relationships (relationships between tables)

Why create entity relational diagrams?

Read the rest

Free ER diagram tool?

Looking for a free ER diagram tool? There are many on the market and Moon Modeler is one of them.
This free ER diagram tool can be used to visually define smaller database structures for relational database systems such as MariaDB, MySQL, PostgreSQL, SQLite, and NoSQL databases such as MongoDB, or object-document mappers such as Mongoose.… Read the rest

Import & Visualization of existing SQLite databases

Connection to SQLite database is not classic, so you will not find the option of this database in the connections section. To visualize an existing SQLite database structure, go to the Projects section and import SQLite from a file.

Import file - SQLite

Select the database file. In this example, we will load the chinook.db… Read the rest

SQLite database design

Quick start guide for SQLite database design in Moon Modeler.

  1. New project
  2. Tables and columns
  3. JSON datatypes
  4. Relations and foreign keys
  5. Code generation

1. New project

To create a new project, click New on the toolbar and select the MariaDB project type.

2. Database tables and columns

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

MySQL database modeling

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