9.1.1.5 The Model Menu

9.1.1.5.1 The DBDoc Model Reporting Dialog Window (Commercial Version)
9.1.1.5.2 The Validation Submenus (Commercial Version)
9.1.1.5.3 The Object Notation Submenu
9.1.1.5.4 The Relationship Notation Submenu

When a model is opened, this menu features actions to perform against your model, and the Model menu has these items:

9.1.1.5.1 The DBDoc Model Reporting Dialog Window (Commercial Version)

This dialog window is found by navigating to the Model menu and choosing the DBDoc - Model Reporting... item.

Note

The DBDoc - Model Reporting... item is not available in the MySQL Workbench Community version.

Use this dialog window to set the options for creating documentation of your database models. For more information, see Section 9.7, “The DBDoc Model Reporting Dialog Window (Commercial Version)”.

9.1.1.5.2 The Validation Submenus (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.

Note

These items are not available in the MySQL Workbench Community 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 9.6, “MySQL Workbench Schema Validation Plugins (Commercial Version)”.

9.1.1.5.3 The Object Notation Submenu

The items under the Model, 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 columns

  • IDEF1X: 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.

Note

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.

9.1.1.5.4 The Relationship Notation Submenu

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 9.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.

Note

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.