KeyRef Checks

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

Check

Description and Correction

KeyRef name and code uniqueness

KeyRef 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.

Undefined reference

A keyRef must contain a reference to a key or a unique constraint.

Manual correction: In the keyRef property sheet, define a reference to a key or a unique constraint with the Reference list.

Automatic correction: None

Existence of fields

A keyRef must contain at least one field.

Manual correction: Add at least one field to the keyRef or delete the keyRef. For example: @numEmployee.

Automatic correction: Deletes unassigned keyRef.

For more information on fields, see Specifying Constraint Fields.

Undefined selector

You must define an XPath expression for a keyRef selector attribute.

Manual correction: In the keyRef property sheet, define an XPath expression for the selector attribute. For example: s:company/s:employee.

Automatic correction: None

For more information on XPath expressions, see Specifying a Constraint Selector.