Schema Version: 1.3 Module: chado

Constraints

29 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
environment_cvterm_cvterm_id_fkey
environment_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
environment_cvterm_environment_id_fkey
environment_cvterm.environment_id
environment.environment_id
Cascade on delete
phenstatement_genotype_id_fkey
phenstatement.genotype_id
genotype.genotype_id
Cascade on delete
phenstatement_type_id_fkey
phenstatement.type_id
cvterm.cvterm_id
Cascade on delete
phenstatement_environment_id_fkey
phenstatement.environment_id
environment.environment_id
Cascade on delete
phenstatement_phenotype_id_fkey
phenstatement.phenotype_id
phenotype.phenotype_id
Cascade on delete
phenstatement_pub_id_fkey
phenstatement.pub_id
pub.pub_id
Cascade on delete
phenotype_comparison_cvterm_pub_id_fkey
phenotype_comparison_cvterm.pub_id
pub.pub_id
Cascade on delete
phenotype_comparison_cvterm_cvterm_id_fkey
phenotype_comparison_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
phenotype_comparison_cvterm_phenotype_comparison_id_fkey
phenotype_comparison_cvterm.phenotype_comparison_id
phenotype_comparison.phenotype_comparison_id
Cascade on delete
genotype_type_id_fkey
genotype.type_id
cvterm.cvterm_id
Cascade on delete
phenotype_comparison_genotype1_id_fkey
phenotype_comparison.genotype1_id
genotype.genotype_id
Cascade on delete
phenotype_comparison_phenotype1_id_fkey
phenotype_comparison.phenotype1_id
phenotype.phenotype_id
Cascade on delete
phenotype_comparison_genotype2_id_fkey
phenotype_comparison.genotype2_id
genotype.genotype_id
Cascade on delete
phenotype_comparison_environment1_id_fkey
phenotype_comparison.environment1_id
environment.environment_id
Cascade on delete
phenotype_comparison_pub_id_fkey
phenotype_comparison.pub_id
pub.pub_id
Cascade on delete
phenotype_comparison_environment2_id_fkey
phenotype_comparison.environment2_id
environment.environment_id
Cascade on delete
phenotype_comparison_organism_id_fkey
phenotype_comparison.organism_id
organism.organism_id
Cascade on delete
phenotype_comparison_phenotype2_id_fkey
phenotype_comparison.phenotype2_id
phenotype.phenotype_id
Cascade on delete
genotypeprop_genotype_id_fkey
genotypeprop.genotype_id
genotype.genotype_id
Cascade on delete
genotypeprop_type_id_fkey
genotypeprop.type_id
cvterm.cvterm_id
Cascade on delete
phendesc_pub_id_fkey
phendesc.pub_id
pub.pub_id
Cascade on delete
phendesc_environment_id_fkey
phendesc.environment_id
environment.environment_id
Cascade on delete
phendesc_genotype_id_fkey
phendesc.genotype_id
genotype.genotype_id
Cascade on delete
phendesc_type_id_fkey
phendesc.type_id
cvterm.cvterm_id
Cascade on delete
feature_genotype_genotype_id_fkey
feature_genotype.genotype_id
genotype.genotype_id
Cascade on delete
feature_genotype_chromosome_id_fkey
feature_genotype.chromosome_id
feature.feature_id
Null on delete
feature_genotype_cvterm_id_fkey
feature_genotype.cvterm_id
cvterm.cvterm_id
Cascade on delete
feature_genotype_feature_id_fkey
feature_genotype.feature_id
feature.feature_id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
None detected