258 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| analysisfeature_analysis_id_fkey |
|
|
Cascade on delete | ||
| analysisfeature_feature_id_fkey |
|
|
Cascade on delete | ||
| analysisprop_analysis_id_fkey |
|
|
Cascade on delete | ||
| analysisprop_type_id_fkey |
|
|
Cascade on delete | ||
| blastwatch_queries_sp_person_id_fkey |
|
|
Cascade on delete | ||
| blastwatch_results_blastwatch_queries_id_fkey |
|
|
Cascade on delete | ||
| bug_created_by_fkey |
|
|
Restrict delete | ||
| bug_sp_person_id_fkey |
|
|
Restrict delete | ||
| bug_updated_by_fkey |
|
|
Restrict delete | ||
| contact_relationship_object_id_fkey |
|
|
Cascade on delete | ||
| contact_relationship_subject_id_fkey |
|
|
Cascade on delete | ||
| contact_relationship_type_id_fkey |
|
|
Cascade on delete | ||
| contact_type_id_fkey |
|
|
Restrict delete | ||
| cvprop_cv_id_fkey |
|
|
Restrict delete | ||
| cvprop_type_id_fkey |
|
|
Restrict delete | ||
| cvterm_cv_id_fkey |
|
|
Cascade on delete | ||
| cvterm_dbxref_cvterm_id_fkey |
|
|
Cascade on delete | ||
| cvterm_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| cvterm_dbxref_id_fkey |
|
|
Null on delete | ||
| cvterm_relationship_object_id_fkey |
|
|
Cascade on delete | ||
| cvterm_relationship_subject_id_fkey |
|
|
Cascade on delete | ||
| cvterm_relationship_type_id_fkey |
|
|
Cascade on delete | ||
| cvtermpath_cv_id_fkey |
|
|
Cascade on delete | ||
| cvtermpath_object_id_fkey |
|
|
Cascade on delete | ||
| cvtermpath_subject_id_fkey |
|
|
Cascade on delete | ||
| cvtermpath_type_id_fkey |
|
|
Null on delete | ||
| cvtermprop_cvterm_id_fkey |
|
|
Cascade on delete | ||
| cvtermprop_type_id_fkey |
|
|
Cascade on delete | ||
| cvtermsynonym_cvterm_id_fkey |
|
|
Cascade on delete | ||
| cvtermsynonym_type_id_fkey |
|
|
Cascade on delete | ||
| dbxref_db_id_fkey |
|
|
Cascade on delete | ||
| dbxrefprop_dbxref_id_fkey |
|
|
Restrict delete | ||
| dbxrefprop_type_id_fkey |
|
|
Restrict delete | ||
| environment_cvterm_cvterm_id_fkey |
|
|
Cascade on delete | ||
| environment_cvterm_environment_id_fkey |
|
|
Cascade on delete | ||
| enzyme_restriction_sites_enzyme_id_fkey |
|
|
Restrict delete | ||
| feature_cvterm_cvterm_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_dbxref_feature_cvterm_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_feature_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_pub_feature_cvterm_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_pub_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| feature_cvtermprop_feature_cvterm_id_fkey |
|
|
Cascade on delete | ||
| feature_cvtermprop_type_id_fkey |
|
|
Cascade on delete | ||
| feature_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| feature_dbxref_feature_id_fkey |
|
|
Cascade on delete | ||
| feature_dbxref_id_fkey |
|
|
Null on delete | ||
| feature_genotype_chromosome_id_fkey |
|
|
Null on delete | ||
| feature_genotype_cvterm_id_fkey |
|
|
Cascade on delete |
Processing...
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| featureloc | featureloc_c2 | ((fmin <= fmax)) |
| fpc_band | bandcheck | (((band_position IS NULL) OR (band_position > 0))) |
| fpc_band | datacheck | (((fragment_size IS NOT NULL) OR (band_position IS NOT NULL))) |
| fpc_band | fragcheck | (((fragment_size IS NULL) OR (fragment_size > 0))) |
Processing...