Schema Version: 1.3 Module: chado

Constraints

15 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

analysis_relationship_object_id_fkey

analysis_relationship.object_id

analysis.analysis_id

Cascade on delete

analysis_relationship_subject_id_fkey

analysis_relationship.subject_id

analysis.analysis_id

Cascade on delete

analysis_relationship_type_id_fkey

analysis_relationship.type_id

cvterm.cvterm_id

Cascade on delete

analysis_pub_analysis_id_fkey

analysis_pub.analysis_id

analysis.analysis_id

Cascade on delete

analysis_pub_pub_id_fkey

analysis_pub.pub_id

pub.pub_id

Cascade on delete

analysisprop_type_id_fkey

analysisprop.type_id

cvterm.cvterm_id

Cascade on delete

analysisprop_analysis_id_fkey

analysisprop.analysis_id

analysis.analysis_id

Cascade on delete

analysisfeature_analysis_id_fkey

analysisfeature.analysis_id

analysis.analysis_id

Cascade on delete

analysisfeature_feature_id_fkey

analysisfeature.feature_id

feature.feature_id

Cascade on delete

analysis_cvterm_cvterm_id_fkey

analysis_cvterm.cvterm_id

cvterm.cvterm_id

Cascade on delete

analysis_cvterm_analysis_id_fkey

analysis_cvterm.analysis_id

analysis.analysis_id

Cascade on delete

analysis_dbxref_dbxref_id_fkey

analysis_dbxref.dbxref_id

dbxref.dbxref_id

Cascade on delete

analysis_dbxref_analysis_id_fkey

analysis_dbxref.analysis_id

analysis.analysis_id

Cascade on delete

analysisfeatureprop_analysisfeature_id_fkey

analysisfeatureprop.analysisfeature_id

analysisfeature.analysisfeature_id

Cascade on delete

analysisfeatureprop_type_id_fkey

analysisfeatureprop.type_id

cvterm.cvterm_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
None detected