Tables Relationships Utility Tables Constraints Anomalies Columns Donate

SchemaSpy Analysis of psmops_ps1_mdrm137 - 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:

  Child Column | Implied Parent Column
  --- | ---
  runtime.event_id | history_attributions.event_id

  1 instance of anomaly detected

- Tables without indexes:

  Table | Rows
  --- | ---
  locks | 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:
  Anomaly not detected

- Tables with incrementing column names, potentially indicating denormalization:

  Table
  det_rawattr_v2
  fields
  history
  orbits
  ssm

  5 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