Schema Version: 1.3 Module: chado

Constraints

10 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

feature_phenotype_feature_id_fkey

feature_phenotype.feature_id

feature.feature_id

Cascade on delete

feature_phenotype_phenotype_id_fkey

feature_phenotype.phenotype_id

phenotype.phenotype_id

Cascade on delete

phenotypeprop_phenotype_id_fkey

phenotypeprop.phenotype_id

phenotype.phenotype_id

Cascade on delete

phenotypeprop_type_id_fkey

phenotypeprop.type_id

cvterm.cvterm_id

Cascade on delete

phenotype_observable_id_fkey

phenotype.observable_id

cvterm.cvterm_id

Cascade on delete

phenotype_cvalue_id_fkey

phenotype.cvalue_id

cvterm.cvterm_id

Null on delete

phenotype_attr_id_fkey

phenotype.attr_id

cvterm.cvterm_id

Null on delete

phenotype_assay_id_fkey

phenotype.assay_id

cvterm.cvterm_id

Null on delete

phenotype_cvterm_phenotype_id_fkey

phenotype_cvterm.phenotype_id

phenotype.phenotype_id

Cascade on delete

phenotype_cvterm_cvterm_id_fkey

phenotype_cvterm.cvterm_id

cvterm.cvterm_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
None detected