SchemaSpy Analysis of characters - Anomalies UnifiedDB Character Database

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
  character_db_version	1
  guild_eventlog	0
  saved_variables	0

  3 instances of anomaly detected

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

• Tables that contain a single column:

  Table	Column
  character_db_version	required_7644_01_characters_character_pet
  saved_variables	NextArenaPointDistributionTime

  2 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  arena_team_stats
  character_queststatus
  character_tutorial
  groups
  guild_eventlog
  guild_member

  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