Table HLPDTEST.STATEGPS.T_BPM_APR_WF_AUDIT 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
T_BPM_APR_WF_AUDIT_ID number 10
T_BPM_APR_UPDATE_HISTORY_ID number 10  √  null
T_BPM_APR_UPDATE_HISTORY.T_BPM_APR_UPDATE_HISTORY_ID T_BPM_APR_HISTORY_ID_FKEY C
T_BPM_APR_DOC_HISTORY_ID number 10  √  null
FROM_STATE_ID number 10  √  null
T_GPS_WORKFLOW_STATES.STATE_ID FROM_STATE_ID_FKEY C
TO_STATE_ID number 10  √  null
T_GPS_WORKFLOW_STATES.STATE_ID TO_STATE_ID_FKEY C
INSTANCE_ID number 10  √  null
T_INSTANCES.INSTANCE_ID INSTANCE_ID4_FKEY C
ACTION_TAKEN_BY varchar2 100  √  null
ACTION_TAKEN_DATE timestamp(6) 11,6  √  null
APPROVER_COMMENTS varchar2 500  √  null
IS_DATAFIX varchar2 1  √  null

Table contained 806 rows at Sun Jan 17 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name
T_BPM_APR_WF_AUDIT_ID Primary key Asc SYS_C0033488

Close relationships  within of separation: