Key Checks (PDM)

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

Check

Description and Correction

Key name and code uniqueness

Key names and codes must be unique in the model.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/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