Schema Version: 1.3 Module: chado

Constraints

17 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
project_contact_contact_id_fkey
project_contact.contact_id
contact.contact_id
Cascade on delete
project_contact_project_id_fkey
project_contact.project_id
project.project_id
Cascade on delete
project_feature_feature_id_fkey
project_feature.feature_id
feature.feature_id
Cascade on delete
project_feature_project_id_fkey
project_feature.project_id
project.project_id
Cascade on delete
project_relationship_type_id_fkey
project_relationship.type_id
cvterm.cvterm_id
Restrict delete
project_relationship_object_project_id_fkey
project_relationship.object_project_id
project.project_id
Cascade on delete
project_relationship_subject_project_id_fkey
project_relationship.subject_project_id
project.project_id
Cascade on delete
project_pub_project_id_fkey
project_pub.project_id
project.project_id
Cascade on delete
project_pub_pub_id_fkey
project_pub.pub_id
pub.pub_id
Cascade on delete
projectprop_type_id_fkey
projectprop.type_id
cvterm.cvterm_id
Cascade on delete
projectprop_project_id_fkey
projectprop.project_id
project.project_id
Cascade on delete
project_stock_project_id_fkey
project_stock.project_id
project.project_id
Cascade on delete
project_stock_stock_id_fkey
project_stock.stock_id
stock.stock_id
Cascade on delete
project_analysis_analysis_id_fkey
project_analysis.analysis_id
analysis.analysis_id
Cascade on delete
project_analysis_project_id_fkey
project_analysis.project_id
project.project_id
Cascade on delete
project_dbxref_dbxref_id_fkey
project_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
project_dbxref_project_id_fkey
project_dbxref.project_id
project.project_id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
None detected