Triggers

Trigger properties:

• The field “Entity” contains the entity that the trigger belongs to.

• The field “Trigger name” contains the unique name of the trigger in the database.

• The field “Function” contains the name of the function called when the trigger is triggered.

• The field “Trigger state” contains the current state of the trigger: on/off.

• The field “For each row mode” in the “set” state means that the trigger is called once for each row.

• The field “Trigger type” contains the moment when the trigger was triggered: before the operation( BEFORE), after the operation( AFTER), instead of the operation (INSTEAD OF).

• The field “Events” contains operations that trigger the trigger: insert (INSERT), update (UPDATE), delete (DELETE), clearing the table (TRUNCATE).