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