SchemaSpy Analysis of HLPDTEST.STATEGPS - Constraints Generated by
SchemaSpy
362 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
ACTIVE_INSTANCE_ID_FK T_GPS_INSTANCE_ACTIVE_TRACKING.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
ACTIVE_STATE_ID_FK T_GPS_INSTANCE_ACTIVE_TRACKING.CURRENT_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
CON_FK_OPERATION_ID T_GPS_USER_OPERATIONS.OPERATION_ID T_GPS_STATE_OPERATIONS.OPERATION_ID Cascade on delete 
CON_FK_USER_STATE_ID T_GPS_USER_OPERATIONS.USER_STATE_ID T_GPS_USER_STATES.USER_STATE_ID Cascade on delete 
CON_OPERATION_ID T_GPS_ROLE_OPERATIONS.OPERATION_ID T_GPS_STATE_OPERATIONS.OPERATION_ID Cascade on delete 
CON_ROLE_STATE_ID T_GPS_ROLE_OPERATIONS.ROLE_STATE_ID T_GPS_ROLE_STATES.ROLE_STATE_ID Cascade on delete 
CUST_ID_FK T_SUPPORT_TYPE.CUSTOMER_ID T_CUSTOMERS.CUSTOMER_ID Restrict delete 
CUSTOM_SET_ID_FKEY T_BPM_PUBLISHED_MODEL_VERSIONS.CUSTOM_SET_ID T_GPS_CUSTOM_SETS.CUSTOM_SET_ID Cascade on delete 
CUSTOMER_ID_FK T_PROJECT_RESOURCE_RATES.CUSTOMER_ID T_CUSTOMERS.CUSTOMER_ID Restrict delete 
EDIT_CONDITION_FK T_GPS_NODE_EDIT_CONDITIONS.PROPERTY_ID T_GPS_NT_ST_CLASS_PROPS.PROPERTY_ID Cascade on delete 
EXEPLAN_PROJECT_ID T_EXEPLAN_HISTORY.PROJECT_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
EXPRESSION_TRACK_FK T_GPS_COND_STAT_TRACK_SETS.EXPRESSION_TRACK_ID T_GPS_CONDITIONAL_STATE_TRACK.EXPRESSION_TRACK_ID Cascade on delete 
FK1_T_GPS_INSTANCE_LINKS T_GPS_INSTANCE_LINKS.FROM_INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
FK1_T_GPS_INSTANCES T_GPS_INSTANCES.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
FK1_T_GPS_SHAREPOINT_INFO T_GPS_SHAREPOINT_INFO.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK1_T_GPS_VWR_PROPERTY_ORDER T_GPS_VIEWER_PROPERTY_ORDER.PROPERTY_ID T_GPS_VIEWER_INST_CLASS_PROPS.PROPERTY_ID Cascade on delete 
FK1_T_GPS_WF_INST_FAIL_REASONS T_GPS_WF_INST_FAIL_REASONS.FROM_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK1_T_GPS_WORKFLOW_INSTANCES T_GPS_WORKFLOW_INSTANCES.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
FK1_T_PROJECT_TASK T_PROJECT_TASK.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
FK1_T_REPORTING_PLAN_TASKS T_REPORTING_PLAN_TASKS.HISTORY_ID T_REPORTING_PLAN_HISTORY.HISTORY_ID Cascade on delete 
FK2_T_GPS_INSTANCE_LINKS T_GPS_INSTANCE_LINKS.TO_INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
FK2_T_GPS_INSTANCES T_GPS_INSTANCES.CURRENT_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK3_T_GPS_INSTANCES T_GPS_INSTANCES.FROM_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_2_T_GPS_APPLICATIONS T_RESOURCE_USAGE.PROJECT_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_2_T_PROJECT_TASK T_RESOURCE_USAGE.PROJECT_TASK_ID T_PROJECT_TASK.PROJECT_TASK_ID Cascade on delete 
FK_APP_ID T_APP_GROUPS.APP_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_APP_ID_PRU T_PROJECT_ROLE_USERS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_AUTHSYS_ID T_GPS_AD_CONFIG.AUTHSYS_ID T_GPS_AUTH_SYS_CONFIG.AUTHSYS_ID Cascade on delete 
FK_BASELINE_EXEC_ID T_REPORTING_PLAN_TASK_DETAILS.BASELINE_EXECUTION_ID T_REPORTING_PLAN_HISTORY.HISTORY_ID Restrict delete 
FK_CATEGORY_ID T_APP_GROUPS.CATEGORY_ID T_CATEGORIES.CATEGORY_ID Cascade on delete 
FK_CS_FOLDER_ID T_GPS_CUSTOM_SETS.FOLDER_ID T_GPS_VIEWER_INSTANCES_SET.SET_ID Cascade on delete 
FK_CST_OPERATION_ID T_GPS_CONDITIONAL_STATE_TRACK.OPERATION_ID T_GPS_STATE_OPERATIONS.OPERATION_ID Cascade on delete 
FK_CST_STATE_ID T_GPS_CONDITIONAL_STATE_TRACK.TO_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_CUSTOMLINK_MAPPINGS T_GPS_VDD_CUSTOMLINK_MAPPINGS.DRILL_DOWN_PROPERTY_ID T_GPS_DRILL_DOWN_PROPERTIES.DRILL_DOWN_PROPERTY_ID Cascade on delete 
FK_DD_PROPERTY_ID T_GPS_DRILL_DOWN_CONDITION.DRILL_DOWN_PROPERTY_ID T_GPS_DRILL_DOWN_PROPERTIES.DRILL_DOWN_PROPERTY_ID Cascade on delete 
FK_EDIT_CONDITION T_GPS_VIEWER_EDIT_CONDITIONS.CONFIGURATION_ID T_GPS_VIEWER_EDIT_CONFIG.CONFIGURATION_ID Cascade on delete 
FK_EDIT_CONFIGURATION T_GPS_VIEWER_EDIT_CONFIG.PROPERTY_ID T_GPS_VIEWER_INST_CLASS_PROPS.PROPERTY_ID Cascade on delete 
FK_EWKS_GRAPH_CONFIG_DATA T_GPS_VIEWER_ADV_GRAPH_DATA.EWKS_GRAPH_CONFIG_ID T_GPS_VIEWER_ADV_GRAPH_CONFIG.EWKS_GRAPH_CONFIG_ID Cascade on delete 
FK_EWKS_GRAPH_CONFIGURATION T_GPS_VIEWER_ADV_GRAPH_DATA.GRAPH_ID T_GPS_VIEWER_GRAPH_DETAILS.GRAPH_ID Cascade on delete 
FK_FAV_HISTORY_APPID T_GPS_FAVOURITES_HISTORY.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Restrict delete 
FK_GPH_CLR_CONS T_GPS_GRAPH_COLOR_CONDITIONS.GRAPH_ID T_GPS_VIEWER_GRAPH_DETAILS.GRAPH_ID Cascade on delete 
FK_GPS_ROLE_CUSTOM_SETS T_GPS_ROLE_CUSTOM_SETS.CUSTOM_SET_ID T_GPS_CUSTOM_SETS.CUSTOM_SET_ID Cascade on delete 
FK_GPS_USER_CUSTOM_SETS T_GPS_USER_CUSTOM_SETS.CUSTOM_SET_ID T_GPS_CUSTOM_SETS.CUSTOM_SET_ID Cascade on delete 
FK_INSTANCE_FEEDBACK_PRIMARYID T_GPS_INSTANCE_FEEDBACK.INSTANCE_PRIMARY_ID T_GPS_INSTANCES.INSTANCE_PRIMARY_ID Cascade on delete 
FK_INSTANCE_FEEDBACK_QUESTION T_GPS_INSTANCE_FEEDBACK.QUESTION_ID T_GPS_WF_STATE_FEEDBACK_FORM.QUESTION_ID Cascade on delete 
FK_INSTANCE_ID T_GPS_CONDITIONAL_STATE_TRACK.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
FK_MAIL_HISTORY_ID T_GPS_MAIL_ATTACHMENT.MAIL_HISTORY_ID T_GPS_MAIL_HISTORY.MAIL_HISTORY_ID Cascade on delete 
FK_MODEL_SR_ATT_CLASS_PROPS T_GPS_MODEL_SR_ATT_CLASS_PROPS.CLASS_ID T_GPS_MODEL_SR_ATT_CLASSES.CLASS_ID Cascade on delete 
FK_NOTIFICATION_DETAILS_ID T_GPS_CONDITIONAL_STATE_CHANGE.NOTIFICATION_DETAILS_ID T_GPS_NOTIFICATION_DETAILS.NOTIFICATION_DETAILS_ID Cascade on delete 
FK_NT_PARENT_REL_APP_ID T_APP_NT_PARENT_RELATIONSHIP.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_NT_PARENT_REL_NT_ID T_APP_NT_PARENT_RELATIONSHIP.PARENT_NODETYPE_ID T_GPS_NODETYPES.NODETYPE_ID Cascade on delete 
FK_NT_PARENT_REL_WKF_TYPE_ID T_APP_NT_PARENT_RELATIONSHIP.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
FK_OPERATION_ID T_GPS_WFMOVE_STATEOPERATIONS.OPERATION_ID T_GPS_STATE_OPERATIONS.OPERATION_ID Cascade on delete 
FK_PLAN_TASK_DET_EXE_I T_REPORTING_PLAN_TASK_DETAIL1.EXECUTION_ID T_REPORTING_PLAN_HISTORY.HISTORY_ID Restrict delete 
FK_PLAN_TASK_DET_EXE_ID T_REPORTING_PLAN_TASK_DETAILS.EXECUTION_ID T_REPORTING_PLAN_HISTORY.HISTORY_ID Restrict delete 
FK_PLAN_TASK_DET_PRJ_TASK_I T_REPORTING_PLAN_TASK_DETAIL1.PROJECT_TASK_ID T_PROJECT_TASK.PROJECT_TASK_ID Restrict delete 
FK_PLAN_TASK_DET_PRJ_TASK_ID T_REPORTING_PLAN_TASK_DETAILS.PROJECT_TASK_ID T_PROJECT_TASK.PROJECT_TASK_ID Restrict delete 
FK_PLAN_TASK_DET_PROJECT_I T_REPORTING_PLAN_TASK_DETAIL1.PROJECT_ID T_GPS_APPLICATIONS.APPLICATION_ID Restrict delete 
FK_PLAN_TASK_DET_PROJECT_ID T_REPORTING_PLAN_TASK_DETAILS.PROJECT_ID T_GPS_APPLICATIONS.APPLICATION_ID Restrict delete 
FK_PLAN_TASK_DET_STATE_I T_REPORTING_PLAN_TASK_DETAIL1.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Restrict delete 
FK_PLAN_TASK_DET_STATE_ID T_REPORTING_PLAN_TASK_DETAILS.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Restrict delete 
FK_PLAN_TASK_DET_WORKFLOW_I T_REPORTING_PLAN_TASK_DETAIL1.WORKFLOW_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Restrict delete 
FK_PLAN_TASK_DET_WORKFLOW_ID T_REPORTING_PLAN_TASK_DETAILS.WORKFLOW_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Restrict delete 
FK_PROJECT_ID T_REPORTING_PLAN_HISTORY.PROJECT_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_PROJECT_TASK_ID T_SCRIPT_REPLAY_RESULTS.PROJECT_TASK_ID T_PROJECT_TASK.PROJECT_TASK_ID Cascade on delete 
FK_ROLE_LEVEL_EWKS_ACTIONS T_GPS_ROLE_LEVEL_EWKS_ACTIONS.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
FK_ROLE_STATE_ID T_GPS_ROLE_NODETYPE_STATES.ROLE_STATE_ID T_GPS_ROLE_STATES.ROLE_STATE_ID Cascade on delete 
FK_STATE_OPERATION T_GPS_STATE_EDIT_OPERATIONS.OPERATION_ID T_GPS_STATE_OPERATIONS.OPERATION_ID Cascade on delete 
FK_STATEID T_GPS_WFMOVE_STATEOPERATIONS.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_APP_NT_REL_CHILD_NT_ID T_APP_NODETYPES_RELATIONSHIP.CHILD_NODETYPE_ID T_GPS_NODETYPES.NODETYPE_ID Cascade on delete 
FK_T_APP_NT_REL_PARENT_REL_ID T_APP_NODETYPES_RELATIONSHIP.NT_PARENT_RELATIONSHIP_ID T_APP_NT_PARENT_RELATIONSHIP.NT_PARENT_RELATIONSHIP_ID Cascade on delete 
FK_T_APP_ROOT_NT_APP_ID T_APP_ROOT_NODETYPES.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_APP_ROOT_NT_ID T_APP_ROOT_NODETYPES.ROOT_NODETYPE_ID T_GPS_NODETYPES.NODETYPE_ID Cascade on delete 
FK_T_APP_ROOT_NT_WFT_ID T_APP_ROOT_NODETYPES.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
FK_T_CHILD_CATEGORIES1 T_CHILD_CATEGORIES.CATEGORY_ID T_CATEGORIES.CATEGORY_ID Cascade on delete 
FK_T_CHILD_CATEGORIES2 T_CHILD_CATEGORIES.CHILD_CATEGORY_ID T_CATEGORIES.CATEGORY_ID Cascade on delete 
FK_T_CM_AFTER_ACTION_REVIEW T_CM_AFTER_ACTION_REVIEW.CHANGE_PROCESS_ID T_CHANGE_MANAGEMENT_PROCESS.CHANGE_PROCESS_ID Cascade on delete 
FK_T_CM_AUDIENCE_INFO T_CM_AUDIENCE_INFO.CHANGE_PROCESS_ID T_CHANGE_MANAGEMENT_PROCESS.CHANGE_PROCESS_ID Cascade on delete 
FK_T_CM_COMMUNICATION_PLAN T_CM_COMMUNICATION_PLAN.CM_AUDIENCE_ID T_CM_AUDIENCE_INFO.CM_AUDIENCE_ID Cascade on delete 
FK_T_CM_COMPLIANCE_AUDIT T_CM_COMPLIANCE_AUDIT.CHANGE_PROCESS_ID T_CHANGE_MANAGEMENT_PROCESS.CHANGE_PROCESS_ID Cascade on delete 
FK_T_CM_IDENTIFY_RC_PR T_CM_IDENTIFY_RC_PR.CHANGE_PROCESS_ID T_CHANGE_MANAGEMENT_PROCESS.CHANGE_PROCESS_ID Cascade on delete 
FK_T_CM_MANAGER_COACH_PLAN T_CM_MANAGER_COACH_PLAN.CHANGE_PROCESS_ID T_CHANGE_MANAGEMENT_PROCESS.CHANGE_PROCESS_ID Cascade on delete 
FK_T_CM_PROJECT_TEAM_INFO T_CM_PROJECT_TEAM_INFO.CHANGE_PROCESS_ID T_CHANGE_MANAGEMENT_PROCESS.CHANGE_PROCESS_ID Cascade on delete 
FK_T_CM_RESISTANCE_MGMT_PLAN T_CM_RESISTANCE_MGMT_PLAN.CHANGE_PROCESS_ID T_CHANGE_MANAGEMENT_PROCESS.CHANGE_PROCESS_ID Cascade on delete 
FK_T_CM_SPONSOR_ROADMAP T_CM_SPONSOR_ROADMAP.CHANGE_PROCESS_ID T_CHANGE_MANAGEMENT_PROCESS.CHANGE_PROCESS_ID Cascade on delete 
FK_T_CM_TRAINING_AUDIENCE T_CM_TRAINING_AUDIENCE_PLAN.CHANGE_PROCESS_ID T_CHANGE_MANAGEMENT_PROCESS.CHANGE_PROCESS_ID Cascade on delete 
FK_T_GPS_APP_PROPERTIES T_GPS_APP_PROPERTIES.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_APPLICATIONS T_PROJECT_DETAILS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_CLASS_TABGROUP_CHILDS T_GPS_CLASS_TABGROUP_CHILDS.TAB_ID T_GPS_CLASS_TABGROUPS.TAB_ID Cascade on delete 
FK_T_GPS_CLASS_TABGROUPS T_GPS_CLASS_TABGROUPS.CLASS_ID T_GPS_NT_STATE_CLASSES.CLASS_ID Cascade on delete 
FK_T_GPS_CM_PT_CLASS_PROPS T_GPS_CM_PT_CLASS_PROPS.CLASS_ID T_GPS_COM_PATH_CLASSES.CLASS_ID Cascade on delete 
FK_T_GPS_COM_PATH_CLASSES T_GPS_COM_PATH_CLASSES.COMPRESSED_PATH_ID T_GPS_COMPRESSED_PATHS.COMPRESSED_PATH_ID Cascade on delete 
FK_T_GPS_COMPRESSED_PATHS T_GPS_COMPRESSED_PATHS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_CUSTOM_SETS T_GPS_CUSTOM_SETS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_DBV_APPLICATION T_GPS_DBV_USER_APPLICATIONS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_DBV_USER_APPLICATIONS T_GPS_DBV_USER_APPLICATIONS.DBV_USER_ID T_GPS_DBV_USERS.DBV_USER_ID Cascade on delete 
FK_T_GPS_DEFAULT_CONDITIONS T_GPS_VIEWER_DEFAULTCONDITIONS.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
FK_T_GPS_DRILL_DOWN_PROPERTIES T_GPS_DRILL_DOWN_PROPERTIES.PROPERTY_ID T_GPS_VIEWER_INST_CLASS_PROPS.PROPERTY_ID Cascade on delete 
FK_T_GPS_EWKS_WF_MAPPING T_GPS_EWKS_WF_INSTANCE_MAPPING.EWORKSHEET_ID T_GPS_STATE_EWORKSHEETS.EWORKSHEET_ID Cascade on delete 
FK_T_GPS_EXCLUSIVE_SETS T_GPS_EXCLUSIVE_SETS.NODETYPE_STATE_ID T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID Cascade on delete 
FK_T_GPS_FAV_APPLICATION T_GPS_FAVOURITE_LINKS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_FAVOURITE_LINKS T_GPS_FAVOURITE_LINKS.DBV_USER_ID T_GPS_DBV_USERS.DBV_USER_ID Cascade on delete 
FK_T_GPS_FAVOURITES_HISTORY T_GPS_FAVOURITES_HISTORY.DBV_USER_ID T_GPS_DBV_USERS.DBV_USER_ID Cascade on delete 
FK_T_GPS_FDTS_PARAMETERS T_GPS_APP_FDTS_PARAMETERS.MODEL_FDT_ID T_GPS_APP_MODEL_VALID_RULES.MODEL_FDT_ID Cascade on delete 
FK_T_GPS_FDTS_PARAMHASH T_GPS_APP_FDTS_PARAMHASH.PARAMETER_ID T_GPS_APP_FDTS_PARAMETERS.PARAMETER_ID Cascade on delete 
FK_T_GPS_IF_CHANGED_PROPERTY T_GPS_IF_CHANGED_PROPERTY.CHANGE_SET_ID T_GPS_PROPERTY_CHANGE_SETS.CHANGE_SET_ID Cascade on delete 
FK_T_GPS_INST_PROPERTIES T_GPS_INSTANCE_PROPERTIES.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
FK_T_GPS_INSTANCES T_GPS_INSTANCES.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_MASTER_MODELS T_GPS_MASTER_MODELS.CATEGORY_ID T_CATEGORIES.CATEGORY_ID Cascade on delete 
FK_T_GPS_MENUCONFIG T_GPS_MENUCONFIG.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_MENUCONFIG_RELATIONS T_GPS_MENUCONFIG_RELATIONS.MENU_ID T_GPS_MENUCONFIG.MENU_ID Cascade on delete 
FK_T_GPS_MODEL_NODE_ID T_GPS_MODELS.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
FK_T_GPS_MODEL_SEARCH_ATTBTS T_GPS_MODEL_SEARCH_ATTRIBUTES.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_MODEL_SR_ATT_CLASSES T_GPS_MODEL_SR_ATT_CLASSES.ATTRIBUTE_ID T_GPS_MODEL_SEARCH_ATTRIBUTES.ATTRIBUTE_ID Cascade on delete 
FK_T_GPS_MODEL_VALID_RULES T_GPS_APP_MODEL_VALID_RULES.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_NEXT_NODES_1 T_GPS_NEXT_NODES.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
FK_T_GPS_NEXT_NODES_2 T_GPS_NEXT_NODES.NEXT_NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
FK_T_GPS_NG_APP_ID T_GPS_NODEGROUPS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_NG_STATE_ID T_GPS_NODEGROUPS.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_GPS_NODE_ID T_GPS_CONNECTOR_ELBOWPOINTS.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
FK_T_GPS_NODE_RA_PROEPRTIES T_GPS_NODE_RA_PROPERTIES.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
FK_T_GPS_NODEGROUP_CHILDS T_GPS_NODEGROUP_CHILDS.GROUP_ID T_GPS_NODEGROUPS.GROUP_ID Cascade on delete 
FK_T_GPS_NODENAME_ORDERS T_GPS_NODENAME_ORDERS.NODETYPE_STATE_ID T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID Cascade on delete 
FK_T_GPS_NODETYPE_STATES_APP T_GPS_NODETYPE_STATES.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_NODETYPE_STATES_NT T_GPS_NODETYPE_STATES.NODETYPE_ID T_GPS_NODETYPES.NODETYPE_ID Cascade on delete 
FK_T_GPS_NODETYPE_STATES_WS T_GPS_NODETYPE_STATES.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_GPS_NOTIF_DETAILS_WT T_GPS_NOTIFICATION_DETAILS.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
FK_T_GPS_NOTIFICATION_DETAILS T_GPS_NOTIFICATION_DETAILS.OPERATION_ID T_GPS_STATE_OPERATIONS.OPERATION_ID Cascade on delete 
FK_T_GPS_NT_ST_CLASS_PROPS T_GPS_NT_ST_CLASS_PROPS.CLASS_ID T_GPS_NT_STATE_CLASSES.CLASS_ID Cascade on delete 
FK_T_GPS_NT_STATE_CLASSES T_GPS_NT_STATE_CLASSES.NODETYPE_STATE_ID T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID Cascade on delete 
FK_T_GPS_OPER_ID T_GPS_OPERATION_ELBOWS.OPERATION_ID T_GPS_STATE_OPERATIONS.OPERATION_ID Cascade on delete 
FK_T_GPS_OPERATION_ALG T_GPS_OPERATION_ALGORITHM.OPERATION_ID T_GPS_STATE_OPERATIONS.OPERATION_ID Cascade on delete 
FK_T_GPS_OPERATION_PROPS T_GPS_OPERATION_PROPERTIES.OPERATION_ID T_GPS_STATE_OPERATIONS.OPERATION_ID Cascade on delete 
FK_T_GPS_OPERATION_TO_STATE_ID T_GPS_OPERATION_TO_STATES.TO_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_GPS_OPERATION_TO_STATES T_GPS_OPERATION_TO_STATES.OPERATION_ID T_GPS_STATE_OPERATIONS.OPERATION_ID Cascade on delete 
FK_T_GPS_PREVIOUS_NODES_1 T_GPS_PREVIOUS_NODES.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
FK_T_GPS_PREVIOUS_NODES_2 T_GPS_PREVIOUS_NODES.PREVIOUS_NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
FK_T_GPS_PROPERTY_CHANGE_SETS T_GPS_PROPERTY_CHANGE_SETS.NODETYPE_STATE_ID T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID Cascade on delete 
FK_T_GPS_PROPERTY_ORDER T_GPS_PROPERTY_ORDER.TAB_ID T_GPS_CLASS_TABGROUPS.TAB_ID Cascade on delete 
FK_T_GPS_PRTY_CHANGE_GROUPS T_GPS_PROPERTY_CHANGE_GROUPS.CHANGE_SET_ID T_GPS_PROPERTY_CHANGE_SETS.CHANGE_SET_ID Cascade on delete 
FK_T_GPS_RELATION_CLASSES T_GPS_RELATION_CLASSES.RELATION_ID T_GPS_RELATIONS.RELATION_ID Cascade on delete 
FK_T_GPS_RELATIONS_APP_ID T_GPS_RELATIONS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_RLTION_CLASS_PROPS T_GPS_RLTION_CLASS_PROPS.CLASS_ID T_GPS_RELATION_CLASSES.CLASS_ID Cascade on delete 
FK_T_GPS_ROLE_APP_ID T_GPS_ROLE_NODETYPES.ROLE_APP_ID T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID Cascade on delete 
FK_T_GPS_ROLE_APPOPERATION T_GPS_ROLE_APP_OPERATIONS.ROLE_APP_ID T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID Cascade on delete 
FK_T_GPS_ROLE_APPOPERATION_ID T_GPS_ROLE_APP_OPERATIONS.OPERATION_ID T_GPS_WF_DISABLED_OPERATIONS.OPERATION_ID Cascade on delete 
FK_T_GPS_ROLE_CAT_APP_ID T_GPS_ROLE_CATEGORIES.ROLE_APP_ID T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID Cascade on delete 
FK_T_GPS_ROLE_CATEGORIES_CAT T_GPS_ROLE_CATEGORIES.CATEGORY_ID T_CATEGORIES.CATEGORY_ID Cascade on delete 
FK_T_GPS_ROLE_CUSTOM_SETS T_GPS_ROLE_CUSTOM_SETS.ROLE_APP_ID T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID Cascade on delete 
FK_T_GPS_ROLE_INSTANCE_F T_GPS_ROLE_VIEWER_INSTANCES.VIEWER_INSTANCE_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
FK_T_GPS_ROLE_NODETYPES_NT T_GPS_ROLE_NODETYPES.NODETYPE_ID T_GPS_NODETYPES.NODETYPE_ID Cascade on delete 
FK_T_GPS_ROLE_STATES_RWT_F T_GPS_ROLE_STATES.ROLE_WORKFLOW_TYPE_ID T_GPS_ROLE_WORKFLOW_TYPES.ROLE_WORKFLOW_TYPE_ID Cascade on delete 
FK_T_GPS_ROLE_STATES_WFS_F T_GPS_ROLE_STATES.FROM_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_GPS_ROLE_VIEWER_APP_ID T_GPS_ROLE_VIEWER_SETS.ROLE_APP_ID T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID Cascade on delete 
FK_T_GPS_ROLE_VIEWERSET T_GPS_ROLE_VIEWER_SETS.SET_ID T_GPS_VIEWER_INSTANCES_SET.SET_ID Cascade on delete 
FK_T_GPS_ROLE_VIEWERSET_F T_GPS_ROLE_VIEWER_INSTANCES.ROLE_VIEWERSET_ID T_GPS_ROLE_VIEWER_SETS.ROLE_VIEWERSET_ID Cascade on delete 
FK_T_GPS_ROLE_WF_WFT T_GPS_ROLE_WORKFLOW_TYPES.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
FK_T_GPS_ROLE_WFT_APP_ID T_GPS_ROLE_WORKFLOW_TYPES.ROLE_APP_ID T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID Cascade on delete 
FK_T_GPS_ROLES_APP_ID T_GPS_ROLE_APPLICATIONS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_ROLES_ROLE_ID T_GPS_ROLE_APPLICATIONS.ROLE_ID T_GPS_ROLES.ROLE_ID Cascade on delete 
FK_T_GPS_ROUTING_NOTIF T_GPS_ROUTING_NOTIFICATION.OPERATION_ID T_GPS_STATE_OPERATIONS.OPERATION_ID Cascade on delete 
FK_T_GPS_SET_GROUPS T_GPS_SET_GROUPS.SET_ID T_GPS_EXCLUSIVE_SETS.SET_ID Cascade on delete 
FK_T_GPS_SHAREPOINT_INFO T_GPS_SHAREPOINT_INFO.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
FK_T_GPS_STATE_EWKS T_GPS_STATE_EWORKSHEETS.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_GPS_STATE_ID T_GPS_OPERATION_ELBOWS.TO_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_GPS_STATE_OPER_FROM_STATE T_GPS_STATE_OPERATIONS.FROM_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_GPS_USER_APPOPERATION T_GPS_USER_APP_OPERATIONS.OPERATION_ID T_GPS_WF_DISABLED_OPERATIONS.OPERATION_ID Cascade on delete 
FK_T_GPS_USER_APPOPERATION_ID T_GPS_USER_APP_OPERATIONS.USER_APP_ID T_GPS_USER_APPLICATIONS.USER_APP_ID Cascade on delete 
FK_T_GPS_USER_CAT_ID T_GPS_USER_CATEGORIES.CATEGORY_ID T_CATEGORIES.CATEGORY_ID Cascade on delete 
FK_T_GPS_USER_CUSTOM_SETS T_GPS_USER_CUSTOM_SETS.USER_APP_ID T_GPS_USER_APPLICATIONS.USER_APP_ID Cascade on delete 
FK_T_GPS_USER_INSTANCE_F T_GPS_USER_VIEWER_INSTANCES.VIEWER_INSTANCE_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
FK_T_GPS_USER_NT_ID T_GPS_USER_NODETYPES.NODETYPE_ID T_GPS_NODETYPES.NODETYPE_ID Cascade on delete 
FK_T_GPS_USER_NT_USER_APP T_GPS_USER_NODETYPES.USER_APP_ID T_GPS_USER_APPLICATIONS.USER_APP_ID Cascade on delete 
FK_T_GPS_USER_USER_APP_ID T_GPS_USER_CATEGORIES.USER_APP_ID T_GPS_USER_APPLICATIONS.USER_APP_ID Cascade on delete 
FK_T_GPS_USER_VIEWER_APP_ID T_GPS_USER_VIEWER_SETS.USER_APP_ID T_GPS_USER_APPLICATIONS.USER_APP_ID Cascade on delete 
FK_T_GPS_USER_VIEWERSET T_GPS_USER_VIEWER_SETS.VIEWERSET_ID T_GPS_VIEWER_INSTANCES_SET.SET_ID Cascade on delete 
FK_T_GPS_USER_VIEWERSET_F T_GPS_USER_VIEWER_INSTANCES.USER_VIEWERSET_ID T_GPS_USER_VIEWER_SETS.USER_VIEWERSET_ID Cascade on delete 
FK_T_GPS_USER_WF_UWFT T_GPS_USER_WORKFLOW_TYPES.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
FK_T_GPS_USER_WT_USER_APP_ID T_GPS_USER_WORKFLOW_TYPES.USER_APP_ID T_GPS_USER_APPLICATIONS.USER_APP_ID Cascade on delete 
FK_T_GPS_USERS_APP_ID T_GPS_USER_APPLICATIONS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_USERS_USER_ID T_GPS_USER_APPLICATIONS.USER_ID T_GPS_USERS.USER_ID Cascade on delete 
FK_T_GPS_VDD_BUILDFR_MAPPINGS T_GPS_VDD_BUILDFR_MAPPINGS.DRILL_DOWN_PROPERTY_ID T_GPS_DRILL_DOWN_PROPERTIES.DRILL_DOWN_PROPERTY_ID Cascade on delete 
FK_T_GPS_VDD_COLUMNS_MAPPING T_GPS_VDD_COLUMNS_MAPPING.DRILL_DOWN_PROPERTY_ID T_GPS_DRILL_DOWN_PROPERTIES.DRILL_DOWN_PROPERTY_ID Cascade on delete 
FK_T_GPS_VIEW_CLSS_TABGROUPS T_GPS_VIEWER_CLASS_TABGROUPS.CLASS_ID T_GPS_VIEWER_INSTANCES_CLASSES.CLASS_ID Cascade on delete 
FK_T_GPS_VIEW_CLSS_TBGRP_CHLD T_GPS_VIEW_CLASS_TABGRP_CHILDS.TAB_ID T_GPS_VIEWER_CLASS_TABGROUPS.TAB_ID Cascade on delete 
FK_T_GPS_VIEW_INST_CLAS_PROPS T_GPS_VIEWER_INST_CLASS_PROPS.CLASS_ID T_GPS_VIEWER_INSTANCES_CLASSES.CLASS_ID Cascade on delete 
FK_T_GPS_VIEWER_DRILL_DOWNS T_GPS_VIEWER_DRILL_DOWNS.PARENT_INSTANCE_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
FK_T_GPS_VIEWER_INST_CLASSES T_GPS_VIEWER_INSTANCES_CLASSES.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
FK_T_GPS_VIEWER_INSTANCES T_GPS_VIEWER_INSTANCES_SET.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_VIEWER_INSTANCES_NT T_GPS_VIEWER_INSTANCES.SET_ID T_GPS_VIEWER_INSTANCES_SET.SET_ID Cascade on delete 
FK_T_GPS_VIEWER_PROPERTY_ORDER T_GPS_VIEWER_PROPERTY_ORDER.TAB_ID T_GPS_VIEWER_CLASS_TABGROUPS.TAB_ID Cascade on delete 
FK_T_GPS_VIEWER_PROPS_OP T_GPS_VIEWER_PROPS_OPERATORS.PROPERTY_ID T_GPS_VIEWER_INST_CLASS_PROPS.PROPERTY_ID Cascade on delete 
FK_T_GPS_WF_DIS_NOTIFICATIONS T_GPS_WF_DIS_NOTIFICATIONS.OPERATION_ID T_GPS_WF_DISABLED_OPERATIONS.OPERATION_ID Cascade on delete 
FK_T_GPS_WF_DIS_OPERATIONSS T_GPS_WF_DISABLED_OPERATIONS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_WF_INST_CLASSES_PROPS T_GPS_WF_INST_CLASS_PROPS.CLASS_ID T_GPS_WF_INSTANCE_CLASSES.CLASS_ID Cascade on delete 
FK_T_GPS_WF_INST_FAIL_REASONS T_GPS_WF_INST_FAIL_REASONS.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
FK_T_GPS_WF_INSTANCES_CLASSES T_GPS_WF_INSTANCE_CLASSES.INSTANCE_ID T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Cascade on delete 
FK_T_GPS_WF_STATE_PROPS T_GPS_WORKFLOWMOVE_STATE_PROPS.WORKFLOWMOVE_ID T_GPS_WORKFLOWMOVE_STATE.WORKFLOWMOVE_ID Cascade on delete 
FK_T_GPS_WFI_NAMEORDERS T_GPS_WF_INST_NAMEORDERS.INSTANCE_ID T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Cascade on delete 
FK_T_GPS_WFT_PROPERTIES T_GPS_WFT_PROPERTIES.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
FK_T_GPS_WORKFLOW_INSTANCES T_GPS_WORKFLOW_INSTANCES.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
FK_T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_GPS_WORKFLOWMOVE_STATE T_GPS_WORKFLOWMOVE_STATE.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_GV_DEFAULT_REPORT_INFO_NT T_GV_DEFAULT_REPORT_INFO.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
FK_T_GV_EDIT_DATA_VALIDATIONS T_GV_EDIT_DATA_VALIDATIONS.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
FK_T_INSTANCES T_INSTANCES.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_MOBILE_WIDGET_MODULES_1 T_MOBILE_MODULES.WIDGET_ID T_MOBILE_WIDGETS.WIDGET_ID Restrict delete 
FK_T_PROJECT_ISSUE_TYPES T_PROJECT_ISSUE_TYPES.ISSUE_TYPE_ID T_ISSUE_TYPES.ISSUE_TYPE_ID Cascade on delete 
FK_T_PROJECT_TASK T_PROJECT_TASK.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_REPRT_PLAN_TSK_WKF_ID T_REPORTING_PLAN_TASKS.WORKFLOW_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Restrict delete 
FK_T_ROLES_EWKS_ROLE_ID T_GPS_ROLE_LEVEL_EWKS_ACTIONS.ROLE_ID T_ROLES.ROLE_ID Cascade on delete 
FK_T_SCRIPT_REPLAY_RESULTS T_SCRIPT_REPLAY_RESULTS.INSTANCE_PRIMARY_ID T_GPS_INSTANCES.INSTANCE_PRIMARY_ID Cascade on delete 
FK_T_SURVEY_RESPONSES T_GPS_INSTANCE_FEEDBACK.RESPONSE_ID T_SURVEY_RESPONSES.ID Restrict delete 
FK_T_SURVEYS T_GPS_WF_STATE_FEEDBACK_FORM.SURVEY_ID T_SURVEYS.ID Restrict delete 
FK_T_SURVEYS_ST T_SURVEYS.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_TAS_SOD_STATES_SODSTATEID T_TAS_SOD_STATES.SOD_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_TAS_SOD_STATES_STATEID T_TAS_SOD_STATES.PARENT_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
FK_T_TRADING_PARTY_PROJECTS T_TRADING_PARTY_PROJECTS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
FK_T_TRADING_PARTY_RESOURCES T_TRADING_PARTY_RESOURCES.USER_ID T_USERS.USER_ID Cascade on delete 
FK_T_USERS T_GPS_OBJECT_SUBSCRIPTIONS.USER_ID T_USERS.USER_ID Cascade on delete 
FK_TRADING_PARTY_PROJECTS T_TRADING_PARTY_PROJECTS.TRADING_PARTY_ID T_TRADING_PARTY.TRADING_PARTY_ID Cascade on delete 
FK_TRADING_PARTY_RESOURCES T_TRADING_PARTY_RESOURCES.TRADING_PARTY_ID T_TRADING_PARTY.TRADING_PARTY_ID Cascade on delete 
FK_VERSION_NODETYPE_STATE_ID T_HTML_NODE_PROPSHEET_VERSION.NODETYPE_STATE_ID T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID Cascade on delete 
FK_VIEWER_AUDITTRIAL_INFO T_GPS_VIEWER_AUDITTRAIL_INFO.AUDIT_ID T_GPS_VIEWER_AUDITTRAIL.AUDIT_ID Cascade on delete 
FK_VIEWER_INSTANCES T_GPS_VIEWER_MAIL_CONFIG.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
FK_VIEWER_INSTANCES_ID T_GPS_VIEWER_GRAPH_DETAILS.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
FK_VIEWER_PDF_FORMAT_ID T_GPS_VIEWER_PDF_FORMAT.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Restrict delete 
FK_WORKFLOW_TYPE_ID T_GPS_STATE_OPERATIONS.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
FK_WORKFLOWMOVE_ID T_GPS_WFMOVE_STATEOPERATIONS.WORKFLOWMOVE_ID T_GPS_WORKFLOWMOVE_STATE.WORKFLOWMOVE_ID Cascade on delete 
FK_WORKFLOWSOD_INSTANCEID T_GPS_WORKFLOW_SOD_ASSIGNMENTS.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
FK_WORKFLOWSOD_RULEID T_GPS_WORKFLOW_SOD_ASSIGNMENTS.RULE_ID T_TAS_SOD_STATES.RULE_ID Cascade on delete 
FK_WT_FOLDER_ID T_GPS_WORKFLOW_TYPES.FOLDER_ID T_GPS_VIEWER_INSTANCES_SET.SET_ID Cascade on delete 
FKCHILD_MENUCONFIG_RELATIONS T_GPS_MENUCONFIG_RELATIONS.CHILD_MENU_ID T_GPS_MENUCONFIG.MENU_ID Cascade on delete 
FORMULA_ID_FK T_GPS_TASK_RESOURCES.FORMULA_ID T_GPS_NODE_FORMULA.FORMULA_ID Cascade on delete 
FROM_STATE_ID_FKEY T_BPM_APR_WF_AUDIT.FROM_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
HISTORY_SET_ID_FK TC_LABEL_VALUE_SETS_HISTORY.HISTORY_SET_ID T_VALUE_SETS_HISTORY_SET.HISTORY_SET_ID Cascade on delete 
INSTANCE_ID T_CUSTOMER_REF.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
INSTANCE_ID1_FKEY T_BPM_APR_REQUESTS.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
INSTANCE_ID2_FKEY T_BPM_APR_UPDATE_HISTORY.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
INSTANCE_ID3_FKEY T_BPM_APR_DOC_HISTORY.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
INSTANCE_ID4_FKEY T_BPM_APR_WF_AUDIT.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
INSTANCE_ID_FK T_INSTANCE_PREDECESSOR.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
INSTANCE_ID_FK1 T_PROMISED_DUEDATE_HISTORY.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
MASTER_TP_ID_FK T_TRADING_PARTY.MASTER_TRADING_PARTY_ID T_TRADING_PARTY.TRADING_PARTY_ID Restrict delete 
MASTERMODELID_FK T_GPS_MASTER_MODELS_PROPERTIES.MASTER_MODEL_ID T_GPS_MASTER_MODELS.MASTER_MODEL_ID Cascade on delete 
MODEL_ID_FK T_GPS_MASTER_MODELS.MODEL_ID T_GPS_MODELS.MODEL_ID Cascade on delete 
MODEL_ID_FKEY T_BPM_APR_REQUESTS.MODEL_ID T_GPS_MODELS.MODEL_ID Cascade on delete 
MOVETO_FROMSTATEID_FK T_GPS_INSTANCE_MOVETO_TRACKING.FROM_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
MOVETO_INSTANCE_ID_FK T_GPS_INSTANCE_MOVETO_TRACKING.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
MOVETO_TOSTATEID_FK T_GPS_INSTANCE_MOVETO_TRACKING.TO_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
OBJECT_ID_FOREIGN_KEY T_GPS_OBJECT_SUBSCRIPTIONS.OBJECT_ID T_GPS_ALL_OBJECTS.OBJECT_ID Cascade on delete 
PA_INSTANCE_ID_FK T_PLANNED_ACCOMPLISHED.INSTANCE_ID T_INSTANCES.INSTANCE_ID Restrict delete 
PA_STATE_ID_FK T_PLANNED_ACCOMPLISHED.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Restrict delete 
PRED_INSTANCE_ID_FK T_INSTANCE_PREDECESSOR.PRED_INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
PRED_STATE_ID_FK T_INSTANCE_PREDECESSOR.PRED_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
PRED_WORKFLOW_ID_FK T_WORKFLOW_PREDECESSOR.PRED_WORKFLOW_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
PREDECESSOR_TASK_ID_FK T_TASK_PREDECESSOR.PREDECESSOR_TASK_ID T_PROJECT_TASK.PROJECT_TASK_ID Cascade on delete 
PROCESS_ID_FK T_SUPPORT_INVOICE_SCHEDULES.PROCESS_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
PROCESS_ID_FOKEY T_PROCESS_SLAS.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
PROJECT_BUFFER_FK T_PROJECT_BUFFER.PROJECT_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
PROJECT_ID_FK T_WORKING_TIME.PROJECT_ID T_GPS_APPLICATIONS.APPLICATION_ID Restrict delete 
PROJECT_ID_FOKEY T_PROJECT_SLAS.PROJECT_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
PROJECT_ID_FORNKEY T_PROCESS_SLAS.PROJECT_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
PROJECT_TASK_ID T_TASK_MANAGER_COMMENT.PROJECT_TASK_ID T_PROJECT_TASK.PROJECT_TASK_ID Cascade on delete 
PROJECT_TASK_ID_FK T_PROJECT_ACTIVITY.PROJECT_TASK_ID T_PROJECT_TASK.PROJECT_TASK_ID Cascade on delete 
SCENARIO_MODEL_ID_FK T_SCENARIO_PROPERTIES.MODEL_ID T_GPS_MODELS.MODEL_ID Cascade on delete 
SLA_ID_FK T_PROJECT_SLAS_ESCALATIONS.SLA_ID T_PROJECT_SLAS.SLA_ID Restrict delete 
STATE_ID_FK T_GPS_WF_STATE_FEEDBACK_FORM.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
STATE_ID_FKEY T_BPM_APR_DOCUMENTS.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
SYS_C0010217 T_GPS_USER_MENUCONFIG.MODE_ID T_GPS_MENUCONFIG_MODE.MODE_ID Restrict delete 
SYS_C0010218 T_GPS_USER_MENUCONFIG.MENU_ID T_GPS_MENUCONFIG.MENU_ID Cascade on delete 
SYS_C0010219 T_GPS_USER_MENUCONFIG.USER_APP_ID T_GPS_USER_APPLICATIONS.USER_APP_ID Cascade on delete 
SYS_C0010220 T_GPS_CONDITIONAL_STATE_CHANGE.TO_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
SYS_C0010221 T_GPS_CONDITIONAL_STATE_CHANGE.FROM_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
SYS_C0010227 T_GPS_WORKFLOW_STATE_PROP.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
SYS_C0010229 T_GPS_CHILD_NODES.CHILD_NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010230 T_GPS_CHILD_NODES.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010231 T_GPS_MAIL_HISTORY.OPERATION_ID T_GPS_WF_DISABLED_OPERATIONS.OPERATION_ID Cascade on delete 
SYS_C0010232 T_GPS_MAIL_HISTORY.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
SYS_C0010235 T_GPS_ROLE_NODETYPE_STATES.NODETYPE_ID T_GPS_NODETYPES.NODETYPE_ID Cascade on delete 
SYS_C0010240 T_GPS_NODE_FORMULA.CHANGE_ID T_GPS_CONDITIONAL_STATE_CHANGE.CHANGE_ID Cascade on delete 
SYS_C0010257 T_GPS_MENUCONFIG.MODE_ID T_GPS_MENUCONFIG_MODE.MODE_ID Restrict delete 
SYS_C0010266 T_GPS_USER_STATES.FROM_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
SYS_C0010267 T_GPS_USER_STATES.USER_WORKFLOW_TYPE_ID T_GPS_USER_WORKFLOW_TYPES.USER_WORKFLOW_TYPE_ID Cascade on delete 
SYS_C0010270 T_PROJECT_TASK_HISTORY.PROJECT_TASK_ID T_PROJECT_TASK.PROJECT_TASK_ID Cascade on delete 
SYS_C0010277 T_GPS_VIEWER_LOV_DEPENDONS.LOV_ID T_GPS_VIEWER_LOV_INFO.LOV_ID Cascade on delete 
SYS_C0010289 T_GPS_APP_TOKEN_INFO.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
SYS_C0010294 T_GPS_GETCONTROLLER_FDT.FDT_ID T_GPS_APP_FDTS.FDT_ID Cascade on delete 
SYS_C0010295 T_GPS_GETCONTROLLER_FDT.PROPERTY_ID T_GPS_APP_PROPERTIES.PROPERTY_ID Cascade on delete 
SYS_C0010296 T_GPS_GETCONTROLLER_FDT.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
SYS_C0010298 T_GPS_MODELS.CATEGORY_ID T_CATEGORIES.CATEGORY_ID Cascade on delete 
SYS_C0010300 T_GPS_PATH_LEVEL_LEG.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010301 T_GPS_PATH_LEVEL_LEG.PATH_ID T_GPS_PATH.PATH_ID Cascade on delete 
SYS_C0010336 T_GPS_NODE_CLASS_PROPERTIES.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010337 T_GPS_NODE_CLASS_PROPERTIES.CLASS_ID T_GPS_NODE_CLASSES.CLASS_ID Cascade on delete 
SYS_C0010341 T_GPS_CLASS_RELATIONS.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010342 T_GPS_CLASS_RELATIONS.CONTAINER_CLASS_ID T_GPS_NODE_CLASSES.CLASS_ID Cascade on delete 
SYS_C0010343 T_GPS_CLASS_RELATIONS.CLASS_ID T_GPS_NODE_CLASSES.CLASS_ID Cascade on delete 
SYS_C0010355 T_GPS_APP_FDTS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
SYS_C0010356 T_GPS_PARENT_NODES.PARENT_NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010357 T_GPS_PARENT_NODES.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010358 T_GPS_MODEL_PROPERTIES.MODEL_ID T_GPS_MODELS.MODEL_ID Cascade on delete 
SYS_C0010359 T_GPS_COND_ST_CHANGE_SETS.CHANGE_ID T_GPS_CONDITIONAL_STATE_CHANGE.CHANGE_ID Cascade on delete 
SYS_C0010375 T_GPS_NODE_CLASSES.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010376 T_GPS_COMPRESSED_PATH_PROPS.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010377 T_GPS_COMPRESSED_PATH_PROPS.PATH_ID T_GPS_PATH.PATH_ID Cascade on delete 
SYS_C0010391 T_GPS_USER_NODETYPE_STATES.NODETYPE_ID T_GPS_NODETYPES.NODETYPE_ID Cascade on delete 
SYS_C0010392 T_GPS_USER_NODETYPE_STATES.USER_STATE_ID T_GPS_USER_STATES.USER_STATE_ID Cascade on delete 
SYS_C0010395 T_GPS_PATH.MODEL_ID T_GPS_MODELS.MODEL_ID Cascade on delete 
SYS_C0010396 T_GPS_COND_ST_CHANGE_PROPS.SET_ID T_GPS_COND_ST_CHANGE_SETS.SET_ID Cascade on delete 
SYS_C0010397 T_GPS_VIEWER_KPI_CONFIG.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
SYS_C0010403 T_GPS_ROLE_MENUCONFIG.MODE_ID T_GPS_MENUCONFIG_MODE.MODE_ID Restrict delete 
SYS_C0010404 T_GPS_ROLE_MENUCONFIG.MENU_ID T_GPS_MENUCONFIG.MENU_ID Cascade on delete 
SYS_C0010405 T_GPS_ROLE_MENUCONFIG.ROLE_APP_ID T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID Cascade on delete 
SYS_C0010406 T_GPS_NODE_MODEL_RELATIONS.MODEL_ID T_GPS_MODELS.MODEL_ID Cascade on delete 
SYS_C0010407 T_GPS_NODE_MODEL_RELATIONS.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010413 T_GPS_ALTERNATE_NODES.ALTERNATE_NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010414 T_GPS_ALTERNATE_NODES.NODE_ID T_GPS_NODES.NODE_ID Cascade on delete 
SYS_C0010416 T_GPS_NODES.MODEL_ID T_GPS_MODELS.MODEL_ID Cascade on delete 
SYS_C0016865 T_TRI2_PROJECT_MODULES.PROJECT_ID T_GPS_APPLICATIONS.APPLICATION_ID Restrict delete 
SYS_C0016866 T_TRI2_PROJECT_MODULES.MODULE_ID LIST_VALUES.MODULE_ID Restrict delete 
SYS_C0019803 T_PROJECT_DETAILS_HISTORY.PROJECT_ID T_PROJECT_DETAILS.PROJECT_ID Restrict delete 
SYS_C0019804 T_SUPPORT_INVOICE_SCHEDULES.PROJECT_ID T_PROJECT_DETAILS.PROJECT_ID Restrict delete 
SYS_C0025030 T_SURVEY_DETAILS.ID T_SURVEYS.ID Restrict delete 
SYS_C0029840 T_SURVEY_RESPONSES.SURVEY_DETAILS_ID T_SURVEY_DETAILS.SURVEY_DETAILS_ID Restrict delete 
SYS_C0031199 T_SP_EXECUTION_OBJECT_DETAILS.EXECUTION_DETAILS_ID T_SP_EXECUTION_DETAILS.EXECUTION_DETAILS_ID Cascade on delete 
SYS_C0031202 T_SP_EXECUTION_PROP_DETAILS.EXECUTION_DETAILS_ID T_SP_EXECUTION_DETAILS.EXECUTION_DETAILS_ID Cascade on delete 
SYS_C0032051 T_GPS_VIEWER_MULTIPLE_LOV.LOV_ID T_GPS_VIEWER_LOV_INFO.LOV_ID Cascade on delete 
SYS_C0032175 T_GV_TRANSIENT_FIELD_INFO.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Restrict delete 
SYS_C0032681 T_INSTANCE_CHILD_DOCS.DOCUMENT_ID T_INSTANCE_DOCUMENTS.DOCUMENT_ID Restrict delete 
SYS_C0032839 T_GPS_POOLCONFIG_AUDIT_INFO.AUDIT_ID T_GPS_POOLCONFIG_AUDITTRIAL.AUDIT_ID Cascade on delete 
SYS_C0032897 T_FAQ.MODULE_ID T_FAQ_MODULE_SETUP.MODULE_ID Cascade on delete 
SYS_C0033228 T_GPS_GOOGLE_MAP_SETUP.IF_CHILD_PROPERTY_ID T_GPS_NT_ST_CLASS_PROPS.PROPERTY_ID Restrict delete 
SYS_C0033927 T_TRI2_WORKFLOW_MODULE.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Restrict delete 
SYS_C0033928 T_TRI2_WORKFLOW_MODULE.MODULE_ID LIST_VALUES.MODULE_ID Restrict delete 
SYS_C0034363 T_DB_POOL_CONTEXTS.POOL_ID T_DB_POOLS.ID Restrict delete 
SYS_C0035188 T_GPS_VIEWER_FOOTER_CONFIG.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
SYS_C0035194 T_GPS_VIEWER_FOOTER_CONDITION.CONFIGURATION_ID T_GPS_VIEWER_FOOTER_CONFIG.CONFIGURATION_ID Cascade on delete 
SYS_C0035416 SCOTT_EMP.DEPTNO SCOTT_DEPT.DEPTNO Restrict delete 
SYS_C0035539 T_GPS_VIEWER_GRAPH_DRILLDOWNS.GRAPH_ID T_GPS_VIEWER_GRAPH_DETAILS.GRAPH_ID Cascade on delete 
T_BPM_APR_DOCUMENTS_ID_FKEY T_BPM_APR_DOC_HISTORY.T_BPM_APR_DOCUMENTS_ID T_BPM_APR_DOCUMENTS.T_BPM_APR_DOCUMENTS_ID Cascade on delete 
T_BPM_APR_HISTORY_ID_FKEY T_BPM_APR_WF_AUDIT.T_BPM_APR_UPDATE_HISTORY_ID T_BPM_APR_UPDATE_HISTORY.T_BPM_APR_UPDATE_HISTORY_ID Cascade on delete 
T_DELETE_ROW_ACTION_FK1 T_DELETE_ROW_ACTION.CLASS_ID T_GPS_NT_STATE_CLASSES.CLASS_ID Cascade on delete 
T_DELETE_ROW_ACTION_UPDATE_FK1 T_DELETE_ROW_ACTION_UPDATE.ACTION_ID T_DELETE_ROW_ACTION.ID Cascade on delete 
T_GPS_PROJECT_SCENARIOS_FK1 T_GPS_PROJECT_SCENARIOS.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
T_GPS_PROJECT_SCENARIOS_FK2 T_GPS_PROJECT_SCENARIOS.WORKFLOW_TYPE_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 
T_GPS_VIEWER_LOV_INFO_FK T_GPS_VIEWER_LOV_INFO.PROPERTY_ID T_GPS_VIEWER_INST_CLASS_PROPS.PROPERTY_ID Cascade on delete 
T_GPS_VIEWER_MEASURES_FK T_GPS_VIEWER_MEASURES.DIMENSION_ID T_GPS_VIEWER_DIMENSIONS.DIMENSION_ID Cascade on delete 
T_GPS_WF_DOCS_INSTANCE_ID_FKEY T_BPM_APR_DOCUMENTS.INSTANCE_ID T_INSTANCES.INSTANCE_ID Cascade on delete 
T_PROJECT_BUFFER_THRESHOLD_FK T_PROJECT_BFR_USAGE_THRESHOLD.PROJECT_ID T_GPS_APPLICATIONS.APPLICATION_ID Cascade on delete 
T_PROJECT_ROLES_T_GPS_APP_FK1 T_PROJECT_ROLES.APPLICATION_ID T_GPS_APPLICATIONS.APPLICATION_ID Restrict delete 
T_PROJECT_ROLES_T_ROLES_FK1 T_PROJECT_ROLES.ROLE_ID T_ROLES.ROLE_ID Restrict delete 
T_SURVEY_RESPONSES_T_SURV_FK1 T_SURVEY_RESPONSES.SURVEY_ID T_SURVEYS.ID Restrict delete 
T_TASK_ACTION_ITEMS_FK T_TASK_ACTION_ITEMS.PROJECT_TASK_ID T_PROJECT_TASK.PROJECT_TASK_ID Restrict delete 
T_TRI2_PRS2WF_NODE_MAPPIN_FK1 T_TRI2_PRS2WF_NODE_MAPPING.PROCESS_NODETYPE_ID T_GPS_NODETYPES.NODETYPE_ID Restrict delete 
T_TRI2_PRS2WF_NODE_MAPPIN_FK2 T_TRI2_PRS2WF_NODE_MAPPING.WORKFLOW_NODETYPE_ID T_GPS_NODETYPES.NODETYPE_ID Cascade on delete 
TASK_ID_FK T_TASK_PREDECESSOR.TASK_ID T_PROJECT_TASK.PROJECT_TASK_ID Cascade on delete 
TASK_ID_FOKEY T_TASK_SLAS.STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
TO_STATE_ID_FKEY T_BPM_APR_WF_AUDIT.TO_STATE_ID T_GPS_WORKFLOW_STATES.STATE_ID Cascade on delete 
VIEWER_OLAP_FKY T_GV_OLAP_CONFIGURATION.VIEWER_INSTANCES_ID T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Cascade on delete 
WORKFLOW_ID_FK T_WORKFLOW_PREDECESSOR.WORKFLOW_ID T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected