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))) |