Table HLPDTEST.STATEGPS.T_BPM_APR_REQUESTS 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_REQUEST_ID number 10
T_ALL_BPM_LATEST_VER_MODELS_V.T_BPM_APR_REQUEST_ID Implied Constraint R
INSTANCE_ID number 10  √  null
T_INSTANCES.INSTANCE_ID INSTANCE_ID1_FKEY C
REQUEST_NUMBER varchar2 100  √  null
MODEL_ID number 10  √  null
T_GPS_MODELS.MODEL_ID MODEL_ID_FKEY C
REASON_FOR_REQUEST varchar2 2000  √  null
APPROVAL_TRACK varchar2 100  √  null
REQUESTED_BY varchar2 100  √  null
REQUESTED_DATE timestamp(6) 11,6  √  null
ACTION_TAKEN_BY varchar2 100  √  null
ACTION_TAKEN_DATE timestamp(6) 11,6  √  null
APPROVER_COMMENTS varchar2 500  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
T_BPM_APR_REQUEST_ID Primary key Asc SYS_C0033481

Close relationships  within of separation: