Previous Table of Contents Next


6.3.22 Trigger


   An action run by the DBMS when specified events occur on the table owning the Trigger.

   Superclasses

   ModelElement

   Attributes

   eventManipulation

Indicates what types of events are using the current Trigger.

type:

multiplicity:

EventManipulationType ( insert | delete | update )
exactly one

   actionCondition

A boolean expression that defines when the trigger has to be executed.

class:

multiplicity:

BooleanExpression
exactly one

   actionStatement

The Trigger action itself.

class: ProcedureExpression
multiplicity: exactly one

   actionOrientation

Indicates if the trigger is called once per statement execution or before or after each row of the table is modified.

class:

multiplicity:

ActionOrientationType ( row | statement )
exactly one

   conditionTiming

Indicates if the trigger activity is run before or after the statement or row is modified.

class:

multiplicity:

ConditionTimingType ( before | after )
exactly one

   conditionReferenceNewTable

The alias for the owning table name, used in the actionStatement, to represent the state of the table after the insert/delete/update.

class:

multiplicity:

String
exactly one

   conditionReferenceOldTable

The alias for the name of the owning table, used in the actionStatement, to represent the state of the table before the update/delete/insert.

class:

multiplicity:

String
exactly one

   References

   usedColumnSet

Tables referenced by the actionStatement or the actionCondition.

class:

defined by:

multiplicity:

inverse:

NamedColumnSet
TriggerUsingColumnSet::usedColumnSet
zero or more
NamedColumnSet::usingTrigger

   table

The table that owns the Trigger.

class:

defined by:

multiplicity:

inverse:

Table
TableOwningTrigger::table
exactly one
Table::trigger