The Model menu has these items:
Add Diagram: Creates a new EER Diagram. The keyboard shortcut is Control+T.
Create Diagram From Catalog Objects: Creates an EER diagram from all the objects in the catalog.
DBDoc – Model Reporting...: For information about this menu item, see Section 7.5.1.5.1, “The DBDoc Model Reporting Dialog Window (Commercial Version)”. Commercial version only.
User Defined Types: Presents a dialog box that enables you to add and delete user defined data types.
Object Notation: For information about this menu item, see Section 7.5.1.5.3, “The Object Notation Submenu”.
Relationship Notation: For information about this menu item, see Section 7.5.1.5.4, “The Relationship Notation Submenu”.
Diagram Properties and Size: Opens a diagram size dialog box that enables you to adjust the width or height of the canvas. The unit of measure is pages; the default value is two.
When you have tables with numerous columns, use this menu item to increase the size of the EER.
Validation: For information about this menu item, see Section 7.5.1.5.2, “The Validation Submenus (Commercial Version)”. Commercial version only.
Model Options: Sets options at the model level. These options should not be confused with the options that are set globally for the Workbench application, and which are referred to as Workbench Preferences. The available model options are a subset of the Workbench Preferences options.
For more information about Workbench Preferences, see Section 5.4.5, “The Model Tab”.
This dialog window is found by navigating to the Model menu and choosing the DBDoc - Model Reporting... item.
The DBDoc - Model Reporting... item is not available in the MySQL Workbench OSS version.
Use this dialog window to set the options for creating documentation of your database models. For more information, see Section 7.11, “The DBDoc Model Reporting Dialog Window (Commercial Version)”.
The Model menu has two validation submenus, Validation and Validation (MySQL). Use these submenus for general validation and MySQL-specific validation of the objects and relationships defined in your model.
These items are not available in the MySQL Workbench OSS version.
The Validation submenu has these items:
Validate All: Performs all available validation checks
Empty Content Validation: Checks for objects with no content, such as a table with no columns
Table Efficiency Validation: Checks the efficiency of tables, such as a table with no primary key defined
Duplicate Identifiers Validation: Checks for duplicate identifiers, such as two tables with the same name
Consistency Validation: Checks for consistent naming conventions
Logic Validation: Checks, for example, that a foreign key does not reference a nonprimary key column in the source table
The Validation (MySQL) submenu has these items:
Validate All: Performs all available validation checks
Integrity Validation: Checks for invalid references, such as a table name longer than the maximum permitted
Syntax validation: Checks for correct SQL syntax
Duplicate Identifiers Validation (Additions): Checks for objects with the same name
For detailed information about validation, see Section 7.10, “MySQL Workbench Schema Validation Plugins (Commercial Version)”.
The items under the Object Notation submenu apply exclusively to an EER diagram. They are not enabled unless an EER diagram tab is selected.
The Object Notation submenu has these items:
Workbench (Default): Displays table columns, indexes, and triggers
Workbench (Simplified): Shows only a table's columns
Classic: Similar to the
Workbench (Simplified)style showing only the table's columnsIDEF1X: The ICAM DEFinition language information modeling style
The object notation style that you choose persists for the duration of your MySQL Workbench session and is saved along with your model. When MySQL Workbench is restarted, the object notation reverts to the default.
If you plan to export or print an EER diagram be sure to decide on a notation style first. Changing notation styles after objects have been placed on a diagram can significantly change the appearance of the diagram.
The items under the Relationship Notation submenu apply exclusively to an EER diagram. They are not enabled unless an EER diagram tab is selected.
The Relationship Notation submenu has these items:
Crow's Foot (IE): The default modeling style. For an example, see Figure 7.47, “Adding Tables to the Canvas”.
Classic: Uses a diamond shape to indicate cardinality.
Connect to Columns
UML: Universal Modeling Language style.
IDEF1X: The ICAM DEFinition language information modeling method
To view the different styles, set up a relationship between two or more tables and choose the different menu items.
The relationship notation style that you choose persists for the
duration of your MySQL Workbench session and is saved along with
your model. When MySQL Workbench is restarted, the relationship
notation reverts to the default, the Crow's
Foot style.
If you plan to export or print an EER diagram, be sure to decide on a notation style first. Changing notation styles after objects have been placed on a diagram can significantly change the appearance of the diagram.
User Comments
Add your own comment.