Physical Modeling › Triggers › Default Trigger Templates Example

Default Trigger Templates Example

A model contains the following relationship between the MOVIE and MOVIE_COPY tables: MOVIE_is_rented_as_MOVIE_COPY

During schema generation, the macros are expanded in the trigger template as follows:

• Each time the macro %Parent is found, MOVIE is substituted as the name of the parent table.
• Each time the macro %VerbPhrase is found, "is_rented_as" is substituted as the verb phrase.
• Each time the macro %CHILD is found, MOVIE_COPY is substituted as the name of the child table in the relationship.

Because macros are used in place of specific table and relationship names, the default RI trigger templates generate the correct CREATE TRIGGER SQL statements for all the tables in the database.