Schema Version: 1.3 Module: chado

Constraints

91 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
protocolparam_protocol_id_fkey
protocolparam.protocol_id
protocol.protocol_id
Cascade on delete
protocolparam_datatype_id_fkey
protocolparam.datatype_id
cvterm.cvterm_id
Null on delete
protocolparam_unittype_id_fkey
protocolparam.unittype_id
cvterm.cvterm_id
Null on delete
assayprop_type_id_fkey
assayprop.type_id
cvterm.cvterm_id
Cascade on delete
assayprop_assay_id_fkey
assayprop.assay_id
assay.assay_id
Cascade on delete
arraydesign_dbxref_id_fkey
arraydesign.dbxref_id
dbxref.dbxref_id
Null on delete
arraydesign_platformtype_id_fkey
arraydesign.platformtype_id
cvterm.cvterm_id
Cascade on delete
arraydesign_protocol_id_fkey
arraydesign.protocol_id
protocol.protocol_id
Null on delete
arraydesign_substratetype_id_fkey
arraydesign.substratetype_id
cvterm.cvterm_id
Null on delete
arraydesign_manufacturer_id_fkey
arraydesign.manufacturer_id
contact.contact_id
Cascade on delete
studyfactor_studydesign_id_fkey
studyfactor.studydesign_id
studydesign.studydesign_id
Cascade on delete
studyfactor_type_id_fkey
studyfactor.type_id
cvterm.cvterm_id
Null on delete
acquisition_channel_id_fkey
acquisition.channel_id
channel.channel_id
Null on delete
acquisition_assay_id_fkey
acquisition.assay_id
assay.assay_id
Cascade on delete
acquisition_protocol_id_fkey
acquisition.protocol_id
protocol.protocol_id
Null on delete
treatment_protocol_id_fkey
treatment.protocol_id
protocol.protocol_id
Null on delete
treatment_biomaterial_id_fkey
treatment.biomaterial_id
biomaterial.biomaterial_id
Cascade on delete
treatment_type_id_fkey
treatment.type_id
cvterm.cvterm_id
Cascade on delete
element_relationship_type_id_fkey
element_relationship.type_id
cvterm.cvterm_id
Restrict delete
element_relationship_object_id_fkey
element_relationship.object_id
element.element_id
Restrict delete
element_relationship_subject_id_fkey
element_relationship.subject_id
element.element_id
Restrict delete
elementresult_relationship_object_id_fkey
elementresult_relationship.object_id
elementresult.elementresult_id
Restrict delete
elementresult_relationship_subject_id_fkey
elementresult_relationship.subject_id
elementresult.elementresult_id
Restrict delete
elementresult_relationship_type_id_fkey
elementresult_relationship.type_id
cvterm.cvterm_id
Restrict delete
assay_project_project_id_fkey
assay_project.project_id
project.project_id
Restrict delete
assay_project_assay_id_fkey
assay_project.assay_id
assay.assay_id
Restrict delete
biomaterial_treatment_unittype_id_fkey
biomaterial_treatment.unittype_id
cvterm.cvterm_id
Null on delete
biomaterial_treatment_treatment_id_fkey
biomaterial_treatment.treatment_id
treatment.treatment_id
Cascade on delete
biomaterial_treatment_biomaterial_id_fkey
biomaterial_treatment.biomaterial_id
biomaterial.biomaterial_id
Cascade on delete
study_contact_id_fkey
study.contact_id
contact.contact_id
Cascade on delete
study_pub_id_fkey
study.pub_id
pub.pub_id
Null on delete
study_dbxref_id_fkey
study.dbxref_id
dbxref.dbxref_id
Null on delete
arraydesignprop_type_id_fkey
arraydesignprop.type_id
cvterm.cvterm_id
Cascade on delete
arraydesignprop_arraydesign_id_fkey
arraydesignprop.arraydesign_id
arraydesign.arraydesign_id
Cascade on delete
studyfactorvalue_studyfactor_id_fkey
studyfactorvalue.studyfactor_id
studyfactor.studyfactor_id
Cascade on delete
studyfactorvalue_assay_id_fkey
studyfactorvalue.assay_id
assay.assay_id
Cascade on delete
studyprop_study_id_fkey
studyprop.study_id
study.study_id
Cascade on delete
studyprop_type_id_fkey
studyprop.type_id
cvterm.cvterm_id
Cascade on delete
acquisitionprop_type_id_fkey
acquisitionprop.type_id
cvterm.cvterm_id
Cascade on delete
acquisitionprop_acquisition_id_fkey
acquisitionprop.acquisition_id
acquisition.acquisition_id
Cascade on delete
studydesignprop_studydesign_id_fkey
studydesignprop.studydesign_id
studydesign.studydesign_id
Cascade on delete
studydesignprop_type_id_fkey
studydesignprop.type_id
cvterm.cvterm_id
Cascade on delete
quantificationprop_type_id_fkey
quantificationprop.type_id
cvterm.cvterm_id
Cascade on delete
quantificationprop_quantification_id_fkey
quantificationprop.quantification_id
quantification.quantification_id
Cascade on delete
biomaterialprop_type_id_fkey
biomaterialprop.type_id
cvterm.cvterm_id
Cascade on delete
biomaterialprop_biomaterial_id_fkey
biomaterialprop.biomaterial_id
biomaterial.biomaterial_id
Cascade on delete
assay_arraydesign_id_fkey
assay.arraydesign_id
arraydesign.arraydesign_id
Cascade on delete
assay_protocol_id_fkey
assay.protocol_id
protocol.protocol_id
Null on delete
assay_operator_id_fkey
assay.operator_id
contact.contact_id
Cascade on delete
assay_dbxref_id_fkey
assay.dbxref_id
dbxref.dbxref_id
Null on delete
biomaterial_dbxref_biomaterial_id_fkey
biomaterial_dbxref.biomaterial_id
biomaterial.biomaterial_id
Cascade on delete
biomaterial_dbxref_dbxref_id_fkey
biomaterial_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
quantification_operator_id_fkey
quantification.operator_id
contact.contact_id
Null on delete
quantification_acquisition_id_fkey
quantification.acquisition_id
acquisition.acquisition_id
Cascade on delete
quantification_analysis_id_fkey
quantification.analysis_id
analysis.analysis_id
Cascade on delete
quantification_protocol_id_fkey
quantification.protocol_id
protocol.protocol_id
Null on delete
protocol_dbxref_id_fkey
protocol.dbxref_id
dbxref.dbxref_id
Null on delete
protocol_pub_id_fkey
protocol.pub_id
pub.pub_id
Null on delete
protocol_type_id_fkey
protocol.type_id
cvterm.cvterm_id
Cascade on delete
studydesign_study_id_fkey
studydesign.study_id
study.study_id
Cascade on delete
study_assay_study_id_fkey
study_assay.study_id
study.study_id
Cascade on delete
study_assay_assay_id_fkey
study_assay.assay_id
assay.assay_id
Cascade on delete
quantification_relationship_object_id_fkey
quantification_relationship.object_id
quantification.quantification_id
Cascade on delete
quantification_relationship_type_id_fkey
quantification_relationship.type_id
cvterm.cvterm_id
Cascade on delete
quantification_relationship_subject_id_fkey
quantification_relationship.subject_id
quantification.quantification_id
Cascade on delete
assay_biomaterial_assay_id_fkey
assay_biomaterial.assay_id
assay.assay_id
Cascade on delete
assay_biomaterial_biomaterial_id_fkey
assay_biomaterial.biomaterial_id
biomaterial.biomaterial_id
Cascade on delete
assay_biomaterial_channel_id_fkey
assay_biomaterial.channel_id
channel.channel_id
Null on delete
biomaterial_dbxref_id_fkey
biomaterial.dbxref_id
dbxref.dbxref_id
Null on delete
biomaterial_biosourceprovider_id_fkey
biomaterial.biosourceprovider_id
contact.contact_id
Null on delete
biomaterial_taxon_id_fkey
biomaterial.taxon_id
organism.organism_id
Null on delete
acquisition_relationship_object_id_fkey
acquisition_relationship.object_id
acquisition.acquisition_id
Cascade on delete
acquisition_relationship_type_id_fkey
acquisition_relationship.type_id
cvterm.cvterm_id
Cascade on delete
acquisition_relationship_subject_id_fkey
acquisition_relationship.subject_id
acquisition.acquisition_id
Cascade on delete
element_type_id_fkey
element.type_id
cvterm.cvterm_id
Null on delete
element_dbxref_id_fkey
element.dbxref_id
dbxref.dbxref_id
Null on delete
element_arraydesign_id_fkey
element.arraydesign_id
arraydesign.arraydesign_id
Cascade on delete
element_feature_id_fkey
element.feature_id
feature.feature_id
Null on delete
studyprop_feature_type_id_fkey
studyprop_feature.type_id
cvterm.cvterm_id
Cascade on delete
studyprop_feature_studyprop_id_fkey
studyprop_feature.studyprop_id
studyprop.studyprop_id
Cascade on delete
studyprop_feature_feature_id_fkey
studyprop_feature.feature_id
feature.feature_id
Cascade on delete
magedocumentation_tableinfo_id_fkey
magedocumentation.tableinfo_id
tableinfo.tableinfo_id
Cascade on delete
magedocumentation_mageml_id_fkey
magedocumentation.mageml_id
mageml.mageml_id
Cascade on delete
elementresult_quantification_id_fkey
elementresult.quantification_id
quantification.quantification_id
Cascade on delete
elementresult_element_id_fkey
elementresult.element_id
element.element_id
Cascade on delete
biomaterial_relationship_type_id_fkey
biomaterial_relationship.type_id
cvterm.cvterm_id
Restrict delete
biomaterial_relationship_object_id_fkey
biomaterial_relationship.object_id
biomaterial.biomaterial_id
Restrict delete
biomaterial_relationship_subject_id_fkey
biomaterial_relationship.subject_id
biomaterial.biomaterial_id
Restrict delete
control_tableinfo_id_fkey
control.tableinfo_id
tableinfo.tableinfo_id
Cascade on delete
control_type_id_fkey
control.type_id
cvterm.cvterm_id
Cascade on delete
control_assay_id_fkey
control.assay_id
assay.assay_id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
None detected