| SchemaSpy Analysis of scope | Generated by SchemaSpy |
| Generated by SchemaSpy on Sun Feb 26 23:56 EST 2012 | |
| Database Type: MySQL - 5.1.58-1 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
42 Tables:
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| aerospaci | 2 | 19 | 380,186 | AEROSPACI all data | |
| astral_chain | 2 | 2 | 6 | 1,480,959 | ASTRAL chain sequence |
| astral_chain_link_domain | 2 | 2 | 170,825 | Links between ASTRAL chains and domains | |
| astral_chain_subset_id | 2 | 3 | 346,953 | PDB representative chains selected by %ID | |
| astral_domain | 3 | 3 | 8 | 2,222,200 | ASTRAL domain sequence |
| astral_domain_subset_blast_e | 3 | 4 | 700,767 | SCOP representative domains selected by BLAST E-value | |
| astral_domain_subset_id | 3 | 4 | 1,337,441 | SCOP representative domains selected by %ID | |
| astral_seq_source | 2 | 2 | 3 | ASTRAL sequence source (i.e., atom or seqres) | |
| astral_seq_style | 3 | 2 | 4 | ASTRAL sequence style (e.g., genetic domain) | |
| link_pdb | 2 | 2 | 822,285 | Link to parent PDB chain | |
| link_pfam | 1 | 2 | 2,911 | Link to Pfam | |
| link_species | 2 | 2 | 118,408 | Link to species data | |
| link_uniprot | 1 | 2 | 12,413 | Link to Uniprot | |
| pdb_chain | 5 | 1 | 4 | 593,409 | PDB chain |
| pdb_chain_compound | 2 | 2 | 126,832 | links between PDB compounds and chains | |
| pdb_chain_gene | 2 | 2 | 139,936 | links between PDB sources (genes) and chains | |
| pdb_chain_source | 2 | 2 | 299,997 | links between PDB sources (species) and chains | |
| pdb_compound | 1 | 2 | 23,196 | PDB compounds | |
| pdb_entry | 3 | 1 | 8 | 81,962 | PDB entries and literature references |
| pdb_gene | 1 | 2 | 18,663 | PDB sources (genes) | |
| pdb_headers | 1 | 5 | 51,252 | PDB headers | |
| pdb_heterogen | 1 | 2 | 9,406 | PDB heterogens | |
| pdb_local | 1 | 5 | 224,757 | Info about local copy of PDB | |
| pdb_method | 1 | 5 | 189 | PDB experimental methods | |
| pdb_release | 5 | 3 | 18 | 284,502 | PDB entry releases |
| pdb_release_heterogen | 2 | 2 | 117,472 | links between PDB heterogens and releases | |
| pdb_source | 2 | 6 | 15,680 | PDB sources (species) | |
| pdb_source_species | 2 | 2 | 5,149 | PDB sources mapped to SCOP species | |
| raf | 1 | 4 | 6 | 794,057 | RAF maps |
| raf_version | 1 | 3 | 2 | RAF version | |
| scop_comment | 1 | 4 | 504,868 | SCOP comments | |
| scop_history | 4 | 5 | 21,320 | SCOP history | |
| scop_history_type | 1 | 3 | 11 | Types of SCOP history changes | |
| scop_index | 2 | 173,154 | SCOP index | ||
| scop_level | 1 | 7 | 8 | SCOP level | |
| scop_node | 13 | 3 | 8 | 1,107,925 | SCOP node |
| scop_node_pdbstyle | 2 | 3 | 669,272 | Links to ASTRAL PDB-style files | |
| scop_node_thumbnail | 8 | 8 | 175,226 | Links to thumbnail images | |
| scop_release | 9 | 6 | 12 | SCOP versions | |
| scop_subset_level | 2 | 2 | 110,919 | SCOP representative domains from each level | |
| species | 2 | 5 | 3,567 | SCOP species | |
| thumbnail | 7 | 4 | 670,133 | Thumbnail images |
Columns: 191 Rows: 13,818,231