Table HLPDTEST.STATEGPS.T_GPS_WORKFLOW_STATES 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
WORKFLOW_TYPE_ID number 22  √  null
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID FK_T_GPS_WORKFLOW_STATES C
STATE_ID number 22
MIG_COMPLETED_VS_DUE_DATE_V.STATE_ID Implied Constraint R
MYVIEW.STATE_ID Implied Constraint R
PROJECT_NATIVE_TASKS_V.STATE_ID Implied Constraint R
PROJECT_TASK_AUDIT_V.STATE_ID Implied Constraint R
T_BPM_APR_DOCUMENTS.STATE_ID STATE_ID_FKEY C
T_BPM_APR_WF_AUDIT.FROM_STATE_ID FROM_STATE_ID_FKEY C
T_BPM_APR_WF_AUDIT.TO_STATE_ID TO_STATE_ID_FKEY C
T_CM_MANAGER_COACH_PLAN.STATE_ID Implied Constraint R
T_GPS_APP_WORKFLOW_STATES_VIEW.STATE_ID Implied Constraint R
T_GPS_CONDITIONAL_STATE_CHANGE.FROM_STATE_ID SYS_C0010221 C
T_GPS_CONDITIONAL_STATE_CHANGE.TO_STATE_ID SYS_C0010220 C
T_GPS_CONDITIONAL_STATE_TRACK.TO_STATE_ID FK_CST_STATE_ID C
T_GPS_GOOGLE_MAP_SETUP.STATE_ID Implied Constraint R
T_GPS_INSTANCE_ACTIVE_TRACKING.CURRENT_STATE_ID ACTIVE_STATE_ID_FK C
T_GPS_INSTANCE_FEEDBACK_V.STATE_ID Implied Constraint R
T_GPS_INSTANCE_MOVETO_TRACKING.FROM_STATE_ID MOVETO_FROMSTATEID_FK C
T_GPS_INSTANCE_MOVETO_TRACKING.TO_STATE_ID MOVETO_TOSTATEID_FK C
T_GPS_INSTANCES.CURRENT_STATE_ID FK2_T_GPS_INSTANCES C
T_GPS_INSTANCES.FROM_STATE_ID FK3_T_GPS_INSTANCES C
T_GPS_MAIL_HISTORY.STATE_ID SYS_C0010232 C
T_GPS_NODEGROUPS.STATE_ID FK_T_GPS_NG_STATE_ID C
T_GPS_NODETYPE_STATES.STATE_ID FK_T_GPS_NODETYPE_STATES_WS C
T_GPS_OPERATION_ELBOWS.TO_STATE_ID FK_T_GPS_STATE_ID C
T_GPS_OPERATION_TO_STATES.TO_STATE_ID FK_T_GPS_OPERATION_TO_STATE_ID C
T_GPS_ROLE_STATES.FROM_STATE_ID FK_T_GPS_ROLE_STATES_WFS_F C
T_GPS_SHAREPOINT_INFO.STATE_ID FK1_T_GPS_SHAREPOINT_INFO C
T_GPS_STATE_EWORKSHEETS.STATE_ID FK_T_GPS_STATE_EWKS C
T_GPS_STATE_OPERATIONS.FROM_STATE_ID FK_T_GPS_STATE_OPER_FROM_STATE C
T_GPS_USER_STATES.FROM_STATE_ID SYS_C0010266 C
T_GPS_WF_INST_FAIL_REASONS.FROM_STATE_ID FK1_T_GPS_WF_INST_FAIL_REASONS C
T_GPS_WF_INSTANCE_HISTORY.STATE_ID Implied Constraint R
T_GPS_WF_INSTANCE_HISTORY_V.STATE_ID Implied Constraint R
T_GPS_WF_STATE_FEEDBACK_FORM.STATE_ID STATE_ID_FK C
T_GPS_WFMOVE_STATEOPERATIONS.STATE_ID FK_STATEID C
T_GPS_WORKFLOW_INSTANCES.STATE_ID Implied Constraint R
T_GPS_WORKFLOW_STATE_PROP.STATE_ID SYS_C0010227 C
T_GPS_WORKFLOWMOVE_STATE.STATE_ID FK_T_GPS_WORKFLOWMOVE_STATE C
T_INSTANCE_CHILD_DOCS.STATE_ID Implied Constraint R
T_INSTANCE_DOCUMENTS_V.STATE_ID Implied Constraint R
T_INSTANCE_PREDECESSOR.PRED_STATE_ID PRED_STATE_ID_FK C
T_PLANNED_ACCOMPLISHED.STATE_ID PA_STATE_ID_FK R
T_PROJECT_CURRENT_PLAN_TASKS_V.STATE_ID Implied Constraint R
T_PROJECT_DA_V.STATE_ID Implied Constraint R
T_PROJECT_NATIVE_TASK_V.STATE_ID Implied Constraint R
T_PROJECT_PLAN_REMOVED_TASKS_V.STATE_ID Implied Constraint R
T_PROJECT_PLAN_TAGS_V.STATE_ID Implied Constraint R
T_PROJECT_PLAN_TASKS_V.STATE_ID Implied Constraint R
T_PROJECT_TASK.STATE_ID FK_T_PROJECT_TASK C
T_PROJECT_TASK_V.STATE_ID Implied Constraint R
T_REPORTING_PLAN_TASK_DETAIL1.STATE_ID FK_PLAN_TASK_DET_STATE_I R
T_REPORTING_PLAN_TASK_DETAILS.STATE_ID FK_PLAN_TASK_DET_STATE_ID R
T_STARTED_TASKS_V.STATE_ID Implied Constraint R
T_SURVEYS.STATE_ID FK_T_SURVEYS_ST C
T_TAS_SOD_STATES.PARENT_STATE_ID FK_T_TAS_SOD_STATES_STATEID C
T_TAS_SOD_STATES.SOD_STATE_ID FK_T_TAS_SOD_STATES_SODSTATEID C
T_TASK_SLAS.STATE_ID TASK_ID_FOKEY C
T_TICKET_DETAILS_V.STATE_ID Implied Constraint R
T_TIME_TRACKING_DETAILS_V.STATE_ID Implied Constraint R
T_WORKFLOW_STATE_TASK_V.STATE_ID Implied Constraint R
V_TASKS_WHITEBOARD.STATE_ID Implied Constraint R
XXT_PROJECT_NAME_V.STATE_ID Implied Constraint R
STATE_NAME varchar2 255  √  null
GET_CONTROLLER_NAME varchar2 255  √  null
DESCRIPTION varchar2 1000  √  null
ATTRIBUTE_ID number 22  √  null
T_GPS_MODEL_SEARCH_ATTRIBUTES.ATTRIBUTE_ID Implied Constraint R
BUILDER_NAME varchar2 255  √  null
BUILD_FRAME_IMAGE varchar2 255  √  null
VIEWER_NAME varchar2 255  √  null
VIEW_FRAME_IMAGE varchar2 255  √  null
PROCESS_GET_CONTROLLER_NAME varchar2 255  √  null
EFFECTIVE_START_DATE date 7  √  null
EFFECTIVE_END_DATE date 7  √  null
UNDO_PUT_CONTROLLER_NAME varchar2 255  √  null
AND_STATE char 5  √  null
STATE_DESCRIPTOR varchar2 100  √  NULL
OR_STATE varchar2 5  √  null
X number 22  √  null
Y number 22  √  null
SUBWORKFLOW_STATE char 5  √  null
STARTNODE number 22  √  null
MAIL_HANDLER_OBJECT_MAKER varchar2 255  √  null
VISIBLE_FLAG varchar2 10  √  'true'
STATE_ORDER number 22  √  null
COLLABORATIVE_FLAG varchar2 20  √  null
FDT_ALIAS_NAME varchar2 255  √  null
FDT_FILE_NAME varchar2 255  √  null
STATE_TYPE varchar2 50  √  null
IMAGE varchar2 4000  √  null
DISPLAY_ORDER number 10  √  null
ERROR_MESSAGE varchar2 4000  √  null
REPORTING_PLAN_TAG_ID number 22  √  null
PROJECT_TAG_ID number 22  √  null
T_PROJECT_PLAN_TAGS.PROJECT_TAG_ID WORKFLOW_STATES_PROJECT_TAG_FG R

Table contained 24,035 rows at Mon Mar 01 01:05 IST 2021

Indexes:
Column(s) Type Sort Constraint Name
STATE_ID Primary key Asc SYS_C0010144
WORKFLOW_TYPE_ID + STATE_NAME + STATE_ID Performance Asc/Asc/Asc T_GPS_WORKFLOW_STATES_INDEX
STATE_NAME Performance Asc T_GPS_WORKFLOW_STATES_SNINDX
WORKFLOW_TYPE_ID Performance Asc T_GPS_WORKFLOW_STS_WFTYPE

Close relationships  within of separation: