System Table TB_RULE_DEF

This table stores the feature rule definitions.

For server-side feature rules, the definition includes the actual program. The rules can be identified by their IDs.

For client-side feature rules, the definition includes the rule name, class name and assembly name, as shown in the following table:

Attributes of TB_RULE_DEF

Description

ID

Stores the primary key.

NAME

Specifies a short name for the rule.

CLASSNAME

Specifies the name of the class where the method is defined. For client-side feature rules.

ASSEMBLY

Specifies the name of the assembly where the method is defined. For client-side feature rules.

Note:

For server-side feature rules this attribute must be NULL.

TRIGGER_TEXT

Specifies the PL/SQL block forming the body of the rule. For server-side feature rules.

Note:

For client-side feature rules this attribute must be NULL.

IS_ROW

Specifies the trigger type: Either 1 = row trigger or 0 = statement trigger.

IS_SYSTEM

Specifies the trigger property: Either 1 = rule body is immutable or 0 = rule body can be edited.

IS_DEFAULT

Specifies when the rule is activated.

1 = The rule is a default rule that is activated when a matching feature class is created.

0 = The rule is not activated by default.

DEFAULT_PRIORITY

Specifies the default priority for this rule.

REQUIRES_ID

Specifies whether chaining is allowed.

1 = Allows chaining of dependent triggers, for example, when a row trigger requires a statement trigger. For server-side feature rules.

EXECUTE_COLUMN

Specifies when a trigger is executed.

0 = trigger is always executed.

Not NULL = The trigger only executes when an attribute matching the specified name is modified.

RULE_GROUP_ID

Specifies whether the rule belongs to a group. Is NULL for standalone rules.

RULE_VERSION

Specifies the version of the rule in the format. For client-side feature rules.

DESCRIPTION

Concise description of the rule.

BI, BU, BD, AI,

AU, AD

These fields map to an event (before/after insert/update/delete). A value of 1 means that the rule can react on that kind of event.