Chapter 15 System Tables
1043
SYSTRIGGER system table
Column name Column type
Column
constraint
Table constraints
trigger_id UNSIGNED INT NOT NULL Primary key
table_id UNSIGNED INT NOT NULL Foreign key
references
SYSTABLE.table_id
event CHAR(1) NOT NULL Unique
trigger_time CHAR(1) NOT NULL Unique
trigger_order UNSIGNED INT Unique
foreign_table_id UNSIGNED INT Unique. Foreign key
references
SYSFOREIGNKEY
foreign_key_id UNSIGNED INT Unique. Foreign key
references
SYSFOREIGNKEY
referential_action CHAR(1)
trigger_name CHAR(128) Unique.
trigger_defn LONG
VARCHAR
NOT NULL
remarks LONG
VARCHAR
Each trigger in the database is described by one row in SYSTRIGGER. The
table also contains triggers that are automatically created by the database for
foreign key definitions which have a referential triggered action (such as ON
DELETE CASCADE).
trigger_id Each trigger is assigned a unique number (the trigger
number), which is the primary key for SYSTRIGGER.
table_id The table number uniquely identifies the table to which this
trigger belongs.
event The event or events that cause the trigger to fire. This single-
character value corresponds to the trigger event that was specified when the
trigger was created.
To Next Page
Loading...