SchemaSpy Analysis of scop - Constraints Generated by
SchemaSpy
94 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
aerospaci_ibfk_1 aerospaci.pdb_entry_id pdb_entry.id Restrict delete 
aerospaci_ibfk_2 aerospaci.release_id scop_release.id Restrict delete 
astral_chain_ibfk_1 astral_chain.raf_id raf.id Restrict delete 
astral_chain_ibfk_2 astral_chain.source_id astral_seq_source.id Restrict delete 
astral_chain_link_domain_ibfk_1 astral_chain_link_domain.chain_id astral_chain.id Cascade on delete 
astral_chain_link_domain_ibfk_2 astral_chain_link_domain.domain_id astral_domain.id Cascade on delete 
astral_chain_subset_id_ibfk_1 astral_chain_subset_id.release_id scop_release.id Cascade on delete 
astral_chain_subset_id_ibfk_2 astral_chain_subset_id.astral_chain_id astral_chain.id Cascade on delete 
astral_domain_ibfk_1 astral_domain.node_id scop_node.id Restrict delete 
astral_domain_ibfk_2 astral_domain.source_id astral_seq_source.id Restrict delete 
astral_domain_ibfk_3 astral_domain.style_id astral_seq_style.id Restrict delete 
astral_domain_subset_blast_e_ibfk_1 astral_domain_subset_blast_e.release_id scop_release.id Cascade on delete 
astral_domain_subset_blast_e_ibfk_2 astral_domain_subset_blast_e.style_id astral_seq_style.id Restrict delete 
astral_domain_subset_blast_e_ibfk_3 astral_domain_subset_blast_e.astral_domain_id astral_domain.id Cascade on delete 
astral_domain_subset_id_ibfk_1 astral_domain_subset_id.release_id scop_release.id Cascade on delete 
astral_domain_subset_id_ibfk_2 astral_domain_subset_id.style_id astral_seq_style.id Restrict delete 
astral_domain_subset_id_ibfk_3 astral_domain_subset_id.astral_domain_id astral_domain.id Cascade on delete 
astral_seq_blast_gap_ibfk_1 astral_seq_blast_gap.hit_id astral_seq_blast.id Cascade on delete 
astral_seq_blast_ibfk_1 astral_seq_blast.seq1_id astral_seq.id Cascade on delete 
astral_seq_blast_ibfk_2 astral_seq_blast.seq2_id astral_seq.id Cascade on delete 
astral_seq_blast_ibfk_3 astral_seq_blast.source_id astral_seq_source.id Restrict delete 
astral_seq_blast_ibfk_4 astral_seq_blast.style1_id astral_seq_style.id Restrict delete 
astral_seq_blast_ibfk_5 astral_seq_blast.style2_id astral_seq_style.id Restrict delete 
astral_seq_blast_ibfk_6 astral_seq_blast.release_id scop_release.id Restrict delete 
astral_seq_coils_ibfk_1 astral_seq_coils.seq_id astral_seq.id Cascade on delete 
astral_seq_hmm_pfam_gap_ibfk_1 astral_seq_hmm_pfam_gap.hit_id astral_seq_hmm_pfam.id Cascade on delete 
astral_seq_hmm_pfam_ibfk_1 astral_seq_hmm_pfam.seq_id astral_seq.id Cascade on delete 
astral_seq_hmm_pfam_ibfk_2 astral_seq_hmm_pfam.pfam_id pfam.id Cascade on delete 
fk_seq_id astral_chain.seq_id astral_seq.id Restrict delete 
fk_seq_id_2 astral_domain.seq_id astral_seq.id Restrict delete 
link_pdb_ibfk_1 link_pdb.node_id scop_node.id Restrict delete 
link_pdb_ibfk_2 link_pdb.pdb_chain_id pdb_chain.id Restrict delete 
link_pfam_ibfk_1 link_pfam.node_id scop_node.id Restrict delete 
link_pubmed_ibfk_1 link_pubmed.node_id scop_node.id Restrict delete 
link_species_ibfk_1 link_species.node_id scop_node.id Restrict delete 
link_species_ibfk_2 link_species.species_id species.id Restrict delete 
link_uniprot_ibfk_1 link_uniprot.node_id scop_node.id Restrict delete 
pdb_chain_compound_ibfk_1 pdb_chain_compound.pdb_chain_id pdb_chain.id Cascade on delete 
pdb_chain_compound_ibfk_2 pdb_chain_compound.pdb_compound_id pdb_compound.id Cascade on delete 
pdb_chain_dbref_ibfk_1 pdb_chain_dbref.pdb_chain_id pdb_chain.id Restrict delete 
pdb_chain_diff_ibfk_1 pdb_chain_diff.pdb_chain_id pdb_chain.id Restrict delete 
pdb_chain_diff_ibfk_2 pdb_chain_diff.pdb_chain_dbref_id pdb_chain_dbref.id Restrict delete 
pdb_chain_diff_ibfk_3 pdb_chain_diff.category_id pdb_chain_diff_category.id Restrict delete 
pdb_chain_gene_ibfk_1 pdb_chain_gene.pdb_chain_id pdb_chain.id Cascade on delete 
pdb_chain_gene_ibfk_2 pdb_chain_gene.pdb_gene_id pdb_gene.id Cascade on delete 
pdb_chain_ibfk_1 pdb_chain.pdb_release_id pdb_release.id Restrict delete 
pdb_chain_source_ibfk_1 pdb_chain_source.pdb_chain_id pdb_chain.id Cascade on delete 
pdb_chain_source_ibfk_2 pdb_chain_source.pdb_source_id pdb_source.id Cascade on delete 
pdb_chain_tag_ibfk_1 pdb_chain_tag.pdb_chain_id pdb_chain.id Restrict delete 
pdb_chain_tag_ibfk_2 pdb_chain_tag.pdb_chain_diff_id pdb_chain_diff.id Restrict delete 
pdb_chain_uniprot_ibfk_1 pdb_chain_uniprot.pdb_chain_id pdb_chain.id Cascade on delete 
pdb_entry_ibfk_1 pdb_entry.obsoleted_by pdb_entry.id Restrict delete 
pdb_headers_ibfk_1 pdb_headers.pdb_release_id pdb_release.id Restrict delete 
pdb_local_ibfk_1 pdb_local.pdb_release_id pdb_release.id Restrict delete 
pdb_model_ibfk_1 pdb_model.pdb_entry_id pdb_entry.id Cascade on delete 
pdb_release_heterogen_ibfk_1 pdb_release_heterogen.pdb_release_id pdb_release.id Cascade on delete 
pdb_release_heterogen_ibfk_2 pdb_release_heterogen.pdb_heterogen_id pdb_heterogen.id Cascade on delete 
pdb_release_ibfk_1 pdb_release.pdb_entry_id pdb_entry.id Restrict delete 
pdb_release_ibfk_2 pdb_release.replaced_by pdb_release.id Restrict delete 
pdb_release_ibfk_3 pdb_release.method_id pdb_method.id Restrict delete 
pdb_source_species_ibfk_1 pdb_source_species.pdb_source_id pdb_source.id Cascade on delete 
pdb_source_species_ibfk_2 pdb_source_species.species_id species.id Cascade on delete 
pfam_equiv_ibfk_1 pfam_equiv.old_pfam_id pfam.id Cascade on delete 
pfam_equiv_ibfk_2 pfam_equiv.new_pfam_id pfam.id Cascade on delete 
pfam_ibfk_1 pfam.release_id pfam_release.id Restrict delete 
pfam_ibfk_2 pfam.pfam_type_id pfam_type.id Restrict delete 
pfam_local_ibfk_1 pfam_local.release_id pfam_release.id Restrict delete 
pfam_release_ibfk_1 pfam_release.hmmer_release_id hmmer_release.id Restrict delete 
raf_ibfk_1 raf.raf_version_id raf_version.id Restrict delete 
raf_ibfk_2 raf.pdb_chain_id pdb_chain.id Restrict delete 
raf_ibfk_3 raf.first_release_id scop_release.id Restrict delete 
raf_ibfk_4 raf.last_release_id scop_release.id Restrict delete 
scop_comment_ibfk_1 scop_comment.node_id scop_node.id Restrict delete 
scop_history_ibfk_1 scop_history.old_node_id scop_node.id Restrict delete 
scop_history_ibfk_2 scop_history.new_node_id scop_node.id Restrict delete 
scop_history_ibfk_3 scop_history.release_id scop_release.id Restrict delete 
scop_history_ibfk_4 scop_history.change_type_id scop_history_type.id Restrict delete 
scop_node_ibfk_1 scop_node.level_id scop_level.id Restrict delete 
scop_node_ibfk_2 scop_node.release_id scop_release.id Restrict delete 
scop_node_ibfk_3 scop_node.parent_node_id scop_node.id Restrict delete 
scop_node_ibfk_4 scop_node.curation_type_id scop_curation_type.id Restrict delete 
scop_node_pdbstyle_ibfk_1 scop_node_pdbstyle.node_id scop_node.id Cascade on delete 
scop_node_pdbstyle_ibfk_2 scop_node_pdbstyle.last_update_id scop_release.id Cascade on delete 
scop_node_thumbnail_ibfk_1 scop_node_thumbnail.node_id scop_node.id Cascade on delete 
scop_node_thumbnail_ibfk_2 scop_node_thumbnail.main thumbnail.id Null on delete 
scop_node_thumbnail_ibfk_3 scop_node_thumbnail.domain_small thumbnail.id Null on delete 
scop_node_thumbnail_ibfk_4 scop_node_thumbnail.chain_small thumbnail.id Null on delete 
scop_node_thumbnail_ibfk_5 scop_node_thumbnail.structure_small thumbnail.id Null on delete 
scop_node_thumbnail_ibfk_6 scop_node_thumbnail.domain_large thumbnail.id Null on delete 
scop_node_thumbnail_ibfk_7 scop_node_thumbnail.chain_large thumbnail.id Null on delete 
scop_node_thumbnail_ibfk_8 scop_node_thumbnail.structure_large thumbnail.id Null on delete 
scop_node_thumbnail_ibfk_9 scop_node_thumbnail.domain_tiny thumbnail.id Null on delete 
scop_subset_level_ibfk_1 scop_subset_level.rep_node_id scop_node.id Cascade on delete 
scop_subset_level_ibfk_2 scop_subset_level.level_node_id scop_node.id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected