SchemaSpy Analysis of arcasys - 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	Rows
  plugin_schema_info	1
  posper_productean	1

  2 instances of anomaly detected

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

  Column
  bo_translations.column_id
  bo_translations.language_id
  bo_translations.record_id
  bo_translations.table_id
  bo_uitranslations.language_id
  bo_uitranslations.string_id
  posper_currency.currency_code
  posper_floor.visibleId
  posper_location.visibleId
  posper_tax.visibleId
  timeaccounts.employee_id
  timeaccounts.month

  12 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  posper_ticketcreationgenerator	id
  schema_migrations	version

  2 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  employees
  posper_customer
  posper_customergroup
  posper_product
  posper_valuecard
  rosters
  speps_suppliers

  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