SchemaSpy Analysis of eZ Publish - AnomalieseZ Publish 4.6 Database Schema Diagram

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
  ezcontentobject.remote_id
  ezmodule_run.workflow_process_id
  ezsearch_search_phrase.phrase

  3 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  ezorder_nr_incr	id
  ezurlalias_ml_incr	id

  2 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  ezcollab_item
  ezcollab_simple_message
  ezcontentclass_attribute
  eznotificationevent
  ezorder
  ezworkflow_event

  6 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