Model validation is automatically trigger when the diagram is saved and it can be done at any time via "Edit > Validate" menu option.


Any validation problems found are made visible directly on the diagram canvas by using an error or warning decoration on elements where the issues were found, alternatively those can be also found by using the Problems view.


Those are the validation rules used by the validation engine along with the severity level for each:


Duplicate table name in a database.

ERROR

Duplicate area name in a database.

ERROR

Duplicate sequence name in a database.

ERROR

Duplicate field name in a table.

ERROR

Duplicate index name in a table.

ERROR

No fields defined for a table.

ERROR

No fields added to a table index.

ERROR

No field mapping specified for a foreign key relation.

ERROR

No primary index defined for a table (not if is a template).

WARNING

Nullable (non mandatory) fields part of a primary index.

WARNING

Different data type for fields in a foreign key relation field mapping.

WARNING

Table name contain invalid SQL characters.

WARNING

Field name contain invalid SQL characters.

WARNING