SchemaSpy Analysis of TBASE2.TBASE2 - 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
  CHARGROUP_PHYLOCHAR.CHARGROUP_ID	CHARGROUP.CHARGROUP_ID
  CHARGROUP_PHYLOCHAR.PHYLOCHAR_ID	PHYLOCHAR.PHYLOCHAR_ID
  CHARSET_PHYLOCHAR.CHARSET_ID	CHARSET.CHARSET_ID
  CHARSET_PHYLOCHAR.PHYLOCHAR_ID	PHYLOCHAR.PHYLOCHAR_ID
  DISCRETECHARSTATE.DISCRETECHARSTATE_ID	STEPMATRIXELEMENT.DISCRETECHARSTATE_ID
  NEXUSFILEOBJECT.STUDY_ID	STUDY.STUDY_ID
  SPECIMENLABEL.STUDY_ID	STUDY.STUDY_ID
  SPECIMENLABEL.TAXON_ID	TAXON.TAXON_ID
  SUB_PHYLOTREE.COLLECTION_ID	SUB_MATRIX.COLLECTION_ID
  SUB_PHYLOTREE.PHYLOTREE_ID	PHYLOTREE.PHYLOTREE_ID
  SUB_PHYLOTREE.SUBMISSION_ID	SUBMISSION.SUBMISSION_ID
  SUB_TREEBLOCK.COLLECTION_ID	SUB_MATRIX.COLLECTION_ID
  TEST_ELEMENT.DISCRETECHARSTATE_ID	STEPMATRIXELEMENT.DISCRETECHARSTATE_ID
  TEST_ELEMENT.ITEMDEFINITION_ID	ITEMDEFINITION.ITEMDEFINITION_ID
  TEST_ELEMENT.MATRIXCOLUMN_ID	MATRIXCOLUMN.MATRIXCOLUMN_ID
  TEST_ELEMENT.MATRIXELEMENT_ID	MATRIXELEMENT.MATRIXELEMENT_ID
  TEST_ELEMENT.MATRIXROW_ID	MATRIXROW.MATRIXROW_ID
  TESTTREE.STUDY_ID	STUDY.STUDY_ID
  TESTTREE.TREEATTRIBUTE_ID	TREEATTRIBUTE.TREEATTRIBUTE_ID
  TESTTREE.TREEQUALITY_ID	TREEQUALITY.TREEQUALITY_ID
  TESTTREE.TREETYPE_ID	TREETYPE.TREETYPE_ID

  21 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  ADVISE_INDEX	0
  ADVISE_WORKLOAD	0
  CHARGROUP_PHYLOCHAR	0
  CONTANCSTATE_VALUE	0
  EXPLAIN_ARGUMENT	22,249
  EXPLAIN_OBJECT	5,419
  EXPLAIN_OPERATOR	7,933
  EXPLAIN_PREDICATE	377
  EXPLAIN_STREAM	10,540
  LEFTCHANGESET_CHARSTATE	0
  RIGHTCHANGESET_CHARSTATE	0
  TAXONLABELROUP_TAXONLABEL	0

  12 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