Foreign Key asset page
On a foreign key asset page, you can find the details of the foreign key and define what has to happen if there are changes to the foreign key.
Tip Do not change any of the ingested data of a foreign key as this can cause errors when you refresh the database.
Foreign Key Update Rule
The Foreign Key Update Rule defines what has to be done when you refresh a schema where the primary key is updated.
- Imported No Action
- Imported Key Cascade
- Imported Key Set Null
- Imported Key Set Default
Foreign Key Delete Rule
The Foreign Key Delete rule defines what has to be done when you refresh a schema where the primary key is deleted.
- Imported No Action
- Imported Key Cascade
- Imported Key Set Null
- Imported Key Set Default
Foreign Key Evaluation Deferrability
- Imported Key Initially Deferred
- Imported Key Initially Immediate
- Imported Key Not Deferrable
Foreign Key Mapping
The foreign key mapping defines the complex mapping between the primary key and the foreign key. For an example of a foreign key, see Foreign Key ingestion.
The Foreign Key Mapping can be displayed in a table or in a diagram:
Each foreign key mapping consists of the following information:
- constrains: The value is a column in a child table, its values are restricted by the values of the corresponding primary key.
- references: The value is the column of the parent table that is a primary key in the database.
- is part of: The value is the foreign key asset to which the mapping belongs.
- Key sequence: The value is the order of the constrains definitions.