While zooming the map, the current model switches to the selected size in the map. While dragging a model in the overview, the position of the model in the view also changes. Overview is a map helping navigate the model. Model tree holds all the tables in the model, including the tables used in each diagram.įrom Model tree you can easily copy the appropriate table to the chosen diagram. Diagram tree holds all the objects (tables, layers, notes, images and relations). You can have parts of the model in different diagrams. You can't have parts of the model in different diagrams. You can't have more than one table representation in the same diagram. Shortcuts provide another graphical representation of the same table. They are rectangles with a note for group description. From there you can find the table representation, reference, add/delete table and view. Navigation tree contains a list of all subject areas. You can manipulate the size of a subject area and drag the name of a subject area to any place you want: inside of a rectangle or outside the edge.
They are dashed rectangles that identify the tables, views, references and notes contained within. To group tables Vertabelo provides Subject areas. How table groupings are represented and defined within each tool is described below. SQL preview available after generating SQL/DDL script.Įach tool allows you to group tables in your design. You can access a SQL preview of a particular element.
You can manipulate the size of a table by dragging the corners and can move tables using mouse and arrows. You can edit the table structure in a Table Designer, where you can create, edit and drop:Īdditionally, Navicat enables to specify a character set and collation for table field. Primary key is set in Table properties and is also labeled in the diagram. You can create a new blank model or open an existing model.ĭatabase engine support can be changed during the designing process.Īfter creating a reference, the foreign key is automatically added with label FK in the table. While creating a diagram, you have access to the appropriate data type. Vertabelo supports a particular database from creation. create a new blank one with a specified database engine (PostgreSQL, MySQL, MS SQL Server, HSQL DB, Oracle, SQLite, IBM DB2)Īn Undo/Redo button enables you to quickly step back to a particular version of model.There are four ways to create a model in Vertabelo: Navicat Data Modeler Non-Commercial Edition US$ 79.Basic $12 monthly up to 20 models, 100 tables per model.
NAVICAT FOR SQLITE KEY FREE
NAVICAT FOR SQLITE KEY MAC OS X
In this article, I’ll make a comparison of two popular database modelers: Vertabelo in version 1.21.0 and Navicat Data Modeler in version 1.0.12.įeatures are listed in the left-hand column and each tool’s feature support is identified under the appropriate heading.
0 kommentar(er)
