SchemaSpy Analysis of scope - Constraints Generated by
SchemaSpy
64 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column
aerospaci_ibfk_1 aerospaci.pdb_entry_id pdb_entry.id
aerospaci_ibfk_2 aerospaci.release_id scop_release.id
astral_chain_ibfk_1 astral_chain.raf_id raf.id
astral_chain_ibfk_2 astral_chain.source_id astral_seq_source.id
astral_chain_link_domain_ibfk_1 astral_chain_link_domain.chain_id astral_chain.id
astral_chain_link_domain_ibfk_2 astral_chain_link_domain.domain_id astral_domain.id
astral_chain_subset_id_ibfk_1 astral_chain_subset_id.release_id scop_release.id
astral_chain_subset_id_ibfk_2 astral_chain_subset_id.astral_chain_id astral_chain.id
astral_domain_ibfk_1 astral_domain.node_id scop_node.id
astral_domain_ibfk_2 astral_domain.source_id astral_seq_source.id
astral_domain_ibfk_3 astral_domain.style_id astral_seq_style.id
astral_domain_subset_blast_e_ibfk_1 astral_domain_subset_blast_e.release_id scop_release.id
astral_domain_subset_blast_e_ibfk_2 astral_domain_subset_blast_e.style_id astral_seq_style.id
astral_domain_subset_blast_e_ibfk_3 astral_domain_subset_blast_e.astral_domain_id astral_domain.id
astral_domain_subset_id_ibfk_1 astral_domain_subset_id.release_id scop_release.id
astral_domain_subset_id_ibfk_2 astral_domain_subset_id.style_id astral_seq_style.id
astral_domain_subset_id_ibfk_3 astral_domain_subset_id.astral_domain_id astral_domain.id
link_pdb_ibfk_1 link_pdb.node_id scop_node.id
link_pdb_ibfk_2 link_pdb.pdb_chain_id pdb_chain.id
link_pfam_ibfk_1 link_pfam.node_id scop_node.id
link_species_ibfk_1 link_species.node_id scop_node.id
link_species_ibfk_2 link_species.species_id species.id
link_uniprot_ibfk_1 link_uniprot.node_id scop_node.id
pdb_chain_compound_ibfk_1 pdb_chain_compound.pdb_chain_id pdb_chain.id
pdb_chain_compound_ibfk_2 pdb_chain_compound.pdb_compound_id pdb_compound.id
pdb_chain_gene_ibfk_1 pdb_chain_gene.pdb_chain_id pdb_chain.id
pdb_chain_gene_ibfk_2 pdb_chain_gene.pdb_gene_id pdb_gene.id
pdb_chain_ibfk_1 pdb_chain.pdb_release_id pdb_release.id
pdb_chain_source_ibfk_1 pdb_chain_source.pdb_chain_id pdb_chain.id
pdb_chain_source_ibfk_2 pdb_chain_source.pdb_source_id pdb_source.id
pdb_entry_ibfk_1 pdb_entry.obsoleted_by pdb_entry.id
pdb_headers_ibfk_1 pdb_headers.pdb_release_id pdb_release.id
pdb_local_ibfk_1 pdb_local.pdb_release_id pdb_release.id
pdb_release_heterogen_ibfk_1 pdb_release_heterogen.pdb_release_id pdb_release.id
pdb_release_heterogen_ibfk_2 pdb_release_heterogen.pdb_heterogen_id pdb_heterogen.id
pdb_release_ibfk_1 pdb_release.pdb_entry_id pdb_entry.id
pdb_release_ibfk_2 pdb_release.replaced_by pdb_release.id
pdb_release_ibfk_3 pdb_release.method_id pdb_method.id
pdb_source_species_ibfk_1 pdb_source_species.pdb_source_id pdb_source.id
pdb_source_species_ibfk_2 pdb_source_species.species_id species.id
raf_ibfk_1 raf.raf_version_id raf_version.id
raf_ibfk_2 raf.pdb_chain_id pdb_chain.id
raf_ibfk_3 raf.first_release_id scop_release.id
raf_ibfk_4 raf.last_release_id scop_release.id
scop_comment_ibfk_1 scop_comment.node_id scop_node.id
scop_history_ibfk_1 scop_history.old_node_id scop_node.id
scop_history_ibfk_2 scop_history.new_node_id scop_node.id
scop_history_ibfk_3 scop_history.release_id scop_release.id
scop_history_ibfk_4 scop_history.change_type_id scop_history_type.id
scop_node_ibfk_1 scop_node.level_id scop_level.id
scop_node_ibfk_2 scop_node.release_id scop_release.id
scop_node_ibfk_3 scop_node.parent_node_id scop_node.id
scop_node_pdbstyle_ibfk_1 scop_node_pdbstyle.node_id scop_node.id
scop_node_pdbstyle_ibfk_2 scop_node_pdbstyle.last_update_id scop_release.id
scop_node_thumbnail_ibfk_1 scop_node_thumbnail.node_id scop_node.id
scop_node_thumbnail_ibfk_2 scop_node_thumbnail.main thumbnail.id
scop_node_thumbnail_ibfk_3 scop_node_thumbnail.domain_small thumbnail.id
scop_node_thumbnail_ibfk_4 scop_node_thumbnail.chain_small thumbnail.id
scop_node_thumbnail_ibfk_5 scop_node_thumbnail.structure_small thumbnail.id
scop_node_thumbnail_ibfk_6 scop_node_thumbnail.domain_large thumbnail.id
scop_node_thumbnail_ibfk_7 scop_node_thumbnail.chain_large thumbnail.id
scop_node_thumbnail_ibfk_8 scop_node_thumbnail.structure_large thumbnail.id
scop_subset_level_ibfk_1 scop_subset_level.rep_node_id scop_node.id
scop_subset_level_ibfk_2 scop_subset_level.level_node_id scop_node.id

Check Constraints:

Table Constraint Name Constraint
None detected