Schema Browser
 Home  | About  | Help  | FAQ  
SchemaSpy Analysis of mgd.mgd Generated by
SchemaSpy
Generated by SchemaSpy on Mon Sep 26 19:11 EDT 2011
Database Type: PostgreSQL - 9.0.2 SourceForge.net

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

Table Children Parents Columns Rows Comments
acc_accession 1 4 13 26,745,246
acc_accessionmax 4 2
acc_accessionreference 4 6 6,971,542
acc_actualdb 3 11 111
acc_logicaldb 3 2 8 158
acc_mgitype 20 2 10 36
all_allele 9 9 19 756,115
all_allele_cellline 4 7 859,030
all_allele_mutation 1 4 746,100
all_cellline 2 4 10 883,807
all_cellline_derivation 8 13 4,734
all_cre_cache 7 17 10,533
all_knockout_cache 4 12 257
all_label 8 1,523,035
all_marker_assoc 6 10 407,664
bib_books 1 8 320
bib_citation_cache 1 11 169,860
bib_dataset 1 2 10 10
bib_dataset_assoc 4 8 273,650
bib_notes 1 5 12,005
bib_refs 30 3 21 169,860
bib_reviewstatus 1 4 3
crs_cross 4 3 19 4,491
crs_matrix 2 2 8 28,009
crs_progeny 1 7 3,610
crs_references 3 5 7,596
crs_typings 2 6 63,596
dag_closure 6 10 702,441
dag_dag 5 2 7 9
dag_edge 3 8 78,399
dag_label 4 4 9
dag_node 3 2 6 47,041
go_tracking 4 8 84,722
gxd_allelegenotype 5 8 76,322
gxd_allelepair 8 12 61,391
gxd_antibody 3 6 14 3,910
gxd_antibodyalias 2 6 597
gxd_antibodyclass 1 4 13
gxd_antibodymarker 2 4 4,062
gxd_antibodyprep 1 3 6 5,960
gxd_antibodytype 1 4 4
gxd_antigen 1 3 9 3,218
gxd_assay 6 9 12 55,699
gxd_assaynote 1 5 25,726
gxd_assaytype 2 6 12
gxd_embeddingmethod 1 4 8
gxd_expression 6 16 1,122,649
gxd_fixationmethod 1 4 18
gxd_gelband 2 7 213,154
gxd_gelcontrol 1 4 12
gxd_gellane 1 4 16 190,624
gxd_gellanestructure 2 4 174,929
gxd_gelrnatype 1 4 4
gxd_gelrow 1 2 8 24,940
gxd_gelunits 1 4 7
gxd_genotype 6 4 9 48,120
gxd_index 5 10 128,162
gxd_index_stages 4 7 328,346
gxd_insituresult 2 3 8 910,035
gxd_insituresultimage 2 4 988,870
gxd_isresultstructure 2 4 949,352
gxd_label 2 4 31
gxd_pattern 1 4 14
gxd_probeprep 1 4 8 48,208
gxd_probesense 1 4 4
gxd_secondary 1 4 5
gxd_specimen 1 4 16 227,885
gxd_strength 2 4 10
gxd_structure 8 4 14 17,394
gxd_structureclosure 2 4 110,636
gxd_structurename 1 1 6 20,962
gxd_theilerstage 1 1 8 28
gxd_visualizationmethod 1 4 10
hmd_assay 1 5 14
hmd_class 1 3 19,630
hmd_homology 2 2 5 40,716
hmd_homology_assay 2 4 70,438
hmd_homology_marker 1 4 143,855
hmd_notes 1 5 78
img_cache 2 16 226,742
img_image 1 7 13 382,086
img_imagepane 3 5 297,860
img_imagepane_assoc 4 9 6,121
map_coord_collection 1 2 7 10
map_coord_feature 4 11 2,638,074
map_coordinate 2 6 15 207
mgi_attributehistory 3 7 12,396,027
mgi_columns 1 6 1,611
mgi_dbinfo 8 1
mgi_measurement 1 5 66,218
mgi_note 1 4 8 1,656,952
mgi_notechunk 3 7 2,255,038
mgi_notetype 1 3 8 35
mgi_organism 9 2 7 50
mgi_organism_mgitype 4 6 115
mgi_refassoctype 1 3 8 27
mgi_reference_assoc 5 9 5,636,129
mgi_roletask 4 7 88
mgi_set 1 3 8 41
mgi_setmember 3 8 4,981
mgi_statistic 2 6 90
mgi_statisticsql 1 3 102
mgi_synonym 4 10 304,974
mgi_synonymtype 4 10 29
mgi_tables 1 6 202
mgi_translation 3 9 3,510
mgi_translationtype 1 4 10 18
mgi_user 163 4 9 214
mgi_userrole 3 7 330
mgi_vocassociation 5 9 61
mgi_vocassociationtype 1 4 9 2
mlc_marker 3 5 1,322
mlc_reference 3 5 3,764
mlc_text 2 1 7 389
mld_assay_types 1 4 77
mld_concordance 3 10 11,827
mld_contig 1 1 8 2,054
mld_contigprobe 2 5 14,342
mld_distance 4 13 157
mld_expt_marker 4 10 175,427
mld_expt_notes 1 5 45,549
mld_expts 16 1 7 22,289
mld_fish 1 2 12 1,429
mld_fish_region 2 7 77
mld_hit 3 5 50,872
mld_hybrid 1 1 5 651
mld_insitu 1 2 12 449
mld_isregion 2 6 2,523
mld_matrix 1 2 8 6,925
mld_mc2point 2 8 10,047
mld_mcdatalist 2 6 30,246
mld_notes 1 5 1,709
mld_physmap 1 1 5 52
mld_ri 1 5 3,501
mld_ri2point 2 9 524
mld_ridata 1 6 12,779
mld_statistics 3 10 27,147
mrk_alias 2 4 590
mrk_anchors 1 4 192
mrk_chromosome 3 8 364
mrk_class 1 4 34
mrk_classes 2 4 6,164
mrk_current 2 4 139,336
mrk_event 1 4 8
mrk_eventreason 1 4 9
mrk_history 7 12 194,585
mrk_homology_cache 1 6 143,854
mrk_label 3 11 1,598,996
mrk_location_cache 3 17 139,279
mrk_marker 51 6 13 318,837
mrk_mcv_cache 3 9 266,536
mrk_mcv_count_cache 2 6 40
mrk_notes 1 5 13,884
mrk_offset 1 5 239,540
mrk_omim_cache 3 29 11,314
mrk_reference 2 8 1,187,517
mrk_status 1 4 5
mrk_types 2 4 9
prb_alias 3 7 38,357
prb_allele 1 3 8 64,255
prb_allele_strain 4 6 138,919
prb_marker 5 8 1,072,278
prb_notes 1 5 97,544
prb_probe 9 6 16 2,152,740
prb_ref_notes 1 5 2,329
prb_reference 3 4 9 2,840,499
prb_rflv 1 4 8 22,686
prb_source 3 8 19 57,241
prb_strain 11 4 10 29,444
prb_strain_genotype 4 8 11,329
prb_strain_marker 4 9 24,150
prb_tissue 5 559
ri_riset 1 2 9 40
ri_summary 2 6 9,583
ri_summary_expt_ref 1 5 12,716
seq_allele_assoc 6 9 853,930
seq_coord_cache 4 13 868,006
seq_description_cache 3 6 848,591
seq_genemodel 4 9 92,250
seq_genetrap 6 10 906,841
seq_marker_cache 7 18 1,123,965
seq_probe_cache 5 8 2,171,423
seq_sequence 10 7 18 11,959,131
seq_sequence_assoc 5 8 254,851
seq_sequence_raw 3 13 11,959,131
seq_source_assoc 4 7 11,959,131
voc_allele_cache 3 204,481
voc_annot 1 2 7 663,344
voc_annot_count_cache 5 46,671
voc_annotheader 5 12 112,605
voc_annottype 2 4 8 10
voc_evidence 1 5 9 646,087
voc_evidence_property 4 10 125,166
voc_go_cache 2 5 34,977
voc_marker_cache 1 3 982,580
voc_term 65 3 10 95,180
voc_text 1 5 50,317
voc_vocab 8 2 8 79
voc_vocabdag 2 4 9
wks_rosetta 1 6 64
           
200 Tables     1,592 129,668,718  
0 Views     0