PowerDesigner provides default model checks to verify the validity of join indexes and bitmap join indexes.
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.
|
Existence of base table |
Join index must have a base table.
|
Reference without parent key |
Each reference associated with a join index must have a parent key.
|
Join Index tables owners |
The tables associated to a join index must have the same owner.
|
Join index references connection |
Join index references must be connected to selected table on a linear axis.
|
Duplicated join indexes |
Join indexes cannot have the same set of references.
|