Key Checks (PDM)

PowerDesigner provides default model checks to verify the validity of keys.

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. Manual correction - Modify the name or code to contain only glossary terms. Automatic correction - None.
Name/Code contains synonyms of glossary terms	[if glossary enabled] Names and codes must not contain synonyms of glossary terms. Manual correction - Modify the name or code to contain only glossary terms. Automatic correction - Replaces synonyms with their associated glossary terms.
Name/Code uniqueness	Object names must be unique in the namespace. Manual correction - Modify the duplicate name or code. Automatic correction - Appends a number to the duplicate name or code.
Key code length	The key code length is limited by the maximum length specified in the DBMS definition (MaxConstLen entry, in the Object > Key category). Manual correction: Modify the key code length to meet this requirement Automatic correction: Truncates the key code length to the maximum length specified in the DBMS definition
Key column exists	Each key must have at least one column. Manual correction: Add a column to the key from the Column tab of the key property sheet Automatic correction: Deletes key without column
Key inclusion	A key cannot include another key (on some columns, regardless of their order). Manual correction: Delete the key that includes an existing key Automatic correction: None
Multi-column key has sequence column	Since the column initialized by a sequence is already a key, it should not be included in a multi-column key. Manual correction: Detach the sequence from a column that is already part of a multi-column key Automatic correction: None