SchemaSpy Analysis of homo_sapiens_core_52_36n - 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
  alt_allele.gene_id	gene.gene_id
  analysis_description.analysis_id	analysis.analysis_id
  assembly_exception.seq_region_id	dna.seq_region_id
  density_feature.density_type_id	density_type.density_type_id
  density_feature.seq_region_id	dna.seq_region_id
  density_type.analysis_id	analysis.analysis_id
  ditag_feature.analysis_id	analysis.analysis_id
  ditag_feature.ditag_id	ditag.ditag_id
  ditag_feature.seq_region_id	dna.seq_region_id
  dna_align_feature.analysis_id	analysis.analysis_id
  dna_align_feature.external_db_id	external_db.external_db_id
  dna_align_feature.seq_region_id	dna.seq_region_id
  dnac.seq_region_id	dna.seq_region_id
  exon.exon_id	exon_stable_id.exon_id
  exon.seq_region_id	dna.seq_region_id
  exon_transcript.exon_id	exon_stable_id.exon_id
  exon_transcript.transcript_id	transcript.transcript_id
  external_synonym.xref_id	xref.xref_id
  gene.analysis_id	analysis.analysis_id
  gene.seq_region_id	dna.seq_region_id
  gene_archive.mapping_session_id	mapping_session.mapping_session_id
  gene_archive.peptide_archive_id	peptide_archive.peptide_archive_id
  gene_attrib.attrib_type_id	attrib_type.attrib_type_id
  gene_attrib.gene_id	gene.gene_id
  gene_stable_id.gene_id	gene.gene_id
  go_xref.object_xref_id	identity_xref.object_xref_id
  identity_xref.analysis_id	analysis.analysis_id
  karyotype.seq_region_id	dna.seq_region_id
  marker_feature.analysis_id	analysis.analysis_id
  marker_feature.marker_id	marker.marker_id
  marker_feature.seq_region_id	dna.seq_region_id
  marker_map_location.map_id	map.map_id
  marker_map_location.marker_id	marker.marker_id
  marker_map_location.marker_synonym_id	marker_synonym.marker_synonym_id
  marker_synonym.marker_id	marker.marker_id
  meta_coord.coord_system_id	coord_system.coord_system_id
  misc_attrib.attrib_type_id	attrib_type.attrib_type_id
  misc_attrib.misc_feature_id	misc_feature.misc_feature_id
  misc_feature.seq_region_id	dna.seq_region_id
  misc_feature_misc_set.misc_feature_id	misc_feature.misc_feature_id
  misc_feature_misc_set.misc_set_id	misc_set.misc_set_id
  object_xref.object_xref_id	identity_xref.object_xref_id
  object_xref.xref_id	xref.xref_id
  oligo_feature.analysis_id	analysis.analysis_id
  oligo_feature.seq_region_id	dna.seq_region_id
  oligo_probe.oligo_array_id	oligo_array.oligo_array_id
  prediction_exon.prediction_transcript_id	prediction_transcript.prediction_transcript_id
  prediction_exon.seq_region_id	dna.seq_region_id
  prediction_transcript.analysis_id	analysis.analysis_id
  prediction_transcript.seq_region_id	dna.seq_region_id
  protein_align_feature.analysis_id	analysis.analysis_id
  protein_align_feature.external_db_id	external_db.external_db_id
  protein_align_feature.seq_region_id	dna.seq_region_id
  protein_feature.analysis_id	analysis.analysis_id
  protein_feature.translation_id	translation.translation_id
  qtl_feature.analysis_id	analysis.analysis_id
  qtl_feature.qtl_id	qtl.qtl_id
  qtl_feature.seq_region_id	dna.seq_region_id
  qtl_synonym.qtl_id	qtl.qtl_id
  repeat_feature.analysis_id	analysis.analysis_id
  repeat_feature.repeat_consensus_id	repeat_consensus.repeat_consensus_id
  repeat_feature.seq_region_id	dna.seq_region_id
  seq_region.coord_system_id	coord_system.coord_system_id
  seq_region.seq_region_id	dna.seq_region_id
  seq_region_attrib.attrib_type_id	attrib_type.attrib_type_id
  seq_region_attrib.seq_region_id	dna.seq_region_id
  simple_feature.analysis_id	analysis.analysis_id
  simple_feature.seq_region_id	dna.seq_region_id
  stable_id_event.mapping_session_id	mapping_session.mapping_session_id
  supporting_feature.exon_id	exon_stable_id.exon_id
  transcript.analysis_id	analysis.analysis_id
  transcript.gene_id	gene.gene_id
  transcript.seq_region_id	dna.seq_region_id
  transcript_attrib.attrib_type_id	attrib_type.attrib_type_id
  transcript_attrib.transcript_id	transcript.transcript_id
  transcript_stable_id.transcript_id	transcript.transcript_id
  transcript_supporting_feature.transcript_id	transcript.transcript_id
  translation.transcript_id	transcript.transcript_id
  translation_attrib.attrib_type_id	attrib_type.attrib_type_id
  translation_attrib.translation_id	translation.translation_id
  translation_stable_id.translation_id	translation.translation_id
  unconventional_transcript_association.gene_id	gene.gene_id
  unconventional_transcript_association.transcript_id	transcript.transcript_id
  unmapped_object.analysis_id	analysis.analysis_id
  unmapped_object.external_db_id	external_db.external_db_id
  unmapped_object.unmapped_reason_id	unmapped_reason.unmapped_reason_id
  xref.external_db_id	external_db.external_db_id

  87 instances of anomaly detected

• Tables without indexes:
  Anomaly not 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:

  Table
  qtl

  1 instance 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