SchemaSpy Analysis of sola.system - AnomaliesExtension to the LADM that contains SOLA system configuration, business rules and user details.

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: consolidation_consolidate
  Function: consolidation_extract
  Function: get_setting
  Function: get_text_from_schema
  Function: script_to_schema
  Function: setpassword

  6 instances of anomaly detected

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

  Column
  appuser.email

  1 instance of anomaly detected

• Tables that contain a single column:

  Table	Column
  version	version_num

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