SchemaSpy Analysis of sola.public - AnomaliesDefault schema for all PostgreSQL databases. Contains functions supporting the PostGIS and UUID-OSSP extensions as well as some common SOLA functions. For information on PostGIS functions see http://postgis.net/docs/reference.html. For information on UUID-OSSP functions see http://www.postgresql.org/docs/9.3/static/uuid-ossp.html

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
  Function: clean_db
  Function: clean_db_foreign_constraints
  Function: clean_db_triggers
  Function: compare_strings
  Function: fn_triggerall
  Function: get_geometry_with_srid
  Function: get_translation
  Trigger Function: f_for_trg_track_changes
  Trigger Function: f_for_trg_track_history

  9 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:
  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