SchemaSpy Analysis of cxgn.phenome |
Generated by SchemaSpy |
| Generated by SchemaSpy on Thu Jul 24 01:30 EDT 2008 | |
| 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: 184,535
| Table | Children | Parents | Rows | Comments |
|---|---|---|---|---|
| allele | 5 | 1 | 5,452 | |
| allele_alias | 1 | 605 | ||
| allele_dbxref | 1 | 5 | ||
| allele_history | 2 | 10 | ||
| 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 | 6,934 | |
| individual_allele | 2 | 4,137 | ||
| individual_dbxref | 2 | 1 | 9,716 | |
| individual_dbxref_evidence | 1 | 1 | 7,755 | |
| individual_dbxref_evidence_history | 2 | 1 | ||
| individual_history | 1 | 419 | ||
| individual_locus | 2 | 3,889 | ||
| locus | 14 | 4,186 | ||
| locus2locus | 2 | 260 | ||
| locus_alias | 1 | 4,603 | ||
| locus_dbxref | 2 | 1 | 25,849 | |
| locus_dbxref_evidence | 1 | 1 | 16,489 | |
| locus_dbxref_evidence_history | 2 | 12 | ||
| locus_history | 1 | 313 | ||
| locus_marker | 1 | 22 | ||
| locus_owner | 1 | 4,260 | ||
| locus_registry | 2 | 3 | ||
| locus_unigene | 1 | 5,933 | ||
| phenotype | 2 | 3 | 0 | |
| phenotype_term | 1 | 0 | ||
| polymorphic_fragment | 1 | 152 | ||
| population | 3 | 17 | ||
| population_dbxref | 1 | 4 | ||
| registry | 1 | 2,564 | ||
| tomato_il_bin | 107 | |||
| tomato_term | 0 | |||
| tomato_term2term | 0 | |||
| variant | 1 | 0 |