SchemaSpy Analysis of webco_3.9.3.public - 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:
  Anomaly not detected

• Tables without indexes:

  Table	Rows
  account_code_ext	0
  bibliographic_record_configuration	0
  bibliographic_record_ext	0
  bibliographic_record_helix_ext	0
  department_ext	0
  holding_ext	0
  notification_channel	0
  person_ext	0
  pir_item	0
  resource_child	0
  resource_container_tcm	0
  resource_ext	0
  resource_parent	0
  resource_type_ext	0
  task_parent_tcm	0
  wco_version	1

  16 instances of anomaly detected

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

  Column
  authentication.pin
  authentication.pin_hash
  freelancer_person_location.location_oid
  freelancer_person_location.person_oid
  person.barcode
  person.userid
  person.userid
  person_location_signature.location_oid
  person_location_signature.person_oid
  pir_person_location.location_oid
  pir_person_location.person_oid
  resource.barcode
  resource.foreignid
  resource.label_id
  resource_controller.device_id
  task_group.group_oid
  task_group.task_oid
  task_person.person_oid
  task_person.task_oid
  task_resource.resource_oid
  task_resource.task_oid
  task_resource_type.rtype_oid
  task_resource_type.task_oid
  wco_authorization.organization
  wco_authorization.person

  25 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  resource_sleep_queue	obj_oid
  resource_wake_queue	obj_oid
  wco_version	version

  3 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  department
  department_ext
  organization
  person
  person_ext
  wco_group

  6 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