Schema Version: 1.3 Module: chado

Constraints

41 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
featureloc_feature_id_fkey
featureloc.feature_id
feature.feature_id
Cascade on delete
featureloc_srcfeature_id_fkey
featureloc.srcfeature_id
feature.feature_id
Null on delete
feature_pubprop_type_id_fkey
feature_pubprop.type_id
cvterm.cvterm_id
Cascade on delete
feature_pubprop_feature_pub_id_fkey
feature_pubprop.feature_pub_id
feature_pub.feature_pub_id
Cascade on delete
feature_cvterm_pub_pub_id_fkey
feature_cvterm_pub.pub_id
pub.pub_id
Cascade on delete
feature_cvterm_pub_feature_cvterm_id_fkey
feature_cvterm_pub.feature_cvterm_id
feature_cvterm.feature_cvterm_id
Cascade on delete
feature_cvterm_pub_id_fkey
feature_cvterm.pub_id
pub.pub_id
Cascade on delete
feature_cvterm_cvterm_id_fkey
feature_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
feature_cvterm_feature_id_fkey
feature_cvterm.feature_id
feature.feature_id
Cascade on delete
featureprop_pub_pub_id_fkey
featureprop_pub.pub_id
pub.pub_id
Cascade on delete
featureprop_pub_featureprop_id_fkey
featureprop_pub.featureprop_id
featureprop.featureprop_id
Cascade on delete
feature_cvtermprop_feature_cvterm_id_fkey
feature_cvtermprop.feature_cvterm_id
feature_cvterm.feature_cvterm_id
Cascade on delete
feature_cvtermprop_type_id_fkey
feature_cvtermprop.type_id
cvterm.cvterm_id
Cascade on delete
feature_cvterm_dbxref_dbxref_id_fkey
feature_cvterm_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
feature_cvterm_dbxref_feature_cvterm_id_fkey
feature_cvterm_dbxref.feature_cvterm_id
feature_cvterm.feature_cvterm_id
Cascade on delete
synonym_type_id_fkey
synonym.type_id
cvterm.cvterm_id
Cascade on delete
featureprop_feature_id_fkey
featureprop.feature_id
feature.feature_id
Cascade on delete
featureprop_type_id_fkey
featureprop.type_id
cvterm.cvterm_id
Cascade on delete
feature_synonym_synonym_id_fkey
feature_synonym.synonym_id
synonym.synonym_id
Cascade on delete
feature_synonym_pub_id_fkey
feature_synonym.pub_id
pub.pub_id
Cascade on delete
feature_synonym_feature_id_fkey
feature_synonym.feature_id
feature.feature_id
Cascade on delete
feature_relationship_subject_id_fkey
feature_relationship.subject_id
feature.feature_id
Cascade on delete
feature_relationship_type_id_fkey
feature_relationship.type_id
cvterm.cvterm_id
Cascade on delete
feature_relationship_object_id_fkey
feature_relationship.object_id
feature.feature_id
Cascade on delete
featureloc_pub_pub_id_fkey
featureloc_pub.pub_id
pub.pub_id
Cascade on delete
featureloc_pub_featureloc_id_fkey
featureloc_pub.featureloc_id
featureloc.featureloc_id
Cascade on delete
feature_dbxref_id_fkey
feature.dbxref_id
dbxref.dbxref_id
Null on delete
feature_type_id_fkey
feature.type_id
cvterm.cvterm_id
Cascade on delete
feature_organism_id_fkey
feature.organism_id
organism.organism_id
Cascade on delete
feature_contact_feature_id_fkey
feature_contact.feature_id
feature.feature_id
Cascade on delete
feature_contact_contact_id_fkey
feature_contact.contact_id
contact.contact_id
Cascade on delete
feature_pub_pub_id_fkey
feature_pub.pub_id
pub.pub_id
Cascade on delete
feature_pub_feature_id_fkey
feature_pub.feature_id
feature.feature_id
Cascade on delete
feature_dbxref_dbxref_id_fkey
feature_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
feature_dbxref_feature_id_fkey
feature_dbxref.feature_id
feature.feature_id
Cascade on delete
feature_relationshipprop_pub_feature_relationshipprop_id_fkey
feature_relationshipprop_pub.feature_relationshipprop_id
feature_relationshipprop.feature_relationshipprop_id
Cascade on delete
feature_relationshipprop_pub_pub_id_fkey
feature_relationshipprop_pub.pub_id
pub.pub_id
Cascade on delete
feature_relationshipprop_feature_relationship_id_fkey
feature_relationshipprop.feature_relationship_id
feature_relationship.feature_relationship_id
Cascade on delete
feature_relationshipprop_type_id_fkey
feature_relationshipprop.type_id
cvterm.cvterm_id
Cascade on delete
feature_relationship_pub_feature_relationship_id_fkey
feature_relationship_pub.feature_relationship_id
feature_relationship.feature_relationship_id
Cascade on delete
feature_relationship_pub_pub_id_fkey
feature_relationship_pub.pub_id
pub.pub_id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
None detected