Contents Index SYSDOMAIN system table SYSEVENTTYPE system table

ASA SQL Reference
  System Tables

SYSEVENT system table


Column name Column type Column constraint Table constraints
event_id INTEGER NOT NULL Primary key
creator UNSIGNED INT NOT NULL
event_name VARCHAR(128) NOT NULL
enabled CHAR(1) NOT NULL
location CHAR(1) NOT NULL
event_type_id INTEGER
action LONG VARCHAR
external_action LONG VARCHAR
condition LONG VARCHAR
remarks LONG VARCHAR
source LONG VARCHAR

Each row in SYSEVENT describes an event created with CREATE EVENT.

event_id    The unique number assigned to each event.

creator    The user number of the owner of the event. The name of the user can be found by looking in SYSUSERPERM.

event_name    The name of the event.

enabled (Y/N)    Indicates whether or not the event is allowed to fire.

location    The location where the event is to fire:

event_type_id    For system events, the event type as listed in SYSEVENTTYPE.

action    The event handler definition.

external_action    Not used.

condition    The WHERE condition used to control firing of the event handler.

remarks    A comment string.

source    This column contains the original source for the event handler if the preserve_source_format option is ON. It is used to maintain the appearance of the original text. For more information, see PRESERVE_SOURCE_FORMAT option [database].


Contents Index SYSDOMAIN system table SYSEVENTTYPE system table