Home > Data Modeler Dialog Boxes > Foreign Key Properties
This dialog box displays the properties of a foreign key relation, which is part of the definition of a table in Relational Models.
General
Name: Name of the foreign key.
Table: Name of the table containing this foreign key (a column whose value must match a value in a primary key or unique key column in another table).
PK/UK Index: The primary key, unique key, or index to which this foreign key refers (for example, the primary key column in another value that must contain a matching value for each value in the foreign key column).
Delete Rule: Action to take automatically when a row in the referenced table (in PK/UK Index) is deleted and rows with that value exist in the table containing this foreign key: NO ACTION (shown by a crossing line in diagrams) performs no action on these rows; CASCADE (shown by an "X") deletes these rows; SET NULL (shown by a small circle) sets null all columns in those rows that can be set to a null value; RESTRICT (also shown by one crossing line) prevents those rows from being deleted.
Source Table Synonym: Name or synonym of the table containing the primary or unique key to which this foreign key refers.
Target Table Synonym: Name or synonym of the table containing this foreign key column.
Mandatory: Controls whether referential integrity is enforced. If this option is enabled, referential integrity is enforced (that is, a matching value in the table for the referenced primary or unique key is mandatory; and if a matching value does not exist, a record cannot be created in the current table). If this option is not enabled, referential integrity is not enforced, and applications that use the database must deal with any potential problems caused by inconsistent data.
Transferable (Updateable): Controls whether the foreign key relationship is transferable (that is, updateable). In a non-transferable relationship, each foreign key value cannot be changed; for example, if a line item has a non-transferable relationship to an order, a line item cannot be reassigned later to another order. In a transferable relationship, a foreign key value can be changed; for example, an employee could be transferred later from one department to another.
If the foreign key relationship is non-transferable, a diamond appears on the line in the diagram.
Generate in DDL: Controls whether the foreign key creation is included when DDL statements are generated to be used to create the database.
In Arc: Controls whether the foreign key relationship should be included in An exclusive relationship group (arc). For more information, see Arcs.
Associated Columns
Lists each parent column and child column pair in the foreign key definition.
Impact Analysis
Enables you to view and specify information to be used by Oracle Warehouse Builder for impact analysis.
Dynamic Properties
For foreign keys that have been discovered (see Create Discovered Foreign Keys), contains the Name createdByFKDiscoverer
and the Value true
.
Comments, Notes, Summary