SchemaSpy Analysis of oplist - 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
  OPLIST.OPAID	OPLIST_AREA.OPAID
  OPLIST.OPPID	OPLIST_PRODUCT.OPPID
  OPLIST.OPSID	OPLIST_STAT.OPSID
  OPLIST_COMMENT.OPID	OPLIST.OPID
  OPLIST_COMMENT.OPUID	OPLIST_USERS.OPUID
  OPLIST_USERS.OPGID	OPLIST_GROUP.OPGID

  6 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  OPLIST_DEBUG	3
  OPLIST_VERSION	1

  2 instances 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:
  Anomaly not detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
  Anomaly not detected