Table HLPDTEST.STATEGPS.T_ETK_EXCEPTIONS Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
EXCEPTION_ID number 22
T_GPS_EXCEPTIONS.EXCEPTION_ID Implied Constraint R
PRIMARY KEY FOR THE TABLE.
INSTANCE_NAME varchar2 255  √  null ETK INSTANCE NAME WHICH HAS REPORTED THIS EXCEPTION DURING ITS RUNTIME.
NODE_NAME varchar2 255  √  null NODE NAME IN THE ETK MODEL, WHOSE EXECUTION CAUSED THE EXCEPTION.
NODE_TYPE varchar2 255  √  null TYPE OF THE NODE SPECIFIED BY NODE NAME IN THE ETK MODEL, WHOSE EXECUTION CAUSED THE EXCEPTION.
GROUP_TYPE varchar2 255  √  null EITHER IT IS A SELECT OR CURSOR IF THE ETK MODEL CONTAINS R2O.
GROUP_NAME varchar2 255  √  null NAME OF THE SELECT OR CURSOR (IN CASE OF R2O) OR DESTINATION (IN CASE OF O2R).
STATUS_CODE number 22  √  null NUMERAL DEFINING THE STATUS OF THE OPERATION WHEN THIS KIND OF EXCEPTION IS BEING RAISED.
EXCEPTION_MESSAGE varchar2 255  √  null MESSAGE PROVIDED BY THE EXCEPTION. CAN BE USER DEFINED OR JAVA TYPE.
QUERY_EXECUTED varchar2 4000  √  null THE SELECT OR UPDATE OR DELETE QUERY BEING EXECUTED WHEN THE EXCEPTION RAISED.
ACTION_TYPE varchar2 20  √  null ACTION TO BE TAKEN WHEN THIS EXCEPTION HAS REPORTED. FOR NOW RAISE OR CAPTURE OR IGNORE.
RUNTIME date 7  √  null

Table contained 1,001,690 rows at Mon May 23 01:05 IST 2022

Indexes:
Column(s) Type Sort Constraint Name
EXCEPTION_ID Primary key Asc SYS_C009979
INSTANCE_NAME Performance Asc T_ETK_EXCEPTIONS_INDEX

Close relationships: