258 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| nd_experiment_protocol_nd_protocol_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_protocol_nd_experiment_id_fkey |
|
|
Cascade on delete | ||
| phenotypeprop_phenotype_id_fkey |
|
|
Cascade on delete | ||
| phenotypeprop_type_id_fkey |
|
|
Cascade on delete | ||
| pubprop_type_id_fkey |
|
|
Cascade on delete | ||
| pubprop_pub_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_dbxref_feature_cvterm_id_fkey |
|
|
Cascade on delete | ||
| nd_experimentprop_type_id_fkey |
|
|
Cascade on delete | ||
| nd_experimentprop_nd_experiment_id_fkey |
|
|
Cascade on delete | ||
| environment_cvterm_cvterm_id_fkey |
|
|
Cascade on delete | ||
| environment_cvterm_environment_id_fkey |
|
|
Cascade on delete | ||
| unigene_signalp_cds_id_fkey |
|
|
Restrict delete | ||
| unigene_signalp_unigene_id_fkey |
|
|
Restrict delete | ||
| feature_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| feature_pub_feature_id_fkey |
|
|
Cascade on delete | ||
| unigene_relations_superceded_by_fkey |
|
|
Restrict delete | ||
| unigene_relations_unigene_id_fkey |
|
|
Restrict delete | ||
| feature_relationship_pub_feature_relationship_id_fkey |
|
|
Cascade on delete | ||
| feature_relationship_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| stock_cvterm_pub_id_fkey |
|
|
Cascade on delete | ||
| stock_cvterm_stock_id_fkey |
|
|
Cascade on delete | ||
| stock_cvterm_cvterm_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_pub_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_cvterm_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_feature_id_fkey |
|
|
Cascade on delete | ||
| organismprop_organism_id_fkey |
|
|
Cascade on delete | ||
| organismprop_type_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_stock_nd_experiment_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_stock_type_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_stock_stock_id_fkey |
|
|
Cascade on delete | ||
| organism_relationship_subject_id_fkey |
|
|
Restrict delete | ||
| organism_relationship_type_id_fkey |
|
|
Restrict delete | ||
| organism_relationship_object_id_fkey |
|
|
Restrict delete | ||
| synonym_type_id_fkey |
|
|
Cascade on delete | ||
| nd_geolocation_dbxref_nd_geolocation_id_fkey |
|
|
Cascade on delete | ||
| nd_geolocation_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| cvtermprop_cvterm_id_fkey |
|
|
Cascade on delete | ||
| cvtermprop_type_id_fkey |
|
|
Cascade on delete | ||
| fpc_build_fpc_fingerprint_fpc_build_id_fkey |
|
|
Cascade on delete | ||
| fpc_build_fpc_fingerprint_fpc_fingerprint_id_fkey |
|
|
Cascade on delete | ||
| phylonode_organism_phylonode_id_fkey |
|
|
Cascade on delete | ||
| phylonode_organism_organism_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_phenotype_nd_experiment_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_phenotype_phenotype_id_fkey |
|
|
Cascade on delete | ||
| nd_protocol_reagent_reagent_id_fkey |
|
|
Cascade on delete | ||
| nd_protocol_reagent_type_id_fkey |
|
|
Cascade on delete | ||
| nd_protocol_reagent_nd_protocol_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_contact_nd_experiment_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_contact_contact_id_fkey |
|
|
Cascade on delete | ||
| nd_protocol_type_id_fkey |
|
|
Cascade on delete | ||
| dbxref_db_id_fkey |
|
|
Cascade on delete | ||
| stock_cvtermprop_type_id_fkey |
|
|
Cascade on delete | ||
| stock_cvtermprop_stock_cvterm_id_fkey |
|
|
Cascade on delete | ||
| stock_type_id_fkey |
|
|
Cascade on delete | ||
| stock_dbxref_id_fkey |
|
|
Null on delete | ||
| stock_organism_id_fkey |
|
|
Cascade on delete | ||
| bug_updated_by_fkey |
|
|
Restrict delete | ||
| bug_created_by_fkey |
|
|
Restrict delete | ||
| bug_sp_person_id_fkey |
|
|
Restrict delete | ||
| project_relationship_type_id_fkey |
|
|
Restrict delete | ||
| project_relationship_object_project_id_fkey |
|
|
Cascade on delete | ||
| project_relationship_subject_project_id_fkey |
|
|
Cascade on delete | ||
| blastwatch_queries_sp_person_id_fkey |
|
|
Cascade on delete | ||
| phenotype_comparison_genotype1_id_fkey |
|
|
Cascade on delete | ||
| phenotype_comparison_phenotype1_id_fkey |
|
|
Cascade on delete | ||
| phenotype_comparison_genotype2_id_fkey |
|
|
Cascade on delete | ||
| phenotype_comparison_environment1_id_fkey |
|
|
Cascade on delete | ||
| phenotype_comparison_pub_id_fkey |
|
|
Cascade on delete | ||
| phenotype_comparison_environment2_id_fkey |
|
|
Cascade on delete | ||
| phenotype_comparison_organism_id_fkey |
|
|
Cascade on delete | ||
| phenotype_comparison_phenotype2_id_fkey |
|
|
Cascade on delete | ||
| phylonode_phylotree_id_fkey |
|
|
Cascade on delete | ||
| phylonode_feature_id_fkey |
|
|
Cascade on delete | ||
| phylonode_parent_phylonode_id_fkey |
|
|
Cascade on delete | ||
| phylonode_type_id_fkey |
|
|
Cascade on delete | ||
| nd_reagent_type_id_fkey |
|
|
Cascade on delete | ||
| cvprop_type_id_fkey |
|
|
Restrict delete | ||
| cvprop_cv_id_fkey |
|
|
Restrict delete | ||
| featureloc_feature_id_fkey |
|
|
Cascade on delete | ||
| featureloc_srcfeature_id_fkey |
|
|
Null on delete | ||
| cvterm_dbxref_id_fkey |
|
|
Null on delete | ||
| cvterm_cv_id_fkey |
|
|
Cascade on delete | ||
| phenotype_observable_id_fkey |
|
|
Cascade on delete | ||
| phenotype_individual_id_fkey |
|
|
Cascade on delete | ||
| phenotype_cvalue_id_fkey |
|
|
Null on delete | ||
| phenotype_attr_id_fkey |
|
|
Null on delete | ||
| phenotype_assay_id_fkey |
|
|
Null on delete | ||
| phenotype_sp_person_id_fkey |
|
|
Null on delete | ||
| contact_relationship_object_id_fkey |
|
|
Cascade on delete | ||
| contact_relationship_type_id_fkey |
|
|
Cascade on delete | ||
| contact_relationship_subject_id_fkey |
|
|
Cascade on delete | ||
| phenotype_cvterm_phenotype_id_fkey |
|
|
Cascade on delete | ||
| phenotype_cvterm_cvterm_id_fkey |
|
|
Cascade on delete | ||
| featureprop_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| featureprop_pub_featureprop_id_fkey |
|
|
Cascade on delete | ||
| stock_dbxref_stock_id_fkey |
|
|
Cascade on delete | ||
| stock_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| cvtermpath_cv_id_fkey |
|
|
Cascade on delete | ||
| cvtermpath_type_id_fkey |
|
|
Null on delete | ||
| cvtermpath_object_id_fkey |
|
|
Cascade on delete | ||
| cvtermpath_subject_id_fkey |
|
|
Cascade on delete | ||
| project_contact_contact_id_fkey |
|
|
Cascade on delete | ||
| project_contact_project_id_fkey |
|
|
Cascade on delete | ||
| phenstatement_genotype_id_fkey |
|
|
Cascade on delete | ||
| phenstatement_type_id_fkey |
|
|
Cascade on delete | ||
| phenstatement_environment_id_fkey |
|
|
Cascade on delete | ||
| phenstatement_phenotype_id_fkey |
|
|
Cascade on delete | ||
| phenstatement_pub_id_fkey |
|
|
Cascade on delete | ||
| unigene_dbxref_dbxref_id_fkey |
|
|
Restrict delete | ||
| unigene_dbxref_unigene_id_fkey |
|
|
Restrict delete | ||
| fpc_build_fpc_series_id_fkey |
|
|
Restrict delete | ||
| genotypeprop_genotype_id_fkey |
|
|
Cascade on delete | ||
| genotypeprop_type_id_fkey |
|
|
Cascade on delete | ||
| dbxrefprop_dbxref_id_fkey |
|
|
Restrict delete | ||
| dbxrefprop_type_id_fkey |
|
|
Restrict delete | ||
| stock_relationship_subject_id_fkey |
|
|
Cascade on delete | ||
| stock_relationship_object_id_fkey |
|
|
Cascade on delete | ||
| stock_relationship_type_id_fkey |
|
|
Cascade on delete | ||
| feature_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| feature_dbxref_feature_id_fkey |
|
|
Cascade on delete | ||
| contact_type_id_fkey |
|
|
Restrict delete | ||
| blastwatch_results_blastwatch_queries_id_fkey |
|
|
Cascade on delete | ||
| projectprop_type_id_fkey |
|
|
Cascade on delete | ||
| projectprop_project_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| feature_cvterm_pub_feature_cvterm_id_fkey |
|
|
Cascade on delete | ||
| fkey_dbxref_id |
|
|
Cascade on delete | ||
| fkey_project_id |
|
|
Cascade on delete | ||
| pubabstract_pub_id_fkey |
|
|
Cascade on delete | ||
| phenotype_comparison_cvterm_pub_id_fkey |
|
|
Cascade on delete | ||
| phenotype_comparison_cvterm_cvterm_id_fkey |
|
|
Cascade on delete | ||
| phenotype_comparison_cvterm_phenotype_comparison_id_fkey |
|
|
Cascade on delete | ||
| feature_relationship_subject_id_fkey |
|
|
Cascade on delete | ||
| feature_relationship_type_id_fkey |
|
|
Cascade on delete | ||
| feature_relationship_object_id_fkey |
|
|
Cascade on delete | ||
| phylonode_relationship_type_id_fkey |
|
|
Cascade on delete | ||
| phylonode_relationship_phylotree_id_fkey |
|
|
Cascade on delete | ||
| phylonode_relationship_object_id_fkey |
|
|
Cascade on delete | ||
| phylonode_relationship_subject_id_fkey |
|
|
Cascade on delete | ||
| pub_relationship_object_id_fkey |
|
|
Cascade on delete | ||
| pub_relationship_subject_id_fkey |
|
|
Cascade on delete | ||
| pub_relationship_type_id_fkey |
|
|
Cascade on delete | ||
| stock_genotype_stock_id_fkey |
|
|
Cascade on delete | ||
| stock_genotype_genotype_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_project_nd_experiment_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_project_project_id_fkey |
|
|
Cascade on delete | ||
| feature_relationshipprop_feature_relationship_id_fkey |
|
|
Cascade on delete | ||
| feature_relationshipprop_type_id_fkey |
|
|
Cascade on delete | ||
| stock_dbxrefprop_stock_dbxref_id_fkey |
|
|
Cascade on delete | ||
| stock_dbxrefprop_type_id_fkey |
|
|
Cascade on delete | ||
| stockcollection_stock_stock_id_fkey |
|
|
Cascade on delete | ||
| stockcollection_stock_stockcollection_id_fkey |
|
|
Cascade on delete | ||
| project_type_id_fkey |
|
|
Null on delete | ||
| stock_relationship_cvterm_stock_relationship_id_fkey |
|
|
Cascade on delete | ||
| stock_relationship_cvterm_cvterm_id_fkey |
|
|
Restrict delete | ||
| stock_relationship_cvterm_pub_id_fkey |
|
|
Restrict delete | ||
| organism_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| organism_dbxref_organism_id_fkey |
|
|
Cascade on delete | ||
| phylotree_analysis_id_fkey |
|
|
Cascade on delete | ||
| phylotree_dbxref_id_fkey |
|
|
Cascade on delete | ||
| phylotree_type_id_fkey |
|
|
Cascade on delete | ||
| feature_synonym_synonym_id_fkey |
|
|
Cascade on delete | ||
| feature_synonym_pub_id_fkey |
|
|
Cascade on delete | ||
| feature_synonym_feature_id_fkey |
|
|
Cascade on delete | ||
| nd_geolocationprop_nd_geolocation_id_fkey |
|
|
Cascade on delete | ||
| nd_geolocationprop_type_id_fkey |
|
|
Cascade on delete | ||
| featureloc_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| featureloc_pub_featureloc_id_fkey |
|
|
Cascade on delete | ||
| feature_dbxref_id_fkey |
|
|
Null on delete | ||
| feature_type_id_fkey |
|
|
Cascade on delete | ||
| feature_organism_id_fkey |
|
|
Cascade on delete | ||
| stock_relationship_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| stock_relationship_pub_stock_relationship_id_fkey |
|
|
Cascade on delete | ||
| fpc_contig_fpc_build_id_fkey |
|
|
Cascade on delete | ||
| cvterm_dbxref_cvterm_id_fkey |
|
|
Cascade on delete | ||
| cvterm_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| phylonode_pub_phylonode_id_fkey |
|
|
Cascade on delete | ||
| phylonode_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| genotype_type_id_fkey |
|
|
Cascade on delete | ||
| pub_dbxref_pub_id_fkey |
|
|
Cascade on delete | ||
| pub_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| fpc_band_fpc_fingerprint_id_fkey |
|
|
Cascade on delete | ||
| phylonode_dbxref_phylonode_id_fkey |
|
|
Cascade on delete | ||
| phylonode_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| analysisprop_type_id_fkey |
|
|
Cascade on delete | ||
| analysisprop_analysis_id_fkey |
|
|
Cascade on delete | ||
| feature_cvtermprop_feature_cvterm_id_fkey |
|
|
Cascade on delete | ||
| feature_cvtermprop_type_id_fkey |
|
|
Cascade on delete | ||
| nd_protocolprop_nd_protocol_id_fkey |
|
|
Cascade on delete | ||
| nd_protocolprop_type_id_fkey |
|
|
Cascade on delete | ||
| nd_reagent_relationship_type_id_fkey |
|
|
Cascade on delete | ||
| nd_reagent_relationship_subject_reagent_id_fkey |
|
|
Cascade on delete | ||
| nd_reagent_relationship_object_reagent_id_fkey |
|
|
Cascade on delete | ||
| organism_sgn_organism_id_fkey |
|
|
Restrict delete | ||
| phylotree_pub_phylotree_id_fkey |
|
|
Cascade on delete | ||
| phylotree_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| featureprop_feature_id_fkey |
|
|
Cascade on delete | ||
| featureprop_type_id_fkey |
|
|
Cascade on delete | ||
| fpc_contig_clone_fpc_contig_id_fkey |
|
|
Cascade on delete | ||
| fpc_contig_clone_clone_id_fkey |
|
|
Restrict delete | ||
| nd_experiment_stock_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_stock_dbxref_nd_experiment_stock_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_genotype_nd_experiment_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_genotype_genotype_id_fkey |
|
|
Cascade on delete | ||
| stock_pub_stock_id_fkey |
|
|
Cascade on delete | ||
| stock_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_pub_nd_experiment_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| pub_type_id_fkey |
|
|
Cascade on delete | ||
| cvterm_relationship_type_id_fkey |
|
|
Cascade on delete | ||
| cvterm_relationship_object_id_fkey |
|
|
Cascade on delete | ||
| cvterm_relationship_subject_id_fkey |
|
|
Cascade on delete | ||
| stockcollectionprop_stockcollection_id_fkey |
|
|
Cascade on delete | ||
| stockcollectionprop_type_id_fkey |
|
|
Restrict delete | ||
| nd_experiment_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_dbxref_nd_experiment_id_fkey |
|
|
Cascade on delete | ||
| stockcollection_type_id_fkey |
|
|
Cascade on delete | ||
| stockcollection_contact_id_fkey |
|
|
Null on delete | ||
| featureprop_json_nd_protocol_id_fkey |
|
|
Restrict delete | ||
| featureprop_json_feature_id_fkey |
|
|
Restrict delete | ||
| featureprop_json_type_id_fkey |
|
|
Restrict delete | ||
| stockprop_stock_id_fkey |
|
|
Cascade on delete | ||
| stockprop_type_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_nd_geolocation_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_type_id_fkey |
|
|
Cascade on delete | ||
| pubauthor_pub_id_fkey |
|
|
Cascade on delete | ||
| analysisfeature_analysis_id_fkey |
|
|
Cascade on delete | ||
| analysisfeature_feature_id_fkey |
|
|
Cascade on delete | ||
| stockprop_pub_stockprop_id_fkey |
|
|
Cascade on delete | ||
| stockprop_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| fpc_fingerprint_enzyme_id_fkey |
|
|
Restrict delete | ||
| fpc_fingerprint_clone_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_stockprop_type_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_stockprop_nd_experiment_stock_id_fkey |
|
|
Cascade on delete | ||
| organismpath_object_id_fkey |
|
|
Restrict delete | ||
| organismpath_type_id_fkey |
|
|
Restrict delete | ||
| organismpath_subject_id_fkey |
|
|
Restrict delete | ||
| phylonodeprop_type_id_fkey |
|
|
Cascade on delete | ||
| phylonodeprop_phylonode_id_fkey |
|
|
Cascade on delete | ||
| cvtermsynonym_type_id_fkey |
|
|
Cascade on delete | ||
| cvtermsynonym_cvterm_id_fkey |
|
|
Cascade on delete | ||
| project_pub_project_id_fkey |
|
|
Cascade on delete | ||
| project_pub_pub_id_fkey |
|
|
Cascade on delete | ||
| nd_reagentprop_nd_reagent_id_fkey |
|
|
Cascade on delete | ||
| nd_reagentprop_type_id_fkey |
|
|
Cascade on delete | ||
| tmp_cds_handler_relationship_cds_row_id_fkey |
|
|
Cascade on delete | ||
| phendesc_pub_id_fkey |
|
|
Cascade on delete | ||
| phendesc_environment_id_fkey |
|
|
Cascade on delete | ||
| phendesc_genotype_id_fkey |
|
|
Cascade on delete | ||
| phendesc_type_id_fkey |
|
|
Cascade on delete | ||
| feature_genotype_genotype_id_fkey |
|
|
Cascade on delete | ||
| feature_genotype_chromosome_id_fkey |
|
|
Null on delete | ||
| feature_genotype_cvterm_id_fkey |
|
|
Cascade on delete | ||
| feature_genotype_feature_id_fkey |
|
|
Cascade on delete | ||
| enzyme_restriction_sites_enzyme_id_fkey |
|
|
Restrict delete | ||
| feature_relationshipprop_pub_feature_relationshipprop_id_fkey |
|
|
Cascade on delete | ||
| feature_relationshipprop_pub_pub_id_fkey |
|
|
Cascade on delete |
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))) |