SchemaSpy Analysis of topp.atn - 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
  deployment_bak.deployment_id	deployment.deployment_id
  download_product_urls.idx	download_product_urls_test.idx

  2 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  deployment_bak	60
  hints	1
  new_users	0
  new_wc	0

  4 instances of anomaly detected

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

  Column
  deployment.local_deployment_name
  deployment.userid
  event.deployment_id
  event.multi_tag_serial
  users.username

  5 instances of anomaly detected

• Tables that contain a single column:
  Anomaly not detected

• Tables with incrementing column names, potentially indicating denormalization:
  Anomaly not detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
  Anomaly not detected