SchemaSpy Analysis of cxgn.public - 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:
10 instances of anomaly detectedChild Column Implied Parent Column ara_domain.agi ara_annotation.agi ara_gfp_ms.agi ara_annotation.agi ara_intron.agi ara_annotation.agi ara_properties.agi ara_annotation.agi ara_scop.agi ara_annotation.agi ara_sequence.agi ara_annotation.agi ara_signalp.agi ara_annotation.agi ara_targetp.agi ara_annotation.agi unigene_dbxref.unigene_id unigene_signalp.unigene_id unigene_relations.unigene_id unigene_signalp.unigene_id -
Tables without indexes:
11 instances of anomaly detectedTable Rows ara_evidef 12 ara_family 0 ara_go_term 0 ara_pmidlink 0 ara_prefix_info 0 ara_users 0 cvterm_pub_ranking 164,937 locus_pub_ranking 302,243 locus_pub_ranking_validate 18 marker_names 7,223 signalp 273,015 -
Columns that are flagged as both 'nullable' and 'must be unique':
6 instances of anomaly detectedColumn clone_feature.clone_id clone_feature.feature_id clone_in_silico_digestion.clone_id clone_in_silico_digestion.enzyme_id materialized_view.name pub_curator.pub_id -
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