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 an 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 selection.
The RI constraint properties in the pop-up window that can be changed are listed in the following table.
|
Copyright © 2013 CA.
All rights reserved.
|
|