COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID PK COMMENTS
ID NUMBER No null 1 1 Primary Key
TABLE_OR_VIEW_ID_FK NUMBER No null 2 null Table on which this trigger fires
TRIGGER_ON_FLAG CHAR(1 BYTE) No null 3 null Flag to show iif the trigger is on a table or a view. If it is a table this should be 'T'. If it is on a view this should be 'V'
TRIGGER_NAME VARCHAR2(4000 BYTE) Yes null 4 null Name of the trigger //OBJECTNAME
TRIGGER_TIMING VARCHAR2(4000 BYTE) Yes null 5 null before, after ,etc.
TRIGGER_OPERATION VARCHAR2(4000 BYTE) Yes null 6 null insert, delete, etc.
TRIGGER_EVENT VARCHAR2(4000 BYTE) Yes null 7 null The actual trigger that gets fired
NATIVE_SQL CLOB Yes null 8 null The full definition
NATIVE_KEY VARCHAR2(4000 BYTE) Yes null 9 null UInique identifer for this object at source
LANGUAGE VARCHAR2(40 BYTE) No null 10 null //PUBLIC
COMMENTS VARCHAR2(4000 BYTE) Yes null 11 null null
SECURITY_GROUP_ID NUMBER No 0 12 null null
CREATED_ON DATE No sysdate 13 null null
CREATED_BY VARCHAR2(255 BYTE) Yes null 14 null null
LAST_UPDATED_ON DATE Yes null 15 null null
LAST_UPDATED_BY VARCHAR2(255 BYTE) Yes null 16 null null