SchemaSpy Analysis of aaddec36 - Anomaliesgenerated

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:
  Anomaly not detected

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

  Column
  acl_role_sets.hash
  oauth_consumer.c_key
  session_active.session_id
  upgrade_history.md5sum

  4 instances of anomaly detected

• Tables that contain a single column:
  Anomaly not detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  custom_fields
  expressions
  fields_meta_data
  pmse_bpmn_flow
  workflow_actions
  workflow_alerts

  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