Enterprise Data Manager Guide

Back Next

Importing Referential Integrity Constraints

The following table explains each column of a sample Referential Integrity Constraints XLS file:

Column Name	Value
Table Name	Name of the Primary Table.
Constraint Name	Name of the Constraint.
Constraint Column	Column names where Constraint is imposed in the Primary and Secondary Tables.
Primary Key Name	Column name in the Primary Table which functions as its Primary key.
Ref Table	Secondary Table name.
Owner	Owner of the Primary Table (i.e. its Parent Application Module).
Ref Owner	Owner of the Secondary Table (i.e. its Parent Application Module).
Constraint Type	Type of Constraint (“R” for Referential Integrity).
Status	Specifies whether the Constraint is to be imposed currently.