Table Designer. Table Designer is the basic Navicat tool for working with tables. It allows you to create, edit and drop table's fields, indexes, foreign keys, and much more. In the Fields tab, you can search a field name by choosing Edit -> Find or pressing CTRL+F. Note: The tabs and options in the designer depend on the server type and version.
Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connector. Delete Vertex Delete a vertex on a foreign key connector. Delete All Vertices Delete all vertices on a foreign key connector. Go to Source Go to and select the source (child) table. Go to Target Go to and select the target (parent) table. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – Logical Models Create Logical Models Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, select File -> New Model from the menu bar. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model: Import from Database - reverse engineer from existing databases/schemas or ODBC data source. Model Conversion - convert from a physical/conceptual model. Add Entities to Logical Model To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you right-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in the canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color ...
Table Designer. Table Designer is the basic Navicat Data Modeler tool for working with tables. It allows you to create, edit and drop table's fields, indexes, foreign keys, and much more. Note: The tabs and options in the designer depend on the diagram database type and version you are chosen. In the Fields tab, you can search a field name by pressing CTRL+F. Add Views Add a View to a Physical Model To add a new view, click the View button from the toolbar and click anywhere on the canvas. To add an existing view from the Explorer's Model tab, simply drag and drop the selected view from the Model tab to the canvas. Note: If you right-click the view connector, you can choose to add or delete vertices and change its color, or go to the source view or the target table. The pop-up menu options of the view object in canvas include: Option Description Design View Edit the view structure in a View Designer. Add Related Objects Add all related tables/views to the selected view. Cut Remove the view from the diagram and put it on the clipboard. Copy Copy the view from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Views Select all views in the diagram. Delete Delete a view from the diagram or from both diagram and model. Rename Change the name of the view. Color Change the color of the view. Size to Fit Resize the view automatically to fit its contents. Bring to Front Bring the view to the foreground. Send to Back Move the view to the background. View Designer View Designer is the basic Navicat Data Modeler tool for working with views. In View Designer, you can build the views visually using View Builder or edit the view's Definition directly.
Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connecter. Delete Vertex Delete a vertex on a foreign key connecter. Delete All Vertices Delete all vertices on a foreign key connecter. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – Logical Models Create a Logical Model Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, select File -> New Model from the main menu. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model: Import from Database - reverse engineer from existing databases/schemas or ODBC data source. Model Conversion - convert from a physical/conceptual model. Add an Entity to a Logical Model To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you right-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front ...
Table Designer. Table Designer is the basic Navicat Data Modeler tool for working with tables. It allows you to create, edit and drop table's fields, indexes, foreign keys, and much more. Note: The tabs and options in the designer depend on the diagram database type and version you are chosen. In the Fields tab, you can search a field name by pressing CMD-F. Add Views Add a View to a Physical Model To add a new view, click the View button from the toolbar and click anywhere on the canvas. To add an existing view from the Explorer's Model tab, simply drag and drop the selected view from the Model tab to the canvas. Note: If you control-click the view connector, you can choose to add or delete vertices and change its color. The pop-up menu options of the view object in canvas include: Option Description Design View Edit the view structure in a View Designer. Add Related Objects Add all related tables/views to the selected view. Cut Remove the view from the diagram and put it on the clipboard. Copy Copy the view from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Views Select all views in the diagram. Delete Delete a view from the diagram or from both diagram and model. Rename Change the name of the view. Color Change the color of the view. Size to Fit Resize the view automatically to fit its contents. Bring to Front Bring the view to the foreground. Send to Back Move the view to the background. View Designer View Designer is the basic Navicat Data Modeler tool for working with views. In View Designer, you can build the views visually using View Builder or edit the view definition in View Editor directly. Note: The tabs and options in the designer depend on the diagram database type and version you are chosen. Work with View Builder Navicat Data Modeler provides a useful tool called View Builder for building views visually. It allows you to create and edit views without knowledge of SQL. The database objects are displayed in left pane. Whereas in the right pane, it is divided into two portions: the upper Diagram Design pane, and the lower Criteria Selection pane. Drag a table/view from the left pane to the Diagram Design pane or double-click it to add it to view. To include a field in the view, check the left of the field name in the Diagram Design pane. To include all the fields, click the * checkbox. To remove the object from the Diagram Design pane, click the cross button at the object caption. To add the table/vie...
