| 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_GPH_DRL_CONS |
T_GPS_VIEWER_GRAPH_DRILLDOWNS.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_C0035134 |
T_GPS_VIEWER_FOOTER_CONFIG.VIEWER_INSTANCES_ID |
T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID |
Cascade on delete |
| SYS_C0035140 |
T_GPS_VIEWER_FOOTER_CONDITION.CONFIGURATION_ID |
T_GPS_VIEWER_FOOTER_CONFIG.CONFIGURATION_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_REPORTING_PLAN_TASKS_FK |
T_REPORTING_PLAN_TASKS.TAG_ID |
T_REPORTING_PLAN_TAGS.TAG_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 |
| WORKFLOW_STATES_PROJECT_TAG_FG |
T_GPS_WORKFLOW_STATES.PROJECT_TAG_ID |
T_PROJECT_PLAN_TAGS.PROJECT_TAG_ID |
Restrict delete |
