SchemaSpy Analysis of topp.wc2 - 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
  all	71,990
  argos	22,573
  behavior	9,977
  columns	18
  corrupt	13,913
  deployment	40
  fastgps	12,787
  haulout	414
  histos	1,659
  labels	105
  locations	28,863
  minmaxdepth	1,795
  rawargos	72,150
  rtc	76
  series	177
  seriesrange	4
  sst	705
  status	1,916
  summary	40

  19 instances of anomaly detected

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

• Tables that contain a single column:
  Anomaly not detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  all
  argos
  behavior
  corrupt
  fastgps
  histos
  rawargos

  7 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