Validation
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 |