Reference Checks (PDM)

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

Check

Description and Correction

Reference name and code uniqueness

Reference 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

Reflexive and mandatory reference

A reflexive reference exists should not have a mandatory parent which could lead to inconsistent joins.

Manual correction: Correct the reference by clearing the Mandatory parent check box

Automatic correction: None

Existence of reference join

A reference must have at least one reference join.

Manual correction: Create a reference join for the reference or delete the reference

Automatic correction: Deletes reference without join

Reference code maximum length

The reference code length is limited by the maximum length specified in the DBMS definition (MaxConstLen entry, in the Object > Reference category) or in the naming conventions of the model options.

Manual correction: Modify the reference code length to meet this requirement

Automatic correction: Truncates the reference code length to the maximum length specified in the DBMS definition

Incomplete join

Joins must be complete.

Manual correction: Select a foreign key column or activate the primary key column migration

Automatic correction: None

Join order

The join order must be the same as the key column order for some DBMS.

Manual correction: If required, change the join order to reflect the key column order

Automatic correction: The join order is changed to match the key column order