Schema Version: 1.3 Module: chado

Constraints

17 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

organism_pub_pub_id_fkey

organism_pub.pub_id

pub.pub_id

Cascade on delete

organism_pub_organism_id_fkey

organism_pub.organism_id

organism.organism_id

Cascade on delete

organism_cvtermprop_type_id_fkey

organism_cvtermprop.type_id

cvterm.cvterm_id

Cascade on delete

organism_cvtermprop_organism_cvterm_id_fkey

organism_cvtermprop.organism_cvterm_id

organism_cvterm.organism_cvterm_id

Cascade on delete

organism_dbxref_dbxref_id_fkey

organism_dbxref.dbxref_id

dbxref.dbxref_id

Cascade on delete

organism_dbxref_organism_id_fkey

organism_dbxref.organism_id

organism.organism_id

Cascade on delete

organism_cvterm_cvterm_id_fkey

organism_cvterm.cvterm_id

cvterm.cvterm_id

Cascade on delete

organism_cvterm_pub_id_fkey

organism_cvterm.pub_id

pub.pub_id

Cascade on delete

organism_cvterm_organism_id_fkey

organism_cvterm.organism_id

organism.organism_id

Cascade on delete

organismprop_pub_organismprop_id_fkey

organismprop_pub.organismprop_id

organismprop.organismprop_id

Cascade on delete

organismprop_pub_pub_id_fkey

organismprop_pub.pub_id

pub.pub_id

Cascade on delete

organismprop_organism_id_fkey

organismprop.organism_id

organism.organism_id

Cascade on delete

organismprop_type_id_fkey

organismprop.type_id

cvterm.cvterm_id

Cascade on delete

organism_type_id_fkey

organism.type_id

cvterm.cvterm_id

Cascade on delete

organism_relationship_subject_id_fkey

organism_relationship.subject_id

organism.organism_id

Cascade on delete

organism_relationship_type_id_fkey

organism_relationship.type_id

cvterm.cvterm_id

Cascade on delete

organism_relationship_object_id_fkey

organism_relationship.object_id

organism.organism_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
None detected