Schema Version: 1.3 Module: chado

Constraints

22 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

cvterm_dbxref_cvterm_id_fkey

cvterm_dbxref.cvterm_id

cvterm.cvterm_id

Cascade on delete

cvterm_dbxref_dbxref_id_fkey

cvterm_dbxref.dbxref_id

dbxref.dbxref_id

Cascade on delete

dbprop_db_id_fkey

dbprop.db_id

db.db_id

Cascade on delete

dbprop_type_id_fkey

dbprop.type_id

cvterm.cvterm_id

Cascade on delete

cvprop_type_id_fkey

cvprop.type_id

cvterm.cvterm_id

Restrict delete

cvprop_cv_id_fkey

cvprop.cv_id

cv.cv_id

Restrict delete

chadoprop_type_id_fkey

chadoprop.type_id

cvterm.cvterm_id

Restrict delete

cvtermpath_cv_id_fkey

cvtermpath.cv_id

cv.cv_id

Cascade on delete

cvtermpath_type_id_fkey

cvtermpath.type_id

cvterm.cvterm_id

Null on delete

cvtermpath_object_id_fkey

cvtermpath.object_id

cvterm.cvterm_id

Cascade on delete

cvtermpath_subject_id_fkey

cvtermpath.subject_id

cvterm.cvterm_id

Cascade on delete

cvtermprop_cvterm_id_fkey

cvtermprop.cvterm_id

cvterm.cvterm_id

Cascade on delete

cvtermprop_type_id_fkey

cvtermprop.type_id

cvterm.cvterm_id

Cascade on delete

cvtermsynonym_type_id_fkey

cvtermsynonym.type_id

cvterm.cvterm_id

Cascade on delete

cvtermsynonym_cvterm_id_fkey

cvtermsynonym.cvterm_id

cvterm.cvterm_id

Cascade on delete

dbxrefprop_dbxref_id_fkey

dbxrefprop.dbxref_id

dbxref.dbxref_id

Restrict delete

dbxrefprop_type_id_fkey

dbxrefprop.type_id

cvterm.cvterm_id

Restrict delete

cvterm_dbxref_id_fkey

cvterm.dbxref_id

dbxref.dbxref_id

Null on delete

cvterm_cv_id_fkey

cvterm.cv_id

cv.cv_id

Cascade on delete

cvterm_relationship_type_id_fkey

cvterm_relationship.type_id

cvterm.cvterm_id

Cascade on delete

cvterm_relationship_object_id_fkey

cvterm_relationship.object_id

cvterm.cvterm_id

Cascade on delete

cvterm_relationship_subject_id_fkey

cvterm_relationship.subject_id

cvterm.cvterm_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
None detected