Table HLPDTEST.STATEGPS.T_INSTANCES 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
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID FK_T_INSTANCES C
INSTANCE_ID number 22
ISSUES.INSTANCE_ID INST_ID_FK C
T_BPM_APR_DOC_HISTORY.INSTANCE_ID INSTANCE_ID3_FKEY C
T_BPM_APR_DOCUMENTS.INSTANCE_ID T_GPS_WF_DOCS_INSTANCE_ID_FKEY C
T_BPM_APR_REQUESTS.INSTANCE_ID INSTANCE_ID1_FKEY C
T_BPM_APR_UPDATE_HISTORY.INSTANCE_ID INSTANCE_ID2_FKEY C
T_BPM_APR_WF_AUDIT.INSTANCE_ID INSTANCE_ID4_FKEY C
T_CUSTOMER_REF.INSTANCE_ID INSTANCE_ID C
T_GPS_CONDITIONAL_STATE_TRACK.INSTANCE_ID FK_INSTANCE_ID C
T_GPS_INSTANCE_ACTIVE_TRACKING.INSTANCE_ID ACTIVE_INSTANCE_ID_FK C
T_GPS_INSTANCE_LINKS.FROM_INSTANCE_ID FK1_T_GPS_INSTANCE_LINKS C
T_GPS_INSTANCE_LINKS.TO_INSTANCE_ID FK2_T_GPS_INSTANCE_LINKS C
T_GPS_INSTANCE_MOVETO_TRACKING.INSTANCE_ID MOVETO_INSTANCE_ID_FK C
T_GPS_INSTANCE_PROPERTIES.INSTANCE_ID FK_T_GPS_INST_PROPERTIES C
T_GPS_SHAREPOINT_INFO.INSTANCE_ID FK_T_GPS_SHAREPOINT_INFO C
T_GPS_WF_INST_FAIL_REASONS.INSTANCE_ID FK_T_GPS_WF_INST_FAIL_REASONS C
T_GPS_WORKFLOW_SOD_ASSIGNMENTS.INSTANCE_ID FK_WORKFLOWSOD_INSTANCEID C
T_INSTANCE_PREDECESSOR.INSTANCE_ID INSTANCE_ID_FK C
T_INSTANCE_PREDECESSOR.PRED_INSTANCE_ID PRED_INSTANCE_ID_FK C
T_MULTIPLE_FILES.INSTANCE_ID MULTI_FL_ID_FK C
T_PLANNED_ACCOMPLISHED.INSTANCE_ID PA_INSTANCE_ID_FK R
T_PROJECT_TASK.INSTANCE_ID FK1_T_PROJECT_TASK C
T_PROMISED_DUEDATE_HISTORY.INSTANCE_ID INSTANCE_ID_FK1 C
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
PRIORITY number 22  √  null
CREATION_DATE date 7  √  null
CREATED_BY number 22  √  null
LAST_UPDATE_DATE date 7  √  null
LAST_UPDATED_BY number 22  √  null
OWNER varchar2 500  √  null
DUE_DATE date 7  √  null
PREDECESSOR varchar2 4000  √  null
ACTIVE number 22  √  null
PROMISED_DUE_DATE date 7  √  null
WORKFLOW_TYPE_ID number 22  √  null
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Implied Constraint R
CLOSED_DATE date 7  √  null

Table contained 196,699 rows at Mon May 23 01:05 IST 2022

Indexes:
Column(s) Type Sort Constraint Name
PRIORITY Performance Asc T_INSTANCES_CN1
INSTANCE_ID Must be unique Asc T_INSTANCES_U1

Close relationships  within of separation: