Referential Constraints

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.

To create Referential Constraints proceed as follows:

1. Open the Service Builder.

2. Expand Data Model  Entity Types  Associations .

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

   .

See Associations for more information on additional functions.