SchemaSpy Analysis of cxgn.sgn - Anomalies

Generated by
SchemaSpy


Things that might not be 'quite right' about your schema:	Please support this project

Columns whose name and type imply a relationship to another table's primary key:

Child Column	Implied Parent Column
deprecated_markers.marker_id	marker.marker_id
fish_file.fish_result_id	fish_result_composite.fish_result_id
fish_karyotype_constants.chromo_num	fish_karyotype_constants_old.chromo_num
fish_result.chromo_num	fish_karyotype_constants_old.chromo_num
fish_result_composite.chromo_num	fish_karyotype_constants_old.chromo_num
map.map_id	deprecated_maps.map_id
marker_confidence.confidence_id	deprecated_marker_confidences.confidence_id
temp_marker_correspondence.tmc_id	temp_map_correspondence.tmc_id

8 instances of anomaly detected

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

Column
accession.accession_name_id
blast_annotations.apply_id
blast_annotations.blast_target_id
clone.clone_name
clone.clone_name
clone.library_id
clone.library_id
cloning_vector.name
deprecated_marker_confidences.legacy_conf_id
derived_from_source.source_col
derived_from_source.source_schema
derived_from_source.source_table
enzymes.enzyme_name
fish_experimenter.fish_experimenter_name
go.go_accession
interpro.interpro_accession
library.library_shortname
linkage_group.lg_name
linkage_group.map_version_id
marker_confidence.confidence_name
marker_experiment.location_id
marker_experiment.pcr_experiment_id
marker_experiment.rflp_experiment_id
organism.organism_name
pcr_product.band_size
pcr_product.enzyme_id
pcr_product.multiple_flag
pcr_product.pcr_exp_accession_id
pcr_product.predicted

29 instances of anomaly detected

Tables that contain a single column:
Anomaly not detected
Tables with incrementing column names, potentially indicating denormalization:

Table

library

map

marker_to_map

3 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