Attribute Name |
Data Type |
Description |
---|---|---|
owner |
db_user |
Trigger owner |
name |
VARCHAR(1073741823) |
Trigger name |
status |
INTEGER |
1 for INACTIVE, and 2 for ACTIVE. The default value is 2. |
priority |
DOUBLE |
Execution priority between triggers. The default value is 0. |
event |
INTEGER |
0 is set for UPDATE, 1 for UPDATE STATEMENT, 2 for DELETE, 3 for DELETE STATEMENT, 4 for INSERT, 5 for INSERT STATEMENT, 8 for COMMIT, and 9 for ROLLBACK. |
target_class |
object |
Class object for the trigger target class |
target_attribute |
VARCHAR(1073741823) |
Trigger target attribute name. If the target attribute is not specified, NULL is used. |
target_class_attribute |
INTEGER |
If the target attribute is an instance attribute, 0 is used. If it is a class attribute, 1 is used. The default value is 0. |
condition_type |
INTEGER |
If a condition exist, 1; otherwise NULL. |
condition |
VARCHAR(1073741823) |
Action condition specified in the IF statement |
condition_time |
INTEGER |
1 for BEFORE, 2 for AFTER, and 3 for DEFERRED if a condition exists; NULL, otherwise. |
action_type |
INTEGER |
1 for one of INSERT, UPDATE, DELETE, CALL and EVALUATE, 2 for REJECT, 3 for INVALIDATE_TRANSACTION, and 4 for PRINT. |
action_definition |
VARCHAR(1073741823) |
Execution statement to be triggered |
action_time |
INTEGER |
1 for BEFORE, 2 for AFTER, and 3 for DEFERRED. |