Check Diagram

The Check Diagram tool of the Database Designer for MySQL allows you to check your database diagram on most typical errors and defects. The result of the check goes in a well structured form, using which you can easily bring your diagram to correspondence with the common standards of database modeling.

To open the Check Diagram dialog press F4 or select the Diagram | Check Diagram menu item.

Use the Select diagram drop-down list to select the diagram from the list of currently opened diagrams.

The tree list below allows you to select what warnings and errors should be taken into account during the check. All warnings and errors are divided into categories, which correspond to the diagram objects. Remove selection from the warning/error or from the whole category to exclude it from the check.

These are the descriptions for all available warnings and errors:

Table

Table Name Uniqueness checks the diagram for the uniqueness of each table name within a database ;

Table Name Max Length
MySQL allows only 64 characters in table names and cuts names if they are longer than this;

Column Definition checks if each table within the diagram owns at least one column;

Index Definition checks if each table within the diagram owns at least one index;

Primary Key Definition checks if a primary key is defined for each table within the diagram;

Reference Definition checks if each table within the diagram is linked with other tables;

Auto-increment columns checks if each table within the diagram has no more than one auto-increment column, as otherwise MySQL will not allow such table to be created;

Table Columns

Column Name Uniqueness checks diagram tables for the uniqueness of each column name within the table;

Column Name Max Length MySQL allows only 64 characters in column names and cuts names if they are longer than this;

Auto-increment Column Definition checks if each auto-increment column within a table is a part of a primary key;

Table Indexes

Index Name Uniqueness checks diagram tables for the uniqueness of each index name within the table;

Index Name Max Length MySQL allows only 64 characters in index names and cuts names if they are longer than this;

Duplicate Index Column checks if each table column is indexed only once;

References

Reference Table Type checks if both linked tables are of InnoDB type for each diagram reference;

Reference Column Data Types checks whether the linked columns are of the same data type for each diagram reference;

Domains

Domain Name Uniqueness checks diagram for the uniqueness of each domain name within a diagram .

Stored Routine

Stored Routine Name Uniqueness checks diagram stored procedures and functions for the uniqueness of name within a diagram .

Stored Routine Name Max Length MySQL allows only 64 characters in stored routine names and cuts names if they are longer than this;

Views

View Name Uniqueness checks diagram stored procedures and functions for the uniqueness of name within a diagram .

View Name Max Length MySQL allows only 64 characters in stored routine names and cuts names if they are longer than this;

View was created on a not existing table checks existence of tables, which are used in the view;

View was created on a not existing column check existence of table columns, which are used in the view.

After you click OK the check process will be displayed within the Output window and the result of the check will be displayed within the Result window in the same categorized view as described above.

Double-click on a warning or an error in the list opens the editor window for the appropriate object (Table Editor, Table Editor, Index Editor, or Domain Manager).

See Also

Diagram Objects: Table Editor | Column Editor | Reference Editor | Index Editor