Table HLPDTEST.STATEGPS.T_GPS_WORKFLOW_TYPES 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_WORKFLOW_TYPES C
WORKFLOW_TYPE_ID number 22
MIG_COMPLETED_VS_DUE_DATE_V.WORKFLOW_TYPE_ID Implied Constraint R
MYVIEW.WORKFLOW_TYPE_ID Implied Constraint R
T_APP_NT_PARENT_RELATIONSHIP.WORKFLOW_TYPE_ID FK_NT_PARENT_REL_WKF_TYPE_ID C
T_APP_ROOT_NODETYPES.WORKFLOW_TYPE_ID FK_T_APP_ROOT_NT_WFT_ID C
T_DUE_TASKS_V.WORKFLOW_TYPE_ID Implied Constraint R
T_GPS_APP_WORKFLOW_STATES_VIEW.WORKFLOW_TYPE_ID Implied Constraint R
T_GPS_APP_WORKFLOW_VIEW.WORKFLOW_TYPE_ID Implied Constraint R
T_GPS_APPLICATION_NODE_TYPES.WORKFLOW_TYPE_ID Implied Constraint R
T_GPS_INSTANCE_FEEDBACK_V.WORKFLOW_TYPE_ID Implied Constraint R
T_GPS_INSTANCES.WORKFLOW_TYPE_ID FK1_T_GPS_INSTANCES C
T_GPS_MAIL_HISTORY.WORKFLOW_TYPE_ID Implied Constraint R
T_GPS_NOTIFICATION_DETAILS.WORKFLOW_TYPE_ID FK_T_GPS_NOTIF_DETAILS_WT C
T_GPS_PROJECT_SCENARIOS.WORKFLOW_TYPE_ID T_GPS_PROJECT_SCENARIOS_FK2 C
T_GPS_ROLE_WORKFLOW_TYPES.WORKFLOW_TYPE_ID FK_T_GPS_ROLE_WF_WFT C
T_GPS_STATE_OPERATIONS.WORKFLOW_TYPE_ID FK_WORKFLOW_TYPE_ID C
T_GPS_USER_WORKFLOW_TYPES.WORKFLOW_TYPE_ID FK_T_GPS_USER_WF_UWFT C
T_GPS_WF_INSTANCE_HISTORY.WORKFLOW_TYPE_ID Implied Constraint R
T_GPS_WF_INSTANCE_HISTORY_V.WORKFLOW_TYPE_ID Implied Constraint R
T_GPS_WFT_PROPERTIES.WORKFLOW_TYPE_ID FK_T_GPS_WFT_PROPERTIES C
T_GPS_WORKFLOW_INSTANCES.WORKFLOW_TYPE_ID FK1_T_GPS_WORKFLOW_INSTANCES C
T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID FK_T_GPS_WORKFLOW_STATES C
T_GPS_WORKFLOWMOVE_STATE.WORKFLOW_TYPE_ID Implied Constraint R
T_INSTANCES.WORKFLOW_TYPE_ID Implied Constraint R
T_ISSUES_CREATED_BY_ME_V.WORKFLOW_TYPE_ID Implied Constraint R
T_PROCESS_SLAS.WORKFLOW_TYPE_ID PROCESS_ID_FOKEY C
T_PROJECT_CRITICAL_TASKS_V.WORKFLOW_TYPE_ID Implied Constraint R
T_PROJECT_DUE_DATES_V.WORKFLOW_TYPE_ID Implied Constraint R
T_PROJECT_ISSUES_STATUS_V.WORKFLOW_TYPE_ID Implied Constraint R
T_PROJECT_TASK_V.WORKFLOW_TYPE_ID Implied Constraint R
T_REPORTING_PLAN_TASK_DETAIL1.WORKFLOW_ID FK_PLAN_TASK_DET_WORKFLOW_I R
T_REPORTING_PLAN_TASK_DETAILS.WORKFLOW_ID FK_PLAN_TASK_DET_WORKFLOW_ID R
T_REPORTING_PLAN_TASKS.WORKFLOW_ID FK_T_REPRT_PLAN_TSK_WKF_ID R
T_STARTED_TASKS_V.WORKFLOW_TYPE_ID Implied Constraint R
T_SUPPORT_INVOICE_SCHEDULES.PROCESS_ID PROCESS_ID_FK C
T_TICKET_DETAILS_V.WORKFLOW_TYPE_ID Implied Constraint R
T_TRI2_WORKFLOW_MODULE.WORKFLOW_TYPE_ID SYS_C0033927 R
T_WORKFLOW_PREDECESSOR.PRED_WORKFLOW_ID PRED_WORKFLOW_ID_FK C
T_WORKFLOW_PREDECESSOR.WORKFLOW_ID WORKFLOW_ID_FK C
V_TASKS_WHITEBOARD.WORKFLOW_TYPE_ID Implied Constraint R
WORKFLOW_TYPE_NAME varchar2 255
DESCRIPTION varchar2 1000  √  null
FROZEN_FLAG varchar2 255  √  null
CYCLE_TIME number 22  √  NULL
CYCLE_TIME_UNIT varchar2 20  √  NULL
CYCLE_TIME_MODE varchar2 25  √  NULL
SUBWORKFLOW_ID number 22  √  null
VERSION number 22  √  null
VISIBLE_FLAG varchar2 10  √  'true'
WORKFLOW_ORDER number 22  √  null
CREATED_BY varchar2 255  √  null
LAST_UPDATED_BY varchar2 255  √  null
CREATED_DATE date 7  √  now
LAST_UPDATED_DATE date 7  √  now
WORKFLOW_IMAGE varchar2 255  √  null
DISPLAY_NAME varchar2 255  √  null
DISPLAYON_PORTAL varchar2 5  √  'true'
GROUP_NAME varchar2 255  √  null
SEND_DEFAULT_MAIL varchar2 20  √  'false'
ROOT_NODE_VIOLATION_MESSAGE varchar2 4000  √  null
ENABLE_ESIGNATURE varchar2 10  √  null
VISIBLE_IN_SEARCH varchar2 10  √  'true'
FOLDER_ID number 22  √  null
T_GPS_VIEWER_INSTANCES_SET.SET_ID FK_WT_FOLDER_ID C
To link workflow types with viewer instances set

Table contained 4,180 rows at Fri Oct 30 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name Anomalies
WORKFLOW_TYPE_ID Primary key Asc SYS_C0010146  
VISIBLE_FLAG Performance Asc T_GPS_WORKFLOW_TYPES_CN1  
APPLICATION_ID + VISIBLE_FLAG Performance Asc/Asc T_GPS_WORKFLOW_TYPES_CN2  
WORKFLOW_TYPE_NAME + APPLICATION_ID Performance Asc/Asc T_GPS_WORKFLOW_TYPES_INDEX  
APPLICATION_ID + DISPLAY_NAME Must be unique Asc/Asc UK1_T_GPS_WORKFLOW_TYPES These unique columns are also nullable

Close relationships  within of separation: