Show TOC

Referential ConstraintsLocate this document in the navigation structure

Introduction

A referential Constraint can be used to specify the foreign key relationship for 1:1 or 1:n associations.

Follow below procedure to create Referential Constraints.

Procedure

To create Referential Constraints proceed as follows:

  1. Open the Service Builder.

  2. Expand Data Model Start of the navigation path Entity Types Next navigation step Associations End of the navigation path.

  3. Expand the association created .

  4. Double click Referential Constraints to open it in the mass edit view.

  5. Click Display/Changeto switch to edit mode.

  6. Click Append Row to create a new association. A row is now added.

  7. Do the following in the mass edit view:

    Fields

    Description

    Principal Entity

    This field cannot be edited. It is the name of the Principal Entity for which the association has created.

    Principal Key

    Enter a key property of the principle Entity Type. Use the input help to select an existing property.

    Dependent Entity

    This field cannot be edited. Enter the name of the Dependent Entity for which the association has created.

    Dependent Property

    Enter the Property of the dependent Entity Type which correlates to the entered Key property of the principle Type. Use the input help to select an existing property.

    Note
    1. You should map all the key properties of the Principle Entity Type to Dependent Properties.

    2. To create Referential Constraint, both the Principle and Dependent Property fields are mandatory.

  8. Save the changes

    .

More Information

See Associations for more information on additional functions.