ASA SQL Reference
System Tables
| 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:
C = consolidated
R = remote
A = all
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].