SchemaSpy Analysis of backend_dev.public - 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
  execution_audit

  1 instance of anomaly detected

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

  Column
  ctrl_control.id_proposal
  ctrl_control.next_number
  sec_operator.login
  sec_permission.name
  sec_role.registration_date
  sec_system.registration_date

  6 instances of anomaly detected

• Tables that contain a single column:
  Anomaly not detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  aggregate_year_expense
  contract
  evaluation_analysis
  evaluation_notification
  formal_opinion
  notification
  pay_payment_opinion

  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