SchemaSpy Analysis of webco_4.4.1.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
  resource_container_tcm	0
  resource_parent	0
  wco_version	1

  3 instances of anomaly detected

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

  Column
  authentication.pin_hash
  checkout_center_auto_email.auto_email_oid
  checkout_center_auto_email.checkout_center_oid
  person.barcode
  person.userid
  person.userid
  person_checkout_center_signature.checkout_center_oid
  person_checkout_center_signature.person_oid
  pir_person_checkout_center.checkout_center_oid
  pir_person_checkout_center.person_oid
  resource.barcode
  resource.foreignid
  resource_controller.device_id
  wco_group.foreignid

  14 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  group_set	obj_oid
  resource_sleep_queue	obj_oid
  resource_wake_queue	obj_oid
  wco_version	version

  4 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