Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

db_trigger

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, and CALL, 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.