Schema Version: 1.3 Module: chado

Constraints

44 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
stockcollectionprop_stockcollection_id_fkey
stockcollectionprop.stockcollection_id
stockcollection.stockcollection_id
Cascade on delete
stockcollectionprop_type_id_fkey
stockcollectionprop.type_id
cvterm.cvterm_id
Restrict delete
stockcollection_stock_stock_id_fkey
stockcollection_stock.stock_id
stock.stock_id
Cascade on delete
stockcollection_stock_stockcollection_id_fkey
stockcollection_stock.stockcollection_id
stockcollection.stockcollection_id
Cascade on delete
stockcollection_type_id_fkey
stockcollection.type_id
cvterm.cvterm_id
Cascade on delete
stockcollection_contact_id_fkey
stockcollection.contact_id
contact.contact_id
Null on delete
stockprop_stock_id_fkey
stockprop.stock_id
stock.stock_id
Cascade on delete
stockprop_type_id_fkey
stockprop.type_id
cvterm.cvterm_id
Cascade on delete
stock_relationship_cvterm_stock_relationship_id_fkey
stock_relationship_cvterm.stock_relationship_id
stock_relationship.stock_relationship_id
Cascade on delete
stock_relationship_cvterm_cvterm_id_fkey
stock_relationship_cvterm.cvterm_id
cvterm.cvterm_id
Restrict delete
stock_relationship_cvterm_pub_id_fkey
stock_relationship_cvterm.pub_id
pub.pub_id
Restrict delete
stockprop_pub_stockprop_id_fkey
stockprop_pub.stockprop_id
stockprop.stockprop_id
Cascade on delete
stockprop_pub_pub_id_fkey
stockprop_pub.pub_id
pub.pub_id
Cascade on delete
stock_cvtermprop_type_id_fkey
stock_cvtermprop.type_id
cvterm.cvterm_id
Cascade on delete
stock_cvtermprop_stock_cvterm_id_fkey
stock_cvtermprop.stock_cvterm_id
stock_cvterm.stock_cvterm_id
Cascade on delete
stock_type_id_fkey
stock.type_id
cvterm.cvterm_id
Cascade on delete
stock_dbxref_id_fkey
stock.dbxref_id
dbxref.dbxref_id
Null on delete
stock_organism_id_fkey
stock.organism_id
organism.organism_id
Cascade on delete
stock_featuremap_featuremap_id_fkey
stock_featuremap.featuremap_id
featuremap.featuremap_id
Cascade on delete
stock_featuremap_type_id_fkey
stock_featuremap.type_id
cvterm.cvterm_id
Cascade on delete
stock_featuremap_stock_id_fkey
stock_featuremap.stock_id
stock.stock_id
Cascade on delete
stock_dbxref_stock_id_fkey
stock_dbxref.stock_id
stock.stock_id
Cascade on delete
stock_dbxref_dbxref_id_fkey
stock_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
stock_library_library_id_fkey
stock_library.library_id
library.library_id
Cascade on delete
stock_library_stock_id_fkey
stock_library.stock_id
stock.stock_id
Cascade on delete
stock_pub_stock_id_fkey
stock_pub.stock_id
stock.stock_id
Cascade on delete
stock_pub_pub_id_fkey
stock_pub.pub_id
pub.pub_id
Cascade on delete
stock_feature_feature_id_fkey
stock_feature.feature_id
feature.feature_id
Cascade on delete
stock_feature_type_id_fkey
stock_feature.type_id
cvterm.cvterm_id
Cascade on delete
stock_feature_stock_id_fkey
stock_feature.stock_id
stock.stock_id
Cascade on delete
stockcollection_db_db_id_fkey
stockcollection_db.db_id
db.db_id
Cascade on delete
stockcollection_db_stockcollection_id_fkey
stockcollection_db.stockcollection_id
stockcollection.stockcollection_id
Cascade on delete
stock_relationship_subject_id_fkey
stock_relationship.subject_id
stock.stock_id
Cascade on delete
stock_relationship_object_id_fkey
stock_relationship.object_id
stock.stock_id
Cascade on delete
stock_relationship_type_id_fkey
stock_relationship.type_id
cvterm.cvterm_id
Cascade on delete
stock_genotype_stock_id_fkey
stock_genotype.stock_id
stock.stock_id
Cascade on delete
stock_genotype_genotype_id_fkey
stock_genotype.genotype_id
genotype.genotype_id
Cascade on delete
stock_cvterm_pub_id_fkey
stock_cvterm.pub_id
pub.pub_id
Cascade on delete
stock_cvterm_stock_id_fkey
stock_cvterm.stock_id
stock.stock_id
Cascade on delete
stock_cvterm_cvterm_id_fkey
stock_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
stock_relationship_pub_pub_id_fkey
stock_relationship_pub.pub_id
pub.pub_id
Cascade on delete
stock_relationship_pub_stock_relationship_id_fkey
stock_relationship_pub.stock_relationship_id
stock_relationship.stock_relationship_id
Cascade on delete
stock_dbxrefprop_stock_dbxref_id_fkey
stock_dbxrefprop.stock_dbxref_id
stock_dbxref.stock_dbxref_id
Cascade on delete
stock_dbxrefprop_type_id_fkey
stock_dbxrefprop.type_id
cvterm.cvterm_id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
None detected