SchemaSpy Analysis of HLPDTEST.STATEGPS - Anomalies

Generated by SchemaSpy

Things that might not be 'quite right' about your schema:

• Columns whose name and type imply a relationship to another table's primary key:

  Child Column	Implied Parent Column
  BPM_TO_BPM_MAPPING.MAPPING_ID	T_GPS_EWKS_WF_INSTANCE_MAPPING.MAPPING_ID
  IDSLIST.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  MV_RESOURCE_PERFORMANCE.PROJECT_TASK_ID	T_PROJECT_TASK.PROJECT_TASK_ID
  PLAN_TABLE.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  T_CATEGORIES.TRADING_PARTY_ID	T_TRADING_PARTY.TRADING_PARTY_ID
  T_CM_MANAGER_COACH_PLAN.STATE_ID	T_GPS_WORKFLOW_STATES.STATE_ID
  T_DB_POOL_CONTEXTS.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  T_DB_POOLS.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  T_DB_POOLS.TRADING_PARTY_ID	T_TRADING_PARTY.TRADING_PARTY_ID
  T_DELETE_ROW_ACTION.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  T_ETK_EXCEPTIONS.EXCEPTION_ID	T_GPS_EXCEPTIONS.EXCEPTION_ID
  T_ETK_INSTANCES_INFO.INSTANCE_ID	T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID
  T_EXEPLAN_HISTORY.HISTORY_ID	T_GPS_WF_INSTANCE_HISTORY.HISTORY_ID
  T_GOOGLE_MAPS_GEOCODE_MAPPING.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  T_GPS_APP_FDTS_PARAMHASH.MODEL_FDT_ID	T_GPS_APP_MODEL_VALID_RULES.MODEL_FDT_ID
  T_GPS_APP_PROPERTIES.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_APPLICATIONS_BACKUP.APPLICATION_ID	T_GPS_APPLICATIONS.APPLICATION_ID
  T_GPS_CM_PT_CLASS_PROPS.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_COM_PATH_CLASSES.CLASS_ID	T_GPS_RELATION_CLASSES.CLASS_ID
  T_GPS_COMPRESSED_PATH_PROPS.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_COND_ST_CHANGE_PROPS.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_CUSTOM_SETS_BKP.APPLICATION_ID	T_GPS_APPLICATIONS.APPLICATION_ID
  T_GPS_CUSTOM_SETS_BKP.CUSTOM_SET_ID	T_GPS_CUSTOM_SETS.CUSTOM_SET_ID
  T_GPS_EXCLUSIVE_SETS.SET_ID	T_GPS_COND_ST_CHANGE_SETS.SET_ID
  T_GPS_FAVOURITES_HISTORY.HISTORY_ID	T_GPS_WF_INSTANCE_HISTORY.HISTORY_ID
  T_GPS_GOOGLE_MAP_SETUP.APPLICATION_ID	T_GPS_APPLICATIONS.APPLICATION_ID
  T_GPS_GOOGLE_MAP_SETUP.NODETYPE_STATE_ID	T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID
  T_GPS_GOOGLE_MAP_SETUP.STATE_ID	T_GPS_WORKFLOW_STATES.STATE_ID
  T_GPS_IF_CHANGED_PROPERTY.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_INBOX_LABELS_CONFIG.TRADING_PARTY_ID	T_TRADING_PARTY.TRADING_PARTY_ID
  T_GPS_INSTANCE_ACTIVE_TRACKING.TRACKING_ID	T_GPS_INSTANCE_MOVETO_TRACKING.TRACKING_ID
  T_GPS_INSTANCE_PROPERTIES.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_INSTANCES.INSTANCE_ID	T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID
  T_GPS_JSP_AUDIT_DETAILS.AUDIT_ID	T_GPS_QUERIES_AUDIT.AUDIT_ID
  T_GPS_KPI_PROPERTY_CONFIG.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_LOGLEVEL_AUDIT.AUDIT_ID	T_GPS_QUERIES_AUDIT.AUDIT_ID
  T_GPS_MAIL_HISTORY.INSTANCE_ID	T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID
  T_GPS_MAIL_HISTORY.WORKFLOW_TYPE_ID	T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID
  T_GPS_MAILS_SENT.INSTANCE_ID	T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID
  T_GPS_MASTER_MODELS_PROPERTIES.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_MODEL_PROPERTIES.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_MODEL_SR_ATT_CLASS_PROPS.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_MODEL_SR_ATT_CLASSES.CLASS_ID	T_GPS_RELATION_CLASSES.CLASS_ID
  T_GPS_NODE_CLASS_PROPERTIES.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_NODE_CLASSES.CLASS_ID	T_GPS_RELATION_CLASSES.CLASS_ID
  T_GPS_NODE_EDIT_CONDITIONS.CLASS_ID	T_GPS_RELATION_CLASSES.CLASS_ID
  T_GPS_NODE_EDIT_CONDITIONS.CONDITION_ID	T_GPS_DRILL_DOWN_CONDITION.CONDITION_ID
  T_GPS_NODE_RA_PROPERTIES.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_NODEGROUPS.GROUP_ID	T_GPS_PROPERTY_CHANGE_GROUPS.GROUP_ID
  T_GPS_NODENAME_ORDERS.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_NODETYPE_STATES.USER_ID	T_GPS_USERS.USER_ID
  T_GPS_NT_ST_CLASS_PROPS.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_NT_STATE_CLASSES.CLASS_ID	T_GPS_RELATION_CLASSES.CLASS_ID
  T_GPS_OBJECT_REQUISITION.APPLICATION_ID	T_GPS_APPLICATIONS.APPLICATION_ID
  T_GPS_OPERATION_PROPERTIES.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_POOLCONFIG_AUDITTRIAL.AUDIT_ID	T_GPS_QUERIES_AUDIT.AUDIT_ID
  T_GPS_PROPERTY_ORDER.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_QUERY_DEFAULT_VALUES.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_QUERY_EXECUTIONS.QUERY_ID	T_GPS_QUERY_EXECUTION_STATS.QUERY_ID
  T_GPS_ROLE_APP_OPERATIONS.ROLE_OPERATION_ID	T_GPS_ROLE_OPERATIONS.ROLE_OPERATION_ID
  T_GPS_ROLE_NODETYPES.ROLE_NODETYPE_ID	T_GPS_ROLE_NODETYPE_STATES.ROLE_NODETYPE_ID
  T_GPS_SERVER_EXECUTION_STATS.EXECUTION_ID	T_GPS_SERVER_MEMORY_STATUS.EXECUTION_ID
  T_GPS_SET_GROUPS.GROUP_ID	T_GPS_PROPERTY_CHANGE_GROUPS.GROUP_ID
  T_GPS_TOUR_COMPLETION_STATUS.USER_ID	T_GPS_USERS.USER_ID
  T_GPS_USEFUL_LINKS.APPLICATION_ID	T_GPS_APPLICATIONS.APPLICATION_ID
  T_GPS_USER_NODETYPES.USER_NODETYPE_ID	T_GPS_USER_NODETYPE_STATES.USER_NODETYPE_ID
  T_GPS_USER_OPERATIONS.USER_OPERATION_ID	T_GPS_USER_APP_OPERATIONS.USER_OPERATION_ID
  T_GPS_VDD_BUILDFR_MAPPINGS.MAP_ID	T_GPS_VDD_CUSTOMLINK_MAPPINGS.MAP_ID
  T_GPS_VDD_COLUMNS_MAPPING.MAP_ID	T_GPS_VDD_CUSTOMLINK_MAPPINGS.MAP_ID
  T_GPS_VIEWER_AUDITTRAIL.AUDIT_ID	T_GPS_QUERIES_AUDIT.AUDIT_ID
  T_GPS_VIEWER_AUDITTRAIL.VIEWER_INSTANCES_ID	T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID
  T_GPS_VIEWER_CLASS_TABGROUPS.TAB_ID	T_GPS_CLASS_TABGROUPS.TAB_ID
  T_GPS_VIEWER_DRILL_DOWNS.DRILL_DOWN_PROPERTY_ID	T_GPS_DRILL_DOWN_PROPERTIES.DRILL_DOWN_PROPERTY_ID
  T_GPS_VIEWER_EDIT_CONDITIONS.CONDITION_ID	T_GPS_DRILL_DOWN_CONDITION.CONDITION_ID
  T_GPS_VIEWER_FOOTER_CONDITION.CONDITION_ID	T_GPS_DRILL_DOWN_CONDITION.CONDITION_ID
  T_GPS_VIEWER_FOOTER_CONFIG.CONFIGURATION_ID	T_GPS_VIEWER_EDIT_CONFIG.CONFIGURATION_ID
  T_GPS_VIEWER_INST_CLASS_PROPS.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_VIEWER_INSTANCES.USER_ID	T_GPS_USERS.USER_ID
  T_GPS_VIEWER_INSTANCES_CLASSES.CLASS_ID	T_GPS_RELATION_CLASSES.CLASS_ID
  T_GPS_VIEWER_INSTANCES_SET.SET_ID	T_GPS_COND_ST_CHANGE_SETS.SET_ID
  T_GPS_VIEWER_LOV_DEPENDONS.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_VIEWER_MULTIPLE_LOV.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_VIEWER_SCHEDULE.VIEWER_INSTANCES_ID	T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID
  T_GPS_WF_DISABLED_OPERATIONS.OPERATION_ID	T_GPS_STATE_OPERATIONS.OPERATION_ID
  T_GPS_WF_INST_CLASS_PROPS.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_WF_INST_NAMEORDERS.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_WF_INSTANCE_CLASSES.CLASS_ID	T_GPS_RELATION_CLASSES.CLASS_ID
  T_GPS_WF_INSTANCE_HISTORY.APPLICATION_ID	T_GPS_APPLICATIONS.APPLICATION_ID
  T_GPS_WF_INSTANCE_HISTORY.INSTANCE_ID	T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID
  T_GPS_WF_INSTANCE_HISTORY.STATE_ID	T_GPS_WORKFLOW_STATES.STATE_ID
  T_GPS_WF_INSTANCE_HISTORY.WORKFLOW_TYPE_ID	T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID
  T_GPS_WORKFLOW_INSTANCES.STATE_ID	T_GPS_WORKFLOW_STATES.STATE_ID
  T_GPS_WORKFLOW_STATE_PROP.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_GPS_WORKFLOW_STATES.ATTRIBUTE_ID	T_GPS_MODEL_SEARCH_ATTRIBUTES.ATTRIBUTE_ID
  T_GPS_WORKFLOWMOVE_STATE.APPLICATION_ID	T_GPS_APPLICATIONS.APPLICATION_ID
  T_GPS_WORKFLOWMOVE_STATE.WORKFLOW_TYPE_ID	T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID
  T_GV_CONDITIONAL_CONFIG.CONFIG_ID	T_GV_OLAP_CONFIGURATION.CONFIG_ID
  T_INSTANCE_CHILD_DOCS.STATE_ID	T_GPS_WORKFLOW_STATES.STATE_ID
  T_INSTANCE_DOCUMENTS.INSTANCE_ID	T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID
  T_INSTANCES.INSTANCE_ID	T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID
  T_INSTANCES.WORKFLOW_TYPE_ID	T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID
  T_MIG_INSTANCE_CONTEXT_DETAILS.INSTANCE_ID	T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID
  T_MOBILE_MODULES_BKP.MODULE_ID	T_MOBILE_MODULES.MODULE_ID
  T_PROCESS_SLAS.SLA_ID	T_PROJECT_SLAS.SLA_ID
  T_PROJECT_CVS_MODULE.APPLICATION_ID	T_GPS_APPLICATIONS.APPLICATION_ID
  T_PROJECT_DETAILS.TRADING_PARTY_PROJECT_ID	T_TRADING_PARTY_PROJECTS.TRADING_PARTY_PROJECT_ID
  T_PROJECT_ISSUE_TYPES.PROJECT_ID	T_PROJECT_DETAILS.PROJECT_ID
  T_PROJECT_RESOURCE_RATES.PROJECT_ID	T_PROJECT_DETAILS.PROJECT_ID
  T_PROJECT_ROLE_USERS.ROLE_ID	T_GPS_ROLES.ROLE_ID
  T_PROJECT_ROLE_USERS.USER_ID	T_GPS_USERS.USER_ID
  T_PROJECT_SLAS.PRIORITY	T_PROJECT_CUSTOM_PRIORITY.PRIORITY
  T_PROJECT_TASK.ROLE_ID	T_GPS_ROLES.ROLE_ID
  T_PROJECT_TASK.USER_ID	T_GPS_USERS.USER_ID
  T_PROJECT_TASK_HISTORY.EXECUTION_ID	T_GPS_SERVER_MEMORY_STATUS.EXECUTION_ID
  T_PROJECT_TASK_HISTORY.HISTORY_ID	T_GPS_WF_INSTANCE_HISTORY.HISTORY_ID
  T_PROJECTPLAN_CONFIG.NODETYPE_STATE_ID	T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID
  T_PROJECTPLAN_CONFIG.PROJECT_ID	T_PROJECT_DETAILS.PROJECT_ID
  T_PROMISED_DUEDATE_HISTORY.HISTORY_ID	T_GPS_WF_INSTANCE_HISTORY.HISTORY_ID
  T_REPORTING_PLAN_HISTORY.HISTORY_ID	T_GPS_WF_INSTANCE_HISTORY.HISTORY_ID
  T_REPORTING_PLAN_TASK_DETAILS.TASK_DETAIL_ID	T_REPORTING_PLAN_TASK_DETAIL1.TASK_DETAIL_ID
  T_RESOURCE_USAGE.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  T_ROOT_CAUSES.ROOT_CAUSE_ID	T_CM_IDENTIFY_RC_PR.ROOT_CAUSE_ID
  T_SCENARIO_PROPERTIES.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  T_SFDC_CONNECTIONS.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  T_SUPPORT_INVOICE_SCHEDULES.SCHEDULE_ID	T_GPS_VIEWER_SCHEDULE.SCHEDULE_ID
  T_SUPPORT_INVOICE_SCHEDULES.SUPPORT_TYPE_ID	T_SUPPORT_TYPE.SUPPORT_TYPE_ID
  T_SUPPORT_TYPE.PROJECT_ID	T_PROJECT_DETAILS.PROJECT_ID
  T_SURVEY_RESPONSES.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  T_SURVEYS.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  T_TASK_SLAS.SLA_ID	T_PROJECT_SLAS.SLA_ID
  T_TEXT2SPEECH_SETTINGS.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  T_TRI2_PRS2WF_NODE_MAPPING.MAPPING_ID	T_GPS_EWKS_WF_INSTANCE_MAPPING.MAPPING_ID
  T_WEBSERVICE_CONNECTIONS.ID	T_DELETE_ROW_ACTION_UPDATE.ID
  TC_LABEL_VALUE_SETS_HISTORY.HISTORY_ID	T_GPS_WF_INSTANCE_HISTORY.HISTORY_ID
  TC_LABEL_VALUE_SETS_HISTORY.PROPERTY_ID	T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID
  TESTING.ID	T_DELETE_ROW_ACTION_UPDATE.ID

  136 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  EMA	2
  EWKS_WIZARD_LIMITATIONS	2
  IDSLIST	3
  IDSLIST1	4
  LEAVE_TYPE_LIST	6
  MV_DAILY_TICKET_OPEN_CLOSED	66,112
  MV_DATEWISE_TASKCOUNT	499,776
  MV_KQIVSRESOURCE	268,306
  MV_MONTHLY_TICKET_OPEN_CLOSED	22,326
  MV_MONTHWISE_TASKCOUNT	211,966
  MV_RESOURCE_PERFORMANCE	22,204
  MV_RESOURCE_PERFORMANCE_MATRIX	301,301
  MV_WEEKLY_TICKET_OPEN_CLOSED	41,924
  MV_WEEKWISE_TASKCOUNT	359,427
  PLAN_TABLE	0
  PRS_DEPT	1
  T_BPM_APR_DOC_HISTORY	31
  T_BPM_PUBLISHED_MODEL_VERSIONS	186
  T_CM_AFTER_ACTION_REVIEW	0
  T_CM_COMMUNICATION_PLAN	0
  T_CM_COMPLIANCE_AUDIT	0
  T_CM_MANAGER_COACH_PLAN	0
  T_CM_PROJECT_TEAM_INFO	0
  T_CM_RESISTANCE_MGMT_PLAN	0
  T_CM_SPONSOR_ROADMAP	0
  T_CM_TRAINING_AUDIENCE_PLAN	0
  T_FTP_ACCOUNTS	28
  T_GOOGLE_MAP_ADDRESS_EXECUTION	0
  T_GOOGLE_MAP_SEARCH_RESTRICT	0
  T_GPS_APPLICATIONS_BACKUP	1,556
  T_GPS_CUSTOM_SETS_BKP	527
  T_GPS_ETKERRORMESSAGES	0
  T_GPS_EXCEPTIONS_MV	8,278
  T_GPS_INBOX_LABELS_CONFIG	8
  T_GPS_JSP_AUDIT_DETAILS	3,104
  T_GPS_LOGLEVEL_AUDIT	127
  T_GPS_MAIL_SENT_MV	74,615
  T_GPS_PASSWORD_CONFIGURATION	1
  T_GPS_SERVER_RUN_STATUS_MV	101
  T_GPS_SSO_CUSTOMLINKS	0
  T_GPS_SSO_EWORKSHEETS	0
  T_GPS_TOUR_COMPLETION_STATUS	396
  T_GPS_VIEW_CLASS_TABGRP_CHILDS	4,967
  T_MOBILE_MODULES_BKP	32
  T_PROJECT_BFR_USAGE_THRESHOLD	66
  T_PROJECT_BUFFER	21
  T_PROJECT_SLAS_MV	6,544
  T_ROOT_CAUSES	7
  T_SP_EXECUTION_OBJECT_DETAILS	2
  T_SP_EXECUTION_PROP_DETAILS	0
  T_TASK_ACTION_ITEMS_SEQ_TABLE	1
  T_TASK_SLAS_MV	480
  T_WEBSERVICE_LOGIN_PARAMS	94
  TESTING	3
  USER_ACCESSED_SUMMARY_TREND_MV	12,733

  55 instances of anomaly detected

