Column | Type | Null | Default | Links to | Comments |
---|---|---|---|---|---|
EVENT_CATALOG | varchar(64) | No | |||
EVENT_SCHEMA | varchar(64) | No | SCHEMATA -> SCHEMA_NAME | ||
EVENT_NAME | varchar(64) | No | |||
DEFINER | varchar(77) | No | |||
TIME_ZONE | varchar(64) | No | |||
EVENT_BODY | varchar(8) | No | |||
EVENT_DEFINITION | longtext | No | |||
EVENT_TYPE | varchar(9) | No | |||
EXECUTE_AT | datetime | Yes | NULL | ||
INTERVAL_VALUE | varchar(256) | Yes | NULL | ||
INTERVAL_FIELD | varchar(18) | Yes | NULL | ||
SQL_MODE | varchar(8192) | No | |||
STARTS | datetime | Yes | NULL | ||
ENDS | datetime | Yes | NULL | ||
STATUS | varchar(18) | No | |||
ON_COMPLETION | varchar(12) | No | |||
CREATED | datetime | No | 0000-00-00 00:00:00 | ||
LAST_ALTERED | datetime | No | 0000-00-00 00:00:00 | ||
LAST_EXECUTED | datetime | Yes | NULL | ||
EVENT_COMMENT | varchar(64) | No | |||
ORIGINATOR | bigint(10) | No | 0 | ||
CHARACTER_SET_CLIENT | varchar(32) | No | CHARACTER_SETS -> CHARACTER_SET_NAME | ||
COLLATION_CONNECTION | varchar(32) | No | COLLATIONS -> COLLATION_NAME | ||
DATABASE_COLLATION | varchar(32) | No | COLLATIONS -> COLLATION_NAME |