Schema Version: 1.3 Module: chado

Constraints

23 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

phylonodeprop_type_id_fkey

phylonodeprop.type_id

cvterm.cvterm_id

Cascade on delete

phylonodeprop_phylonode_id_fkey

phylonodeprop.phylonode_id

phylonode.phylonode_id

Cascade on delete

phylotree_analysis_id_fkey

phylotree.analysis_id

analysis.analysis_id

Cascade on delete

phylotree_dbxref_id_fkey

phylotree.dbxref_id

dbxref.dbxref_id

Cascade on delete

phylotree_type_id_fkey

phylotree.type_id

cvterm.cvterm_id

Cascade on delete

phylonode_pub_phylonode_id_fkey

phylonode_pub.phylonode_id

phylonode.phylonode_id

Cascade on delete

phylonode_pub_pub_id_fkey

phylonode_pub.pub_id

pub.pub_id

Cascade on delete

phylonode_relationship_type_id_fkey

phylonode_relationship.type_id

cvterm.cvterm_id

Cascade on delete

phylonode_relationship_phylotree_id_fkey

phylonode_relationship.phylotree_id

phylotree.phylotree_id

Cascade on delete

phylonode_relationship_object_id_fkey

phylonode_relationship.object_id

phylonode.phylonode_id

Cascade on delete

phylonode_relationship_subject_id_fkey

phylonode_relationship.subject_id

phylonode.phylonode_id

Cascade on delete

phylonode_phylotree_id_fkey

phylonode.phylotree_id

phylotree.phylotree_id

Cascade on delete

phylonode_feature_id_fkey

phylonode.feature_id

feature.feature_id

Cascade on delete

phylonode_parent_phylonode_id_fkey

phylonode.parent_phylonode_id

phylonode.phylonode_id

Cascade on delete

phylonode_type_id_fkey

phylonode.type_id

cvterm.cvterm_id

Cascade on delete

phylonode_dbxref_phylonode_id_fkey

phylonode_dbxref.phylonode_id

phylonode.phylonode_id

Cascade on delete

phylonode_dbxref_dbxref_id_fkey

phylonode_dbxref.dbxref_id

dbxref.dbxref_id

Cascade on delete

phylonode_organism_phylonode_id_fkey

phylonode_organism.phylonode_id

phylonode.phylonode_id

Cascade on delete

phylonode_organism_organism_id_fkey

phylonode_organism.organism_id

organism.organism_id

Cascade on delete

phylotreeprop_phylotree_id_fkey

phylotreeprop.phylotree_id

phylotree.phylotree_id

Cascade on delete

phylotreeprop_type_id_fkey

phylotreeprop.type_id

cvterm.cvterm_id

Cascade on delete

phylotree_pub_phylotree_id_fkey

phylotree_pub.phylotree_id

phylotree.phylotree_id

Cascade on delete

phylotree_pub_pub_id_fkey

phylotree_pub.pub_id

pub.pub_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
None detected