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 |
Please support this project |
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
38 Tables:
Total rows: 212,209
| 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 |