Table HLPDTEST.STATEGPS.T_GPS_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_GPS_INSTANCES C
WORKFLOW_TYPE_ID number 22  √  null
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID FK1_T_GPS_INSTANCES C
CURRENT_STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID FK2_T_GPS_INSTANCES C
INSTANCE_ID number 22  √  null
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
INSTANCE_PRESENT number 22  √  1
FROM_STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID FK3_T_GPS_INSTANCES C
OWNER varchar2 500  √  null
CREATED_DATE date 7  √  null
CYCLE_TIME date 7  √  null
ESCALATED varchar2 10  √  null
ESCALATED_TO varchar2 500  √  null
MOVED_OUT_DATE date 7  √  null
ACTIVE number 22  √  1
TIME_BASED_NOTIFICATION varchar2 255  √  null
PRIORITY number 22  √  null
INSTANCE_PRIMARY_ID number 22
T_GPS_INSTANCE_FEEDBACK.INSTANCE_PRIMARY_ID FK_INSTANCE_FEEDBACK_PRIMARYID C
T_GPS_INSTANCE_FEEDBACK_V.INSTANCE_PRIMARY_ID Implied Constraint R
T_ISSUES_CREATED_BY_ME_V.INSTANCE_PRIMARY_ID Implied Constraint R
T_PROJECT_TASK_V.INSTANCE_PRIMARY_ID Implied Constraint R
T_SCRIPT_REPLAY_RESULTS.INSTANCE_PRIMARY_ID FK_T_SCRIPT_REPLAY_RESULTS C
COMMENTS varchar2 4000  √  null
VISIBLE_FLAG varchar2 5  √  null
MOVED_OUT_BY varchar2 500  √  null
STATE_COMMENTS varchar2 4000  √  null

Table contained 976,985 rows at Thu Aug 13 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
INSTANCE_PRIMARY_ID Primary key Asc PK_T_GPS_INSTANCES
INSTANCE_ID + INSTANCE_PRESENT Performance Asc/Asc T_GPS_INST_ID_INDEX
INSTANCE_ID + INSTANCE_PRESENT + WORKFLOW_TYPE_ID + CURRENT_STATE_ID Performance Asc/Asc/Asc/Asc T_GPS_INST_IDS_INDEX
INSTANCE_ID + INSTANCE_PRESENT + WORKFLOW_TYPE_ID + CURRENT_STATE_ID + FROM_STATE_ID Performance Asc/Asc/Asc/Asc/Asc T_GPS_INST_IDS_INDEX1
ACTIVE Performance Asc T_GPS_INSTANCES_CN1
CURRENT_STATE_ID Performance Asc T_GPS_INSTANCES_CN2
INSTANCE_ID Performance Asc T_GPS_INSTANCES_CN3
APPLICATION_ID + INSTANCE_ID Performance Asc/Asc T_GPS_INSTANCES_INDEX

Close relationships  within of separation: