Previous Topic: Properties of IndexesNext Topic: Properties of RI Constraints


RI Constraints

A referential integrity (RI) constraint is the implementation of a relationship in the data model. It defines how the foreign key is used to get from one table to another, as described in Transforming the Data Model.

For a M:M relationship, two RI constraints and a table are required.

In the unlikely event an entity type has more than one identifier, the table that implements it is given a unique index to support each of them. CA Gen uses the primary index of the related table to implement the foreign key. Choosing another identifier may change CA Gen's selection.