SchemaSpy Analysis of idempiere9.adempiere - AnomaliesAssets

Generated by Quality Systems & Solutions

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

• Tables that contain a single column:
  Anomaly not detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  a_asset_info_oth
  a_asset_spread
  ad_user
  c_bpartner
  c_bpartner_location
  c_location
  m_product
  r_mailtext

  8 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