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