Schema Version: 1.3 Module: chado

Constraints

11 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

pubauthor_contact_contact_id_fkey

pubauthor_contact.contact_id

contact.contact_id

Cascade on delete

pubauthor_contact_pubauthor_id_fkey

pubauthor_contact.pubauthor_id

pubauthor.pubauthor_id

Cascade on delete

pub_dbxref_pub_id_fkey

pub_dbxref.pub_id

pub.pub_id

Cascade on delete

pub_dbxref_dbxref_id_fkey

pub_dbxref.dbxref_id

dbxref.dbxref_id

Cascade on delete

pubprop_type_id_fkey

pubprop.type_id

cvterm.cvterm_id

Cascade on delete

pubprop_pub_id_fkey

pubprop.pub_id

pub.pub_id

Cascade on delete

pubauthor_pub_id_fkey

pubauthor.pub_id

pub.pub_id

Cascade on delete

pub_relationship_object_id_fkey

pub_relationship.object_id

pub.pub_id

Cascade on delete

pub_relationship_subject_id_fkey

pub_relationship.subject_id

pub.pub_id

Cascade on delete

pub_relationship_type_id_fkey

pub_relationship.type_id

cvterm.cvterm_id

Cascade on delete

pub_type_id_fkey

pub.type_id

cvterm.cvterm_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
None detected