Table HLPDTEST.STATEGPS.T_ETK_INSTANCES_INFO 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
INSTANCE_ID number 22
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
PRIMARY KEY FOR TABLE.
USERNAME varchar2 100  √  null USER NAME WHO HAS INTIATED THIS REQUEST TO RUN THE INSTANCE.
INSTANCE_NAME varchar2 200  √  null ETK INSTANCE NAME WHICH IS BEING FIRED.
START_TIME varchar2 500  √  null INSTANCE RUN STARTED AT THIS TIME.
END_TIME varchar2 500  √  null INSTANCE RUN ENDED AT THIS TIME.
RECORDS_COUNT number 22  √  null NUMBER OF RECORDS SUBSCRIBED / PROCESSED
R2O_EXCEPTION_INFO varchar2 2000  √  null EXCEPTION RAISED DURING RUNTIME AT R2O END.
O2R_EXCEPTION_INFO varchar2 2000  √  null EXCEPTION RAISED DURING RUNTIME AT O2R END.
R2F_EXCEPTION_INFO varchar2 2000  √  null EXCEPTION RAISED DURING RUNTIME AT R2F END.
F2ORA_EXCEPTION_INFO varchar2 2000  √  null EXCEPTION RAISED DURING RUNTIME AT F2ORA END.

Table contained 0 rows at Sat Oct 31 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
INSTANCE_ID Primary key Asc PK_T_ETK_INSTANCE_INFO

Close relationships: