Relationships in the Logical Model › Relationships Editor - Referential Integrity (RI) Tab Options in the Logical Model

Relationships Editor - Referential Integrity (RI) Tab Options in the Logical Model

You can use the following options in the RI Actions tab in the Relationships editor to define referential integrity trigger actions for relationships.

Child Delete

Lets you specify the referential integrity trigger action that you want to occur when data in the child entity is deleted. Available actions include RESTRICT, CASCADE, SET NULL, SET DEFAULT, NO ACTION, or NONE.

Child Insert

Lets you specify the referential integrity trigger action that you want to occur when data in the child entity is inserted. Available actions include RESTRICT, CASCADE, SET NULL, SET DEFAULT, NO ACTION, or NONE.

Child Update

Lets you specify the referential integrity trigger action that you want to occur when data in the child entity is updated. Available actions include RESTRICT, CASCADE, SET NULL, SET DEFAULT, NO ACTION, or NONE.

Parent Delete

Lets you specify the referential integrity trigger action that you want to occur when data in the parent entity is deleted. Available actions include RESTRICT, CASCADE, SET NULL, SET DEFAULT, NO ACTION, or NONE.

Parent Insert

Lets you specify the referential integrity trigger action that you want to occur when data in the parent entity is inserted. Available actions include RESTRICT, CASCADE, SET NULL, SET DEFAULT, NO ACTION, or NONE.

Parent Update

Lets you specify the referential integrity trigger action that you want to occur when data in the parent entity is updated. Available actions include RESTRICT, CASCADE, SET NULL, SET DEFAULT, NO ACTION, or NONE.