RI Constraint Generic Name

The generic name of the RI Constraint is a name that is consistent for the implemented relationship throughout all of the technical designs. It is called generic because it is not DBMS specific.

The generic name can be no more that 18 characters long.

There is no reason to change this name in the Data Structure List.

RI Constraint DBMS Name

If the DBMS detects a referential integrity error, this RI Constraint name appears in the error message. Therefore, you should name the RI Constraint something meaningful.

Referential Integrity Options Enforced by

You have the option on each RI constraint to have the DBMS handle the constraint (if the DBMS contains the capability to handle the particular constraint) or let CA Gen generate the code to handle the constraint.

Typically better performance is gained by selecting the DBMS to handle anything it can and let CA Gen generate the constraints not handled by the DBMS.

Description

A free text field used to document the purpose of this RI Constraint.