SchemaSpy Analysis of transmart.biomart Generated by
SchemaSpy
Generated by SchemaSpy on Wed Jun 26 00:10 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
annotation 7 0
assay_analysis_data 11 0
bio_ad_hoc_property 4 0
bio_analysis_attribute 5 0
bio_analysis_attribute_lineage 1 4 0
bio_analysis_cohort_xref 4 0
bio_assay 1 2 19 0
bio_assay_analysis 6 1 26 0
bio_assay_analysis_data 4 22 0
bio_assay_analysis_data_tea 4 22 0
bio_assay_analysis_eqtl 11 0
bio_assay_analysis_ext 1 23 0
bio_assay_analysis_gwas 1 2 24 0
bio_assay_cohort 12 0
bio_assay_data 3 12 0
bio_assay_data_annotation 3 38,602
bio_assay_data_stats 4 15 0
bio_assay_dataset 3 1 9 0
bio_assay_feature_group 3 3 54,675
bio_assay_geno_platform_probe 2 1 11 0
bio_assay_platform 5 17 133
bio_assay_sample 2 3 0
bio_asy_analysis_data_ext 1 3 0
bio_asy_analysis_data_idx 6 0
bio_asy_analysis_dataset 2 2 0
bio_asy_analysis_eqtl_top50 16 0
bio_asy_analysis_gwas_top50 1 18 0
bio_asy_analysis_pltfm 2 4 1
bio_asy_data_stats_all 1 14 0
bio_asy_platform_probe_anno 3 9 0
bio_cell_line 1 1 13 0
bio_cgdcp_data 7 0
bio_clinc_trial_attr 1 1 4 0
bio_clinc_trial_pt_group 1 1 6 0
bio_clinc_trial_time_pt 1 1 6 0
bio_clinical_trial 4 1 28 0
bio_clinical_trial_design 178 0
bio_cohort_exp_xref 3 0
bio_compound 1 14 0
bio_concept_code 6 407
bio_content 1 1 12 0
bio_content_reference 1 6 0
bio_content_repository 1 5 1
bio_curated_data 1 6 0
bio_curation_dataset 2 1 8 0
bio_data_attribute 5 0
bio_data_compound 1 3 0
bio_data_correl_descr 1 7 0
bio_data_correlation 1 4 0
bio_data_disease 1 3 0
bio_data_ext_code 7 317,117
bio_data_literature 1 6 0
bio_data_observation 3 0
bio_data_omic_marker 3 0
bio_data_platform 3 0
bio_data_taxonomy 1 3 0
bio_data_uid 3 135,158
bio_disease 2 10 26,714
bio_experiment 8 20 0
bio_lit_alt_data 1 1 76 0
bio_lit_amd_data 1 37 0
bio_lit_inh_data 1 37 0
bio_lit_int_data 1 16 0
bio_lit_int_model_mv 2 0
bio_lit_int_model_view 2 view
bio_lit_model_data 17 0
bio_lit_pe_data 1 6 0
bio_lit_ref_data 4 27 0
bio_lit_sum_data 10 0
bio_marker 7 108,037
bio_marker_correl_mv 4 view
bio_marker_correl_view 4 view
bio_marker_exp_analysis_mv 4 view
bio_marker_exp_analysis_mv_10 4 view
bio_metab_subpathway_view 3 view
bio_metab_superpathway_view 3 view
bio_observation 7 0
bio_patient 1 3 14 0
bio_patient_event 2 2 7 0
bio_patient_event_attr 2 6 0
bio_recombination_rates 4 0
bio_regulome_score 4 0
bio_sample 4 3 11 0
bio_species_organism 3 0
bio_stats_exp_marker 3 0
bio_subject 2 7 0
bio_taxonomy 1 4 1
biobank_sample 6 0
cta_results 10 0
ctd2_clin_inhib_effect 38 0
ctd2_disease 8 0
ctd2_inhib_details 15 0
ctd2_study 7 0
ctd2_trial_details 94 0
ctd_allowed_meds_treatment 9 0
ctd_arm_view 17 view
ctd_biomarker 4 0
ctd_biomarker_view 5 view
ctd_cell_info_view 5 view
ctd_clinical_chars_view 5 view
ctd_disease 5 0
ctd_drug_effects_view 10 view
ctd_drug_inhib 4 0
ctd_drug_inhibitor_view 5 view
ctd_events_view 9 view
ctd_experiments_view 14 view
ctd_expr_after_view 9 view
ctd_expr_baseline_view 9 view
ctd_expr_bio_view 7 view
ctd_expr_source_view 5 view
ctd_full 180 0
ctd_full_clinical_endpts_view 14 view
ctd_full_search_view 14 view
ctd_inclusion_criteria 8 0
ctd_primary_endpts 7 0
ctd_primary_endpts_view 8 view
ctd_prior_med_use_view 5 view
ctd_pulmonary_path_view 6 view
ctd_quant_params_view 9 view
ctd_reference_view 7 view
ctd_runin_therapies_view 11 view
ctd_sec_endpts 7 0
ctd_secondary_endpts_view 8 view
ctd_stats_view 7 view
ctd_study 4 0
ctd_study_details_view 8 view
ctd_td_design_view 10 view
ctd_td_excl_view 11 view
ctd_td_inclusion_view 23 view
ctd_td_smoker_view 6 view
ctd_td_sponsor_view 5 view
ctd_td_status_view 4 view
ctd_treatment_phases_view 11 view
dd 2 0
gene_info_test 4 0
gene_synonym_test 4 0
genego_gene_map 3 0
genotype_probe_annotation 1 21 0
gse_analysis 11 0
gse_probeset 3 0
heat_map_results 16 0
mesh 4 0
mesh_copy 3 0
mesh_descriptor 3 0
mesh_entry 2 0
mesh_path 5 0
mesh_temp 3 0
mesh_with_parent 4 view -- mesh terms with parent term relation
mirna_bio_assay_data_annot 3 0
mirna_bio_assay_feature_group 3 0
mirna_bio_marker 7 0
project_info 43 0
tests 10 0
tmp_bio_marker 3 0
tmp_omicsoft_compound 5 0
tmp_omicsoft_disease_m1 3 0
tmp_project_category 3 0
tmp_project_compound 3 0
tmp_project_disease 3 0
vw_faceted_search 34 view
vw_faceted_search_disease 2 view
           
121 Tables     1,602 680,846  
40 Views     331