SchemaSpy Analysis of lawprod.MSCM - 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
  ACTIVITY_LOG.USER_ID	USERS.USER_ID
  CHARGE_HEADER.TXN_TYPE	TXN_TYPE.TXN_TYPE
  CHARGE_HEADER.USER_ID	USERS.USER_ID
  CONTENT_RESULT.DB_ID	PROC_STAGE.DB_ID
  CONTENT_RESULT_LOG.DB_ID	PROC_STAGE.DB_ID
  DELIVERY_EVENT.LOCATION_ID	LOCATION.LOCATION_ID
  EVENT_DETAIL.ITEM_ID	ITEM.ITEM_ID
  EVENT_DETAIL.TASK_ID	TASK.TASK_ID
  EVENT_HEADER.USER_ID	USERS.USER_ID
  ITEM_GROUP.ITEM_GROUP	LAWSON_ITEM_GROUP.ITEM_GROUP
  LAWSON_BINGRPDTL.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_COMPANY.ITEM_GROUP	LAWSON_ITEM_GROUP.ITEM_GROUP
  LAWSON_ICAUDIT.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_ICAUDIT.ITEM_GROUP	LAWSON_ITEM_GROUP.ITEM_GROUP
  LAWSON_ICFREEZE.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_ICSELECT.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_ITEM.ITEM_GROUP	LAWSON_ITEM_GROUP.ITEM_GROUP
  LAWSON_ITEMLOC.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_ITEMSRC.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_LOCATION.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_LOCATION_BIN.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_LOCATION_GROUP.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_LOCATION_ITEM_BIN.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_LOCATION_ITEM_COST.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_LOCATION_ITEM_LOT.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_LOCATION_ITEM_SERIAL.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_MFGR.ITEM_GROUP	LAWSON_ITEM_GROUP.ITEM_GROUP
  LAWSON_PICKLIST.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_PICKLIST_LINE.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_PICKLIST_LINE.ITEM_GROUP	LAWSON_ITEM_GROUP.ITEM_GROUP
  LAWSON_PICKLIST_LINE_DETAIL.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_PO_CONFIG.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_PO_VENDOR.VENDOR_GROUP	LAWSON_VENDOR_GROUP.VENDOR_GROUP
  LAWSON_POLINE.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_POLINE_SRC.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_REQUESTER.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_RQLOC.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_VENDOR.VENDOR_GROUP	LAWSON_VENDOR_GROUP.VENDOR_GROUP
  LAWSON_VENDOR_CLASS.VENDOR_GROUP	LAWSON_VENDOR_GROUP.VENDOR_GROUP
  LAWSON_VENDOR_GROUP_AP_COMPANY.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_VENDOR_GROUP_AP_COMPANY.VENDOR_GROUP	LAWSON_VENDOR_GROUP.VENDOR_GROUP
  LAWSON_VENDOR_GROUP_COMPANY.COMPANY	LAWSON_COMPANY.COMPANY
  LAWSON_VENDOR_GROUP_COMPANY.VENDOR_GROUP	LAWSON_VENDOR_GROUP.VENDOR_GROUP
  LOAD_CONTENT.BATCH_NO	BATCH.BATCH_NO
  LOAD_CONTENT.DB_ID	PROC_STAGE.DB_ID
  LOAD_CONTENT_LOG.DB_ID	PROC_STAGE.DB_ID
  LOAD_RESULT.DB_ID	PROC_STAGE.DB_ID
  LOAD_RESULT_LOG.DB_ID	PROC_STAGE.DB_ID
  LOCATION_TYPE.NAME	CONFIGURATION.NAME
  MSCM9_LMPR.LEASENAME	MSCM9_LMGR.LEASENAME
  PICK.CARTSET_ASSM_NO	CASECART_ASSEMBLY.CARTSET_ASSM_NO
  PICK.PICKLIST_NO	PICKLIST.PICKLIST_NO
  PO_LINE.MFR_ID	MFGR.MFR_ID
  PROC_LOCATION.DB_ID	PROC_STAGE.DB_ID
  PROC_STAGE_SETTING.DB_ID	PROC_STAGE.DB_ID
  REPORT_SETTINGS.USER_ID	USERS.USER_ID
  TRANSFER.BATCH_NO	BATCH.BATCH_NO
  TRAY_LIST.COLOR_NO	COLOR.COLOR_NO
  TRAY_LIST.DECONTAM_ID	DECONTAMINATION_UNIT.DECONTAM_ID
  TRAY_LIST.SERV_NO	SERVICE.SERV_NO
  TRAY_LIST.STER_NO	STERILIZATION_TYPE.STER_NO
  TRAYSET.TL_ID	TRAY_LIST.TL_ID
  TRAYSET.TRAY_NO	TRAY.TRAY_NO
  TS_ITEM_EXCEPTION.TL_ITEM_ID	TL_ITEM.TL_ITEM_ID

  64 instances of anomaly detected

• Tables without indexes:

  Table
  DEFAULT_SCHEDULE_TRACKER
  ICAUDIT_TRACKER
  LAWSON_ICAUDIT
  LAWSON_LOCATION_ITEM_LOT
  USER_FACILITY_MAP

  5 instances of anomaly detected

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

  Column
  SYNC.CHECKSUM
  WORKSTATION.DESCRIPTION
  WORKSTATION.HOSTNAME

  3 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  ICAUDIT_TRACKER	LAST_PULL_DT

  1 instance of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  ADDRESS
  ATTRIBUTE_TYPE
  EVENT_DETAIL
  EVENT_HEADER
  LAWSON_ITEM
  LAWSON_RQLOC
  TASK

  7 instances of anomaly detected

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