SchemaSpy Analysis of homo_sapiens_core_98_38 Generated by
SchemaSpy
Generated by SchemaSpy on Wed Nov 27 11:43 CET 2019
Database Type: MySQL - 5.6.33 SourceForge.net


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

Table Children Parents Columns Rows Comments
alt_allele 3 8,601
alt_allele_attrib 2 9,897
alt_allele_group 1 3,142
analysis 14 91
analysis_description 5 91
assembly 7 1,188,345
assembly_exception 9 447
associated_group 2 0
associated_xref 7 0
attrib_type 4 331
biotype 9 207
coord_system 6 9
data_file 8 0
density_feature 6 21,525
density_type 5 7
dependent_xref 3 2,344,681
ditag 5 0
ditag_feature 13 0
dna 2 133,770
dna_align_feature 17 29,072,149
dna_align_feature_attrib 3 0
exon 13 830,738
exon_transcript 3 1,512,878
external_db 10 446
external_synonym 2 54,087
gene 16 67,946
gene_archive 8 612,707
gene_attrib 3 429,242
genome_statistics 6 29
identity_xref 10 246,918
interpro 2 22,620
intron_supporting_evidence 10 0
karyotype 6 862
map 2 12
mapping_session 8 56
mapping_set 3 22
marker 8 296,045
marker_feature 7 297,654
marker_map_location 6 164,580
marker_synonym 4 720,716
meta 4 183
meta_coord 3 28
misc_attrib 3 19,564,162
misc_feature 5 6,498,696
misc_feature_misc_set 2 6,498,696
misc_set 5 46
object_xref 6 5,153,057
ontology_xref 3 1,653,321
operon 11 0
operon_transcript 12 0
operon_transcript_gene 2 0
peptide_archive 3 447,299
prediction_exon 10 363,248
prediction_transcript 7 51,756
protein_align_feature 16 10,566,325
protein_feature 15 1,789,147
repeat_consensus 5 564,209
repeat_feature 10 14,969,798
rnaproduct 11 0
rnaproduct_attrib 3 0
rnaproduct_type 4 0
seq_region 4 268,444
seq_region_attrib 3 5,930
seq_region_mapping 3 6,165
seq_region_synonym 4 2,360
simple_feature 8 197,783
stable_id_event 7 2,348,742
supporting_feature 3 7,355,029
transcript 17 250,194
transcript_attrib 3 2,060,301
transcript_intron_supporting_evidence 4 0
transcript_supporting_feature 3 119,030
translation 10 111,822
translation_attrib 3 660,281
unmapped_object 11 1,006,960
unmapped_reason 3 51
xref 8 2,858,554
           
77 Tables     492 123,412,468  
0 Views     0