| Column | Type | Null | Default | Links to | Comments |
|---|---|---|---|---|---|
| TRIGGER_CATALOG | varchar(512) | No | |||
| TRIGGER_SCHEMA | varchar(64) | No | SCHEMATA -> SCHEMA_NAME | ||
| TRIGGER_NAME | varchar(64) | No | |||
| EVENT_MANIPULATION | varchar(6) | No | |||
| EVENT_OBJECT_CATALOG | varchar(512) | No | |||
| EVENT_OBJECT_SCHEMA | varchar(64) | No | SCHEMATA -> SCHEMA_NAME | ||
| EVENT_OBJECT_TABLE | varchar(64) | No | |||
| ACTION_ORDER | bigint(4) | No | 0 | ||
| ACTION_CONDITION | longtext | Yes | NULL | ||
| ACTION_STATEMENT | longtext | No | |||
| ACTION_ORIENTATION | varchar(9) | No | |||
| ACTION_TIMING | varchar(6) | No | |||
| ACTION_REFERENCE_OLD_TABLE | varchar(64) | Yes | NULL | ||
| ACTION_REFERENCE_NEW_TABLE | varchar(64) | Yes | NULL | ||
| ACTION_REFERENCE_OLD_ROW | varchar(3) | No | |||
| ACTION_REFERENCE_NEW_ROW | varchar(3) | No | |||
| CREATED | datetime | Yes | NULL | ||
| SQL_MODE | varchar(8192) | No | |||
| DEFINER | varchar(77) | No | |||
| 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 |