PowerDesigner provides default model checks to verify the validity of references and view references.
Check |
Description and Correction |
---|---|
Name/Code contains terms not in glossary |
[if glossary enabled] Names and codes must contain only approved terms drawn from the glossary.
|
Name/Code contains synonyms of glossary terms |
[if glossary enabled] Names and codes must not contain synonyms of glossary terms.
|
Name/Code uniqueness |
Object names must be unique in the namespace.
|
Reflexive and mandatory reference |
[references only] A reflexive reference exists should not have a mandatory parent which could lead to inconsistent joins.
|
Existence of reference join |
A reference must have at least one reference join.
|
Reference code maximum length |
[references only] The reference code length is limited by the maximum length specified in the DBMS definition (MaxConstLen entry, in the category) or in the naming conventions of the model options.
|
Incomplete join |
[references only] Joins must be complete.
|
Join order |
[references only] The join order must be the same as the key column order for some DBMS.
|