|
Each row in the SYSEVENT system view describes an event created with CREATE EVENT. The underlying system table for this view is ISYSEVENT.
| Column name | Column type | Column constraint |
|---|---|---|
| event_id | UNSIGNED INT | NOT NULL |
| object_id | UNSIGNED BIGINT | NOT NULL |
| creator | UNSIGNED INT | NOT NULL |
| event_name | VARCHAR(128) | NOT NULL |
| enabled | CHAR(1) | NOT NULL |
| location | CHAR(1) | NOT NULL |
| event_type_id | UNSIGNED INT | |
| action | LONG VARCHAR | |
| external_action | LONG VARCHAR | |
| condition | LONG VARCHAR | |
| remarks | LONG VARCHAR | |
| source | LONG VARCHAR |
event_id The unique number assigned to each event.
object_id The internal ID for the event, uniquely identifying it in the database.
creator The user number of the owner of the event. The name of the user can be found by looking in the SYSUSER system view.
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 the SYSEVENTTYPE system view.
action The event handler definition.
external_action For system use only.
condition The condition used to control firing of the event handler.
remarks Remarks for the event; this column comes from ISYSREMARK.
source The original source for the event; this column comes from ISYSSOURCE.
PRIMARY KEY (event_id)
FOREIGN KEY (event_type_id) references SYS.ISYSEVENTTYPE (event_type_id)
FOREIGN KEY (creator) references SYS.ISYSUSER (user_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
UNIQUE (index_name, table_id, index_category)