SchemaSpy Analysis of qwat.qwat_od - 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:
  Anomaly not detected

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

  Column
  consumptionzone.name
  distributor.name
  protectionzone.name

  3 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  samplingpoint	id

  1 instance of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  node
  pipe
  pressurezone
  remote
  tank
  valve
  vw_element_hydrant
  vw_element_installation
  vw_element_meter
  vw_element_part
  vw_element_samplingpoint
  vw_element_subscriber
  vw_export_hydrant
  vw_export_installation
  vw_export_leak
  vw_export_meter
  vw_export_part
  vw_export_pipe
  vw_export_subscriber
  vw_export_valve
  vw_installation_tank
  vw_node_element
  vw_qwat_installation
  vw_qwat_network_element
  vw_qwat_node

  25 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