SchemaSpy Analysis of transmart.deapp - Constraints Generated by
SchemaSpy
27 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
de_chrom_region_gpl_id_fkey de_chromosomal_region.gpl_id de_gpl_info.platform Restrict delete 
de_met_sub_pw_met_met_id_fk de_metabolite_sub_pway_metab.metabolite_id de_metabolite_annotation.id Restrict delete 
de_met_sub_pw_met_sub_pw_id_fk de_metabolite_sub_pway_metab.sub_pathway_id de_metabolite_sub_pathways.id Restrict delete 
de_met_sub_pw_sup_pw_id_fkey de_metabolite_sub_pathways.super_pathway_id de_metabolite_super_pathways.id Restrict delete 
de_rbm_data_ann_jn_ann_id_fk de_rbm_data_annotation_join.annotation_id de_rbm_annotation.id Cascade on delete 
de_rnaseq_transcript_annot_gpl_id_fkey de_rnaseq_transcript_annot.gpl_id de_gpl_info.platform Restrict delete 
de_rnaseq_transcript_data_transcript_id_fkey de_rnaseq_transcript_data.transcript_id de_rnaseq_transcript_annot.id Restrict delete 
de_sj_met_data_met_ann_id_fk de_subject_metabolomics_data.metabolite_annotation_id de_metabolite_annotation.id Restrict delete 
de_subj_acgh_region_id_fkey de_subject_acgh_data.region_id de_chromosomal_region.region_id Restrict delete 
de_subj_rnaseq_region_id_fkey de_subject_rnaseq_data.region_id de_chromosomal_region.region_id Restrict delete 
de_variant_population_data_fk de_variant_population_data.dataset_id de_variant_dataset.dataset_id Restrict delete 
de_variant_population_info_fk de_variant_population_info.dataset_id de_variant_dataset.dataset_id Restrict delete 
dexcm_parent_cd_fk de_xtrial_child_map.parent_cd de_xtrial_parent_names.parent_cd Restrict delete 
fk_protein_annotation_id de_subject_protein_data.protein_annotation_id de_protein_annotation.id Restrict delete 
fk_snp_by_probe_probe_id de_snp_data_by_probe.probe_id de_snp_probe.snp_probe_id Restrict delete 
fk_snp_by_probe_snp_id de_snp_data_by_probe.snp_id de_snp_info.snp_info_id Restrict delete 
fk_snp_dataset_id de_snp_data_by_patient.snp_dataset_id de_subject_snp_dataset.subject_snp_dataset_id Restrict delete 
fk_snp_loc_dataset_id de_snp_data_dataset_loc.snp_dataset_id de_subject_snp_dataset.subject_snp_dataset_id Restrict delete 
fk_snp_probe_snp_id de_snp_probe.snp_id de_snp_info.snp_info_id Restrict delete 
gpl_id de_variant_dataset.gpl_id de_gpl_info.platform Restrict delete 
two_region_event_gene_id_event_fk de_two_region_event_gene.event_id de_two_region_event.two_region_event_id Restrict delete 
two_region_junction_event_id_event_fk de_two_region_junction_event.event_id de_two_region_event.two_region_event_id Restrict delete 
two_region_junction_event_id_junction_fk de_two_region_junction_event.junction_id de_two_region_junction.two_region_junction_id Restrict delete 
var_met_dataset_id de_variant_metadata.dataset_id de_variant_dataset.dataset_id Restrict delete 
variant_subject_detail_fk de_variant_subject_detail.dataset_id de_variant_dataset.dataset_id Restrict delete 
variant_subject_idx_fk de_variant_subject_idx.dataset_id de_variant_dataset.dataset_id Restrict delete 
variant_subject_summary_fk de_variant_subject_summary.dataset_id de_variant_dataset.dataset_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected