The Check Diagram tool of the Database Designer for MySQL allows you to check your database diagram for 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 use the Check Diagram ( ) item on Diagram tab of the Ribbon or press F4.
Use the Select diagram drop-down list to select the diagram from the list of currently opened diagrams. Current opened diagram is selected by default.
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.
Error "Table Name Uniqueness"
Warning "Table Name Max Length"
Error "Column Definition"
Warning "Index Definition"
Warning "Primary Key Definition"
Warning "Reference Definition"
Error "Auto-increment columns"
Error "Trigger Times and Events"
Error "Column Name Uniqueness"
Warning "Column Name Max Length"
Warning "Auto-increment Column Definition"
Error "Index Name Uniqueness"
Warning "Index Name Max Length"
Warning "Duplicate Index Column"
Warning "Reference Table Type"
Error "Reference Column Data Types"
Error "Reference Column does not exists"
Error "Reference Name uniqueness"
Error "Check "SET NULL" FK-action for NOT NULL column"
Error "Domain Name Uniqueness"
Error "Stored Routine Name Uniqueness"
Warning "Stored Routine Name Max Length"
Error "View Name Uniqueness"
Warning "View Name Max Length"
Error "View was created on a not existing table"
Error "View was created on a not existing column"
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.