Reference Checks (PDM)

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