Quick start guide for Sequelize schema design in Meteor Modeler.
- New project
- Sequelize models
- Code generation
- Import from Luna Modeler
1. New project
To create a new project, click the New item on the toolbar and select the Sequelize project type.
2. Sequelize models
To add a new Sequelize model to your design, click the Model item on the toolbar and then click the main diagram area.
The new object appears in the diagram. You can edit Sequelize model properties via right-side panel:
If you prefer modal dialogs, double click an item on a diagram or open popup and choose Edit.
In section Details, collection settings can be specified.
In section Fields, you can add new fields to collections to your Sequelize schema design. Specify new field name, data type, parameter and click Add.
REQ represents the required field.
To access area where Sequelize field specifics can be modified, click the arrow left to the field name.
3. Sequelize associations
Associations are represented by links between Sequelize models. New associations can be created by clicking the HasOne or BelongsTo icons on the main toolbar.
Each association can be configured as a one-way association as well as a 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.
Each type of association is graphically represented in the diagram by a slightly different line.
- Has one/Has many – solid line.
- Belongs to/Belongs to many – dashed line.
- Both – dash-dotted line
4. Code generation
To preview the validation script for your MongoDB schema design, click the Script tab on collection detail.
To save scripts to files, click the Script icon on the toolbar and then click Save script.
5. Import from Luna Modeler
Creating a Sequelize schema from existing databases can be done thanks to the integration with Luna Modeler. The following steps describe how to load existing database structures and create a Sequelize project.
- Reverse engineer an existing database structure using Luna Modeler
- In Luna Modeler copy selected tables
- Run Meteor Modeler and create a new empty project
- Paste the selected object to your Sequelize project
- Objects will be converted to Sequelize automatically
Enjoy your Sequelize schema design modeling! Thanks for reading!