Schema Version: 1.3 Module: chado

Constraints

32 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
library_synonym_synonym_id_fkey
library_synonym.synonym_id
synonym.synonym_id
Cascade on delete
library_synonym_pub_id_fkey
library_synonym.pub_id
pub.pub_id
Cascade on delete
library_synonym_library_id_fkey
library_synonym.library_id
library.library_id
Cascade on delete
library_featureprop_type_id_fkey
library_featureprop.type_id
cvterm.cvterm_id
Restrict delete
library_featureprop_library_feature_id_fkey
library_featureprop.library_feature_id
library_feature.library_feature_id
Cascade on delete
library_feature_feature_id_fkey
library_feature.feature_id
feature.feature_id
Cascade on delete
library_feature_library_id_fkey
library_feature.library_id
library.library_id
Cascade on delete
library_cvterm_pub_id_fkey
library_cvterm.pub_id
pub.pub_id
Restrict delete
library_cvterm_library_id_fkey
library_cvterm.library_id
library.library_id
Cascade on delete
library_cvterm_cvterm_id_fkey
library_cvterm.cvterm_id
cvterm.cvterm_id
Restrict delete
library_type_id_fkey
library.type_id
cvterm.cvterm_id
Restrict delete
library_organism_id_fkey
library.organism_id
organism.organism_id
Restrict delete
library_pub_library_id_fkey
library_pub.library_id
library.library_id
Cascade on delete
library_pub_pub_id_fkey
library_pub.pub_id
pub.pub_id
Cascade on delete
library_relationship_type_id_fkey
library_relationship.type_id
cvterm.cvterm_id
Restrict delete
library_relationship_subject_id_fkey
library_relationship.subject_id
library.library_id
Cascade on delete
library_relationship_object_id_fkey
library_relationship.object_id
library.library_id
Cascade on delete
library_expression_expression_id_fkey
library_expression.expression_id
expression.expression_id
Cascade on delete
library_expression_pub_id_fkey
library_expression.pub_id
pub.pub_id
Restrict delete
library_expression_library_id_fkey
library_expression.library_id
library.library_id
Cascade on delete
libraryprop_pub_pub_id_fkey
libraryprop_pub.pub_id
pub.pub_id
Cascade on delete
libraryprop_pub_libraryprop_id_fkey
libraryprop_pub.libraryprop_id
libraryprop.libraryprop_id
Cascade on delete
library_expressionprop_library_expression_id_fkey
library_expressionprop.library_expression_id
library_expression.library_expression_id
Cascade on delete
library_expressionprop_type_id_fkey
library_expressionprop.type_id
cvterm.cvterm_id
Restrict delete
libraryprop_library_id_fkey
libraryprop.library_id
library.library_id
Cascade on delete
libraryprop_type_id_fkey
libraryprop.type_id
cvterm.cvterm_id
Restrict delete
library_contact_contact_id_fkey
library_contact.contact_id
contact.contact_id
Cascade on delete
library_contact_library_id_fkey
library_contact.library_id
library.library_id
Cascade on delete
library_dbxref_library_id_fkey
library_dbxref.library_id
library.library_id
Cascade on delete
library_dbxref_dbxref_id_fkey
library_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
library_relationship_pub_library_relationship_id_fkey
library_relationship_pub.library_relationship_id
library_relationship.library_relationship_id
Cascade on delete
library_relationship_pub_pub_id_fkey
library_relationship_pub.pub_id
pub.pub_id
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected