SchemaSpy Analysis of transmart.deapp Generated by
SchemaSpy
Generated by SchemaSpy on Wed Jun 26 00:11 CEST 2019
Database Type: PostgreSQL - 10.9 (Ubuntu 10.9-0ubuntu0.18.10.1) SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Rows Comments
de_chromosomal_region 2 1 11 0
de_concept_visit 3 0
de_encounter_level 3 0
de_encounter_type 4 0
de_gene_info 9 0
de_gene_source 5 0
de_gpl_info 3 8 0 Definition of GPL platforms
de_metabolite_annotation 2 5 0
de_metabolite_sub_pathways 1 1 4 0
de_metabolite_sub_pway_metab 2 2 0
de_metabolite_super_pathways 1 3 0
de_mrna_annotation 7 0
de_obs_enroll_days 3 0
de_pathway 8 0
de_pathway_gene 4 0
de_protein_annotation 1 10 0
de_qpcr_mirna_annotation 7 0
de_rbm_annotation 1 7 0
de_rbm_data_annotation_join 1 2 0
de_rc_snp_info 27 0
de_rnaseq_annotation 6 0
de_rnaseq_transcript_annot 1 1 7 0
de_rnaseq_transcript_data 1 6 0 Table holds rnaseq transcript level values.
de_sample_snp_data 4 0
de_saved_comparison 3 0
de_snp_calls_by_gsm 5 0
de_snp_copy_number 6 0
de_snp_data_by_patient 1 7 0
de_snp_data_by_probe 2 28 0
de_snp_data_dataset_loc 1 4 0
de_snp_gene_map 4 view
de_snp_info 2 4 0
de_snp_info_hg19_mv 7 view
de_snp_probe 1 1 5 0
de_snp_probe_sorted_def 6 0
de_snp_subject_sorted_def 7 0
de_subject_acgh_data 1 13 0
de_subject_metabolomics_data 1 10 0
de_subject_microarray_data 14 0 Table holds microarray data values.
de_subject_microarray_data_new 8 0
de_subject_microarray_logs 11 0
de_subject_microarray_med 15 0
de_subject_mirna_data 9 0
de_subject_protein_data 1 12 0
de_subject_proteomics_data 11 0
de_subject_rbm_data 21 0
de_subject_rna_data 9 0
de_subject_rnaseq_data 1 10 0
de_subject_sample_mapping 28 0 Table to store information about assays, which are associated with high dimensional observations. Assays are typically associated with a patient. There can be many assays per patient, which may be distinguished by sample code, tissue type, platform, etc.
de_subject_snp_dataset 2 11 0
de_two_region_event 2 3 0
de_two_region_event_gene 1 4 0
de_two_region_junction 1 12 0
de_two_region_junction_event 2 10 0
de_variant_dataset 6 1 8 0
de_variant_metadata 1 4 0
de_variant_population_data 1 9 0
de_variant_population_info 1 6 0
de_variant_subject_detail 1 12 0
de_variant_subject_idx 1 4 0
de_variant_subject_summary 1 13 0
de_variant_summary_detail_gene 22 view
de_xtrial_child_map 1 4 0
de_xtrial_parent_names 1 3 0
deapp_annotation 4 0
haploview_data 12 0
kegg 3 0
kegg_data 3 0
kegg_def 2 0
ricerca 2 0
           
67 Tables     530 0  
3 Views     33