Schema Version: 1.3 Module: chado

Constraints

22 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
featurepos_feature_id_fkey
featurepos.feature_id
feature.feature_id
Cascade on delete
featurepos_featuremap_id_fkey
featurepos.featuremap_id
featuremap.featuremap_id
Cascade on delete
featurepos_map_feature_id_fkey
featurepos.map_feature_id
feature.feature_id
Cascade on delete
featuremap_contact_featuremap_id_fkey
featuremap_contact.featuremap_id
featuremap.featuremap_id
Cascade on delete
featuremap_contact_contact_id_fkey
featuremap_contact.contact_id
contact.contact_id
Cascade on delete
featurerange_rightstartf_id_fkey
featurerange.rightstartf_id
feature.feature_id
Null on delete
featurerange_featuremap_id_fkey
featurerange.featuremap_id
featuremap.featuremap_id
Cascade on delete
featurerange_leftendf_id_fkey
featurerange.leftendf_id
feature.feature_id
Null on delete
featurerange_rightendf_id_fkey
featurerange.rightendf_id
feature.feature_id
Cascade on delete
featurerange_feature_id_fkey
featurerange.feature_id
feature.feature_id
Cascade on delete
featurerange_leftstartf_id_fkey
featurerange.leftstartf_id
feature.feature_id
Cascade on delete
featureposprop_type_id_fkey
featureposprop.type_id
cvterm.cvterm_id
Cascade on delete
featureposprop_featurepos_id_fkey
featureposprop.featurepos_id
featurepos.featurepos_id
Cascade on delete
featuremap_dbxref_dbxref_id_fkey
featuremap_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
featuremap_dbxref_featuremap_id_fkey
featuremap_dbxref.featuremap_id
featuremap.featuremap_id
Cascade on delete
featuremap_unittype_id_fkey
featuremap.unittype_id
cvterm.cvterm_id
Null on delete
featuremap_organism_organism_id_fkey
featuremap_organism.organism_id
organism.organism_id
Cascade on delete
featuremap_organism_featuremap_id_fkey
featuremap_organism.featuremap_id
featuremap.featuremap_id
Cascade on delete
featuremapprop_featuremap_id_fkey
featuremapprop.featuremap_id
featuremap.featuremap_id
Cascade on delete
featuremapprop_type_id_fkey
featuremapprop.type_id
cvterm.cvterm_id
Cascade on delete
featuremap_pub_pub_id_fkey
featuremap_pub.pub_id
pub.pub_id
Cascade on delete
featuremap_pub_featuremap_id_fkey
featuremap_pub.featuremap_id
featuremap.featuremap_id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
None detected