SchemaSpy Analysis of homo_sapiens_core_52_36n Generated by
SchemaSpy
Generated by SchemaSpy on ma maalis 23 00:31 EET 2009
Database Type: MySQL - 5.0.45 SourceForge.net


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

71 Tables:

Table Children Parents Columns Rows Comments
alt_allele 2 0
analysis 14 61
analysis_description 5 60
assembly 7 93 250
assembly_exception 9 6
attrib_type 4 163
coord_system 6 5
density_feature 6 2 742 059
density_type 5 6
ditag 5 4 339 917
ditag_feature 13 3 960 124
dna 2 18 904
dna_align_feature 18 0
dnac 3 0
exon 8 297 956
exon_stable_id 5 297 956
exon_transcript 3 532 102
external_db 12 284
external_synonym 2 143 155
gene 14 37 435
gene_archive 8 130 208
gene_attrib 3 48 618
gene_stable_id 5 37 435
go_xref 3 278 639
identity_xref 11 524 768
interpro 2 20 821
karyotype 6 862
map 2 12
mapping_session 8 24
mapping_set 2 0
marker 8 323 011
marker_feature 7 298 226
marker_map_location 6 164 580
marker_synonym 4 778 217
meta 4 125
meta_coord 3 29
misc_attrib 3 417 826
misc_feature 5 89 155
misc_feature_misc_set 2 89 155
misc_set 5 6
object_xref 5 2 413 841
oligo_array 5 16
oligo_feature 8 13 513 596
oligo_probe 6 0
peptide_archive 3 99 816
prediction_exon 10 336 458
prediction_transcript 7 49 796
protein_align_feature 15 7 897 598
protein_feature 12 710 047
qtl 6 0
qtl_feature 5 0
qtl_synonym 4 0
repeat_consensus 5 551 839
repeat_feature 10 8 557 945
seq_region 4 54 695
seq_region_attrib 3 747
seq_region_mapping 3 0
simple_feature 8 172 763
stable_id_event 7 3 361 218
supporting_feature 3 2 459 047
transcript 12 63 280
transcript_attrib 3 443 237
transcript_stable_id 5 63 280
transcript_supporting_feature 3 126 334
translation 6 47 509
translation_attrib 3 332 394
translation_stable_id 5 47 509
unconventional_transcript_association 3 0
unmapped_object 11 0
unmapped_reason 3 793
xref 8 1 982 159

Columns: 431   Rows: 58 951 077