SchemaSpy Analysis of cxgn.genomic |
Generated by SchemaSpy |
| Generated by SchemaSpy on Wed May 20 01:31 EDT 2009 | |
| Database Type: PostgreSQL - 8.1.11 |
Please support this project |
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
18 Tables:
Total rows: 6,310,519
| Table | Children | Parents | Rows | Comments |
|---|---|---|---|---|
| blast_db | 1 | 7 | ||
| blast_defline | 73,443 | |||
| blast_hit | 1 | 1,664,130 | ||
| blast_query | 1 | 2 | 1,952,983 | |
| chromat | 1 | 1 | 613,368 | |
| clone | 1 | 2 | 473,472 | |
| clone_type | 2 | 2 | ||
| genbank_submission | 1 | 2 | ||
| gss | 2 | 1 | 613,728 | |
| gss_submitted_to_genbank | 2 | 305,545 | ||
| library | 2 | 4 | 6 | |
| library_annotation_db | 18 | |||
| library_detail | 1 | 7 | ||
| library_shortname_abbreviation | 1 | 28 | stores known abbreviations for the shortnames of genomic libraries | |
| qc_report | 1 | 613,716 | ||
| query_source_type | 1 | 1 | ||
| read_class | 57 | |||
| sequencing_primer | 2 | 6 |