SchemaSpy Analysis of pathways_us_2017-1-15.public - AnomaliesThis schema analysis is based on the U.S. database for EnergyPATHWAYS, maintained by Evolved Energy Research, and row counts reflect the dated version.

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
  Version	1

  1 instance 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
  CurrencyYears	id
  GeographyIntersection	id

  2 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  EnergyDemand

  1 instance 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