SchemaSpy Analysis of transmart.deapp - 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 de_concept_visit.concept_cd de_xtrial_child_map.concept_cd de_gene_info.gene_source_id de_gene_source.gene_source_id de_metabolite_annotation.id de_pathway_gene.id de_metabolite_sub_pathways.id de_pathway_gene.id de_metabolite_super_pathways.id de_pathway_gene.id de_pathway.id de_pathway_gene.id de_rbm_annotation.id de_pathway_gene.id de_rnaseq_transcript_annot.id de_pathway_gene.id de_subject_mirna_data.probeset_id de_qpcr_mirna_annotation.probeset_id de_subject_rbm_data.id de_pathway_gene.id de_subject_sample_mapping.platform de_gpl_info.platform - Tables without indexes:
-
Columns that are flagged as both 'nullable' and 'must be unique':
Column de_rc_snp_info.hg_version de_rc_snp_info.rs_id de_snp_info.name de_snp_probe.probe_name de_variant_subject_detail.chr de_variant_subject_detail.dataset_id de_variant_subject_detail.pos de_variant_subject_detail.rs_id de_variant_subject_idx.dataset_id de_variant_subject_idx.position de_variant_subject_idx.subject_id de_xtrial_parent_names.across_path -
Tables that contain a single column:
Anomaly not detected -
Tables with incrementing column names, potentially indicating denormalization:
Table de_saved_comparison de_snp_data_by_probe de_variant_subject_summary de_variant_summary_detail_gene -
Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
Anomaly not detected