• Columns that are flagged as both 'nullable' and 'must be unique':

  Column
  T_APP_GROUPS.APP_ID
  T_CATEGORIES.CATEGORY_NAME
  T_GPS_ADF_EWKS_FEATURES.FEATURE_DESC
  T_GPS_ADV_GRAPH_CONFIG_VALUES.GRAPH_CONFIG_PROPERTY
  T_GPS_ADV_GRAPH_CONFIG_VALUES.GRAPH_CONFIG_PROPERTY_VALUE
  T_GPS_ALL_OBJECTS.APPLICATION_NAME
  T_GPS_ALL_OBJECTS.OBJECT_NAME
  T_GPS_ALL_OBJECTS.OBJECT_TYPE
  T_GPS_APPLICATIONS.APPLICATION_NAME
  T_GPS_AUTONUMBERS.NUMBER_NAME
  T_GPS_CALENDER_DATES.FACT_DATE
  T_GPS_CALENDER_DATES.FACT_DATE
  T_GPS_CALENDER_DATES.FACT_DATE
  T_GPS_CALENDER_DATES.FACT_MONTH
  T_GPS_CALENDER_DATES.FACT_WEEK
  T_GPS_CALENDER_DATES.FACT_YEAR
  T_GPS_DATA_HANDLER.CLASS_NAME
  T_GPS_DATA_HANDLER.MODEL_NAME
  T_GPS_INSTANCE_LINKS.FROM_INSTANCE_ID
  T_GPS_INSTANCE_LINKS.TO_INSTANCE_ID
  T_GPS_MASTER_MODELS.MODEL_ID
  T_GPS_NODE_MODEL_RELATIONS.MODEL_ID
  T_GPS_NODE_MODEL_RELATIONS.NODE_ID
  T_GPS_NODETYPES.NODETYPE
  T_GPS_OBJECT_SUBSCRIPTIONS.OBJECT_ID
  T_GPS_OBJECT_SUBSCRIPTIONS.USER_ID
  T_GPS_ROLE_APP_OPERATIONS.OPERATION_ID
  T_GPS_ROLE_APP_OPERATIONS.ROLE_APP_ID
  T_GPS_ROLE_CUSTOM_SETS.CUSTOM_SET_ID
  T_GPS_ROLE_CUSTOM_SETS.ROLE_APP_ID
  T_GPS_ROLE_LEVEL_EWKS_ACTIONS.ROLE_ID
  T_GPS_ROLE_LEVEL_EWKS_ACTIONS.VIEWER_INSTANCES_ID
  T_GPS_ROLE_NODETYPE_STATES.NODETYPE_ID
  T_GPS_ROLE_NODETYPE_STATES.ROLE_STATE_ID
  T_GPS_ROLE_VIEWER_INSTANCES.ROLE_VIEWERSET_ID
  T_GPS_ROLE_VIEWER_INSTANCES.VIEWER_INSTANCE_ID
  T_GPS_ROLE_VIEWER_SETS.ROLE_APP_ID
  T_GPS_ROLE_VIEWER_SETS.SET_ID
  T_GPS_ROLE_WORKFLOW_TYPES.ROLE_APP_ID
  T_GPS_ROLE_WORKFLOW_TYPES.WORKFLOW_TYPE_ID
  T_GPS_ROLES.ROLE_NAME
  T_GPS_USER_APP_OPERATIONS.OPERATION_ID
  T_GPS_USER_APP_OPERATIONS.USER_APP_ID
  T_GPS_USER_CUSTOM_SETS.CUSTOM_SET_ID
  T_GPS_USER_CUSTOM_SETS.USER_APP_ID
  T_GPS_USER_NODETYPE_STATES.NODETYPE_ID
  T_GPS_USER_NODETYPE_STATES.USER_STATE_ID
  T_GPS_USER_NODETYPES.NODETYPE_ID
  T_GPS_USER_NODETYPES.USER_APP_ID
  T_GPS_USER_VIEWER_INSTANCES.USER_VIEWERSET_ID
  T_GPS_USER_VIEWER_INSTANCES.VIEWER_INSTANCE_ID
  T_GPS_USER_VIEWER_SETS.USER_APP_ID
  T_GPS_USER_VIEWER_SETS.VIEWERSET_ID
  T_GPS_USER_WORKFLOW_TYPES.USER_APP_ID
  T_GPS_USER_WORKFLOW_TYPES.WORKFLOW_TYPE_ID
  T_GPS_USERS.USER_NAME
  T_GPS_VIEWER_ADV_GRAPH_CONFIG.GRAPH_CONFIG_PROPERTY
  T_GPS_VIEWER_ADV_GRAPH_CONFIG.GRAPH_TYPE
  T_GPS_VIEWER_ADV_GRAPH_DATA.EWKS_GRAPH_CONFIG_ID
  T_GPS_VIEWER_ADV_GRAPH_DATA.GRAPH_ID
  T_GPS_VIEWER_DIMENSIONS.DIMENSION
  T_GPS_VIEWER_INSTANCES.FORM_NAME
  T_GPS_VIEWER_INSTANCES.SET_ID
  T_GPS_VIEWER_INSTANCES_SET.APPLICATION_ID
  T_GPS_VIEWER_INSTANCES_SET.APPLICATION_ID
  T_GPS_VIEWER_INSTANCES_SET.DISPLAY_NAME
  T_GPS_VIEWER_INSTANCES_SET.SET_NAME
  T_GPS_WF_INSTANCE_HISTORY.APPLICATION_ID
  T_GPS_WF_INSTANCE_HISTORY.INSTANCE_DATE
  T_GPS_WF_INSTANCE_HISTORY.INSTANCE_ID
  T_GPS_WF_INSTANCE_HISTORY.STATE_ID
  T_GPS_WF_INSTANCE_HISTORY.WORKFLOW_TYPE_ID
  T_GPS_WORKFLOW_INSTANCES.WORKFLOW_TYPE_ID
  T_GPS_WORKFLOW_TYPES.APPLICATION_ID
  T_GPS_WORKFLOW_TYPES.DISPLAY_NAME
  T_GV_OLAP_CONFIGURATION.DIMENSION
  T_GV_OLAP_CONFIGURATION.DIMENSION_LEVEL
  T_GV_OLAP_CONFIGURATION.VIEWER_INSTANCES_ID
  T_ISSUE_TYPES.ISSUE_TYPE
  T_MESSAGES.MESSAGE_CODE
  T_MESSAGES.MESSAGE_NAME
  T_PROJECT_DETAILS.APPLICATION_ID
  T_PROJECT_DETAILS.EMSQB_ID
  T_PROJECT_DETAILS.TRADING_PARTY_PROJECT_ID
  T_WEBSERVICE_CONNECTIONS.NAME

  85 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  IDSLIST	ID
  IDSLIST1	ID1
  LEAVE_TYPE_LIST	LEAVE_TYPE
  T_TASK_ACTION_ITEMS_SEQ_TABLE	SEQ_ID

  4 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  ADFTESTINGTABLE
  MYVIEW
  T_GOOGLE_MAPS_GEOCODE_MAPPING
  T_GPS_EXCELDI_WORKBOOK_CONF
  T_GPS_VIEWER_DEFAULTCONDITIONS
  T_GPS_VIEWER_FOOTER_CONDITION
  T_GPS_VIEWER_INST_CLASS_PROPS
  T_GPS_WF_INSTANCE_HISTORY
  T_GPS_WF_INSTANCE_HISTORY_V
  T_PROJECT_BFR_USAGE_THRESHOLD
  T_PROJECT_TASK_V
  T_SCRIPT_REPLAY_RESULTS
  T_STARTED_TASKS_V
  T_WORKING_TIME

  14 instances of anomaly detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:

  Column
  T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR
  T_GPS_WORKFLOW_TYPES.CYCLE_TIME
  T_GPS_WORKFLOW_TYPES.CYCLE_TIME_MODE
  T_GPS_WORKFLOW_TYPES.CYCLE_TIME_UNIT

  4 instances of anomaly detected