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

  2 instances of anomaly detected

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

  Column
  authentication.pin_hash
  authset.group_oid
  authset.unique_identifier
  authset_delegation.authset_oid
  authset_delegation.org_oid
  message_type.template
  person.barcode
  person.external_id
  person.userid
  person.userid
  person_checkout_center_signature.checkout_center_oid
  person_checkout_center_signature.person_oid
  resource.barcode
  resource.unique_identifier
  resource_controller.device_id
  resource_type_certification.external_id
  resource_type_certification.name
  section_member.member_oid
  section_member.section_oid

  19 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

  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