SchemaSpy Analysis of shrdb.LAWRS - 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
  EJS_FIRED_TRIGGERS.INSTANCE_NAME	EJS_SCHEDULER_STATE.INSTANCE_NAME
  EJS_FIRED_TRIGGERS.TRIGGER_GROUP	EJS_PAUSED_TRIGGER_GRPS.TRIGGER_GROUP
  EJS_TRIGGERS.CALENDAR_NAME	EJS_CALENDARS.CALENDAR_NAME
  EJS_TRIGGERS.TRIGGER_GROUP	EJS_PAUSED_TRIGGER_GRPS.TRIGGER_GROUP
  ERS_ATTRIBUTELIST.ATTRIBUTEID	ERS_ATTRIBUTES.ATTRIBUTEID
  ERS_CUSTOMGROUPMEMBERS.GROUPID	ERS_CUSTOMGROUPS.GROUPID
  ERS_ELEMENTREFERENCES.ELEMENTID	ERS_ELEMENTS.ELEMENTID
  ERS_LISTDETAIL.USERID	ERS_LISTDEFAULT.USERID
  ERS_LISTEXCEPTIONS.USERID	ERS_LISTDEFAULT.USERID
  ERS_LISTS.USERID	ERS_LISTDEFAULT.USERID
  ERS_LISTUSERS.USERID	ERS_LISTDEFAULT.USERID
  ERS_PARM_AVAILVALUES.ID	ERS_PARAMETERS.ID
  ERS_REPORTATTRIBUTES.ATTRIBUTEID	ERS_ATTRIBUTES.ATTRIBUTEID
  ERS_REPORTPERMISSIONS.SYSTEMTASKID	ERS_SYSTEMTASKS.SYSTEMTASKID
  ERS_REPORTSTATUS.USERID	ERS_LISTDEFAULT.USERID
  ERS_RULEACCESS.RULEID	ERS_RULEMASTER.RULEID
  ERS_RULEDETAIL.ELEMENTID	ERS_ELEMENTS.ELEMENTID
  ERS_RULEDETAIL.RULEID	ERS_RULEMASTER.RULEID
  ERS_RULEDETAIL.STRUCTUREID	ERS_STRUCTURE.STRUCTUREID
  ERS_RULEMAPPINGS.RULEID	ERS_RULEMASTER.RULEID
  ERS_RULEMASTER.STRUCTUREID	ERS_STRUCTURE.STRUCTUREID
  ERS_RULEVALUES.ELEMENTID	ERS_ELEMENTS.ELEMENTID
  ERS_RULEVALUES.RULEID	ERS_RULEMASTER.RULEID
  ERS_RULEVALUES.STRUCTUREID	ERS_STRUCTURE.STRUCTUREID
  ERS_SOLPACKOBJECTS.SOLUTIONPACKID	ERS_SOLPACKS.SOLUTIONPACKID
  ERS_SOLPACKPROPERTIES.SOLUTIONPACKID	ERS_SOLPACKS.SOLUTIONPACKID
  ERS_STRUCTUREMAPPING.RULEID	ERS_RULEMASTER.RULEID
  ERS_STRUCTUREMAPPING.STRUCTUREID	ERS_STRUCTURE.STRUCTUREID
  ERS_STRUCTURETEMPLATE.ELEMENTID	ERS_ELEMENTS.ELEMENTID
  ERS_STRUCTURETEMPLATE.STRUCTUREID	ERS_STRUCTURE.STRUCTUREID
  ERS_STRUCTURETOFIELDMAP.ELEMENTID	ERS_ELEMENTS.ELEMENTID
  ERS_STRUCTURETOFIELDMAP.STRUCTUREID	ERS_STRUCTURE.STRUCTUREID
  ERS_SYSTEMPERMISSIONS.SYSTEMTASKID	ERS_SYSTEMTASKS.SYSTEMTASKID

  33 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  EBS_BSCHANNEL	0
  EBS_BSFOLDER	0
  EBS_BSGROUP	0
  EBS_BSIDCHAN	0
  EBS_BSIDCHFLD	0
  EBS_BSIDCHFLDI	0
  EBS_BSIDPUB	0
  EBS_BSINFODTL	0
  EBS_BSINFOHDR	0
  EBS_BSLISTGRP	0
  EBS_BSPUBLISH	0
  EBS_BSRULEDTL	0
  EBS_BSRULEHDR	0
  EBS_BSRULELIST	0
  EBS_BSSUBSCR	0
  EBS_SIBSLISTHD	0
  EBS_SIBSLISTID	0
  EBS_SIRDIDHDR	0
  EBS_WEBUSER	0
  EBS_WFFOLDER	0
  EBS_WFSERVICE	0
  EBS_WFSERVPROC	0
  EBS_WFVARIABLE	0
  EBS_WFWORKUNIT	0
  EJS_JOBS	21
  ERS_ATTRIBUTELIST	45
  ERS_LISTDETAIL	718
  ERS_LISTUSERS	212
  ERS_PARAMETERS_IDS	1
  ERS_PARAMETERVALUES	0
  ERS_PARM_AVAILVALUES_IDS	13
  ERS_REPORTSTATUS	89
  ERS_VARIABLES	39
  RS_AUDIT	0

  34 instances of anomaly detected

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

• Tables that contain a single column:

  Table	Column
  EJS_LOCKS	LOCK_NAME
  EJS_PAUSED_TRIGGER_GRPS	TRIGGER_GROUP
  ERS_PARAMETERS_IDS	LASTID

  3 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  EBS_WEBUSER
  EBS_WFSERVICE
  EBS_WFSERVPROC
  EBS_WFWORKUNIT
  ERS_SOLPACKOBJECTS

  5 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