Sequelize schema design

Quick start guide for Sequelize schema design in Meteor Modeler.

  1. New project
  2. Sequelize models
  3. Associations
  4. Code generation

1. New project

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

2. Sequelize models

To add new Sequelize model to your design, click the Model item on toolbar and then click the main diagram area.

Sequelize schema design - new model

New object appears in the diagram. You can edit Sequelize model properties via Right Side panel:

Sequelize schema design - model details

If you prefer modal dialogs, double click an item on diagram or open popup and choose Edit.

Model properties

In section Details collection settings can be specified.

Fields

In section Fields you can add new fields to collections to your Sequelize schema design. Specify new field name, datatype, parameter and click Add.
REQ represents required field.

Sequelize schema design - model properties

Field specifics

To access area where Sequelize field specifics can be modified, click the arrow left to the field name.

Field details

3. Sequelize associations

Associations are represented by links between sequelize models. New associations can be created by cliking the HasOne or BelongsTo icons on the main toolbar.

Sequelize - new model

Each association can be configured as one-way association as well as bi-directional association.
If you wish to define association as Has One and Belongs To at the same time, draw just one line and define details on the Association properties modal form.

Sequelize - new model

Each type of association is graphically represented in the diagram by a silghtly different line.

  • Has one/Has many - solid line.
  • Belongs to/Belongs to many - dashed line.
  • Both - dash-dotted line

Sequelize - new model

Cardinality: See how cardinality is solved in Moon Modeler for MongoDB. The visualization is identical.

4. Code generation

To preview validation script for your MongoDB schema design, click the Script tab on collection detail.

To save scripts to files, click the Script icon on toolbar and then click Save script.

generated sequelize scripts

This is the end of the Sequelize schema design page. Thanks for reading!

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.