SchemaSpy Analysis of cxgn.phenome

Generated by
SchemaSpy
Generated by SchemaSpy on Wed May 20 01:35 EDT 2009
Database Type: PostgreSQL - 8.1.11 SourceForge.net

Please support this project

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

38 Tables:

Table Children Parents Rows Comments
allele 5 1 7,052
allele_alias 1 605
allele_dbxref 1 5
allele_history 2 13
dbxref_type 9
genotype 2 2 1,103
genotype_experiment 1 9
genotype_region 1 79,717 polymorphic regions from a genotype, delineated by markers in a certain linkage group on a certain map
germplasm 1 0
image 1 0
individual 6 1 7,570
individual_allele 2 4,150
individual_dbxref 2 1 9,727
individual_dbxref_evidence 1 1 7,755
individual_dbxref_evidence_history 2 1
individual_history 1 424
individual_locus 2 3,889
locus 14 5,782
locus2locus 2 435
locus_alias 1 6,809
locus_dbxref 2 1 35,643
locus_dbxref_evidence 1 1 22,682
locus_dbxref_evidence_history 2 12
locus_history 1 486
locus_marker 1 22
locus_owner 1 5,916
locus_registry 2 3
locus_unigene 1 9,545
phenotype 2 3 0
phenotype_term 1 0
polymorphic_fragment 1 152
population 3 18
population_dbxref 1 4
registry 1 2,564
tomato_il_bin 107
tomato_term 0
tomato_term2term 0
variant 1 0

Total rows: 212,209