COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
ID NUMBER No null 1 Identification to keep sequence of records in log
SEVERITY NUMBER Yes null 2 Severity level 1 - fatal, 2 - error, 3 - warning, 4 - info, 5 - debug
PROCEDURE_NAME VARCHAR2(200 BYTE) Yes null 3 Name of procedure
MSG VARCHAR2(4000 BYTE) Yes null 4 Content of message
LOG_TIME TIMESTAMP(6) Yes systimestamp 5 Datetime of logged event
LOG_DATE VARCHAR2(8 BYTE) Yes to_char(sysdate, 'yyyymmdd') 6 Date of logged event. It is redundant information, but usefull while mantenece.