Constraints

258 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
nd_experiment_protocol_nd_protocol_id_fkey
nd_experiment_protocol.nd_protocol_id
nd_protocol.nd_protocol_id
Cascade on delete
nd_experiment_protocol_nd_experiment_id_fkey
nd_experiment_protocol.nd_experiment_id
nd_experiment.nd_experiment_id
Cascade on delete
phenotypeprop_phenotype_id_fkey
phenotypeprop.phenotype_id
phenotype.phenotype_id
Cascade on delete
phenotypeprop_type_id_fkey
phenotypeprop.type_id
cvterm.cvterm_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
feature_cvterm_dbxref_dbxref_id_fkey
feature_cvterm_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
feature_cvterm_dbxref_feature_cvterm_id_fkey
feature_cvterm_dbxref.feature_cvterm_id
feature_cvterm.feature_cvterm_id
Cascade on delete
nd_experimentprop_type_id_fkey
nd_experimentprop.type_id
cvterm.cvterm_id
Cascade on delete
nd_experimentprop_nd_experiment_id_fkey
nd_experimentprop.nd_experiment_id
nd_experiment.nd_experiment_id
Cascade on delete
environment_cvterm_cvterm_id_fkey
environment_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
environment_cvterm_environment_id_fkey
environment_cvterm.environment_id
environment.environment_id
Cascade on delete
unigene_signalp_cds_id_fkey
unigene_signalp.cds_id
cds.cds_id
Restrict delete
unigene_signalp_unigene_id_fkey
unigene_signalp.unigene_id
unigene.unigene_id
Restrict delete
feature_pub_pub_id_fkey
feature_pub.pub_id
pub.pub_id
Cascade on delete
feature_pub_feature_id_fkey
feature_pub.feature_id
feature.feature_id
Cascade on delete
unigene_relations_superceded_by_fkey
unigene_relations.superceded_by
unigene.unigene_id
Restrict delete
unigene_relations_unigene_id_fkey
unigene_relations.unigene_id
unigene.unigene_id
Restrict delete
feature_relationship_pub_feature_relationship_id_fkey
feature_relationship_pub.feature_relationship_id
feature_relationship.feature_relationship_id
Cascade on delete
feature_relationship_pub_pub_id_fkey
feature_relationship_pub.pub_id
pub.pub_id
Cascade on delete
stock_cvterm_pub_id_fkey
stock_cvterm.pub_id
pub.pub_id
Cascade on delete
stock_cvterm_stock_id_fkey
stock_cvterm.stock_id
stock.stock_id
Cascade on delete
stock_cvterm_cvterm_id_fkey
stock_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
feature_cvterm_pub_id_fkey
feature_cvterm.pub_id
pub.pub_id
Cascade on delete
feature_cvterm_cvterm_id_fkey
feature_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
feature_cvterm_feature_id_fkey
feature_cvterm.feature_id
feature.feature_id
Cascade on delete
organismprop_organism_id_fkey
organismprop.organism_id
organism.organism_id
Cascade on delete
organismprop_type_id_fkey
organismprop.type_id
cvterm.cvterm_id
Cascade on delete
nd_experiment_stock_nd_experiment_id_fkey
nd_experiment_stock.nd_experiment_id
nd_experiment.nd_experiment_id
Cascade on delete
nd_experiment_stock_type_id_fkey
nd_experiment_stock.type_id
cvterm.cvterm_id
Cascade on delete
nd_experiment_stock_stock_id_fkey
nd_experiment_stock.stock_id
stock.stock_id
Cascade on delete
organism_relationship_subject_id_fkey
organism_relationship.subject_id
organism.organism_id
Restrict delete
organism_relationship_type_id_fkey
organism_relationship.type_id
cvterm.cvterm_id
Restrict delete
organism_relationship_object_id_fkey
organism_relationship.object_id
organism.organism_id
Restrict delete
synonym_type_id_fkey
synonym.type_id
cvterm.cvterm_id
Cascade on delete
nd_geolocation_dbxref_nd_geolocation_id_fkey
nd_geolocation_dbxref.nd_geolocation_id
nd_geolocation.nd_geolocation_id
Cascade on delete
nd_geolocation_dbxref_dbxref_id_fkey
nd_geolocation_dbxref.dbxref_id
dbxref.dbxref_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
fpc_build_fpc_fingerprint_fpc_build_id_fkey
fpc_build_fpc_fingerprint.fpc_build_id
fpc_build.fpc_build_id
Cascade on delete
fpc_build_fpc_fingerprint_fpc_fingerprint_id_fkey
fpc_build_fpc_fingerprint.fpc_fingerprint_id
fpc_fingerprint.fpc_fingerprint_id
Cascade on delete
phylonode_organism_phylonode_id_fkey
phylonode_organism.phylonode_id
phylonode.phylonode_id
Cascade on delete
phylonode_organism_organism_id_fkey
phylonode_organism.organism_id
organism.organism_id
Cascade on delete
nd_experiment_phenotype_nd_experiment_id_fkey
nd_experiment_phenotype.nd_experiment_id
nd_experiment.nd_experiment_id
Cascade on delete
nd_experiment_phenotype_phenotype_id_fkey
nd_experiment_phenotype.phenotype_id
phenotype.phenotype_id
Cascade on delete
nd_protocol_reagent_reagent_id_fkey
nd_protocol_reagent.reagent_id
nd_reagent.nd_reagent_id
Cascade on delete
nd_protocol_reagent_type_id_fkey
nd_protocol_reagent.type_id
cvterm.cvterm_id
Cascade on delete
nd_protocol_reagent_nd_protocol_id_fkey
nd_protocol_reagent.nd_protocol_id
nd_protocol.nd_protocol_id
Cascade on delete
nd_experiment_contact_nd_experiment_id_fkey
nd_experiment_contact.nd_experiment_id
nd_experiment.nd_experiment_id
Cascade on delete
nd_experiment_contact_contact_id_fkey
nd_experiment_contact.contact_id
contact.contact_id
Cascade on delete
nd_protocol_type_id_fkey
nd_protocol.type_id
cvterm.cvterm_id
Cascade on delete
dbxref_db_id_fkey
dbxref.db_id
db.db_id
Cascade on delete
stock_cvtermprop_type_id_fkey
stock_cvtermprop.type_id
cvterm.cvterm_id
Cascade on delete
stock_cvtermprop_stock_cvterm_id_fkey
stock_cvtermprop.stock_cvterm_id
stock_cvterm.stock_cvterm_id
Cascade on delete
stock_type_id_fkey
stock.type_id
cvterm.cvterm_id
Cascade on delete
stock_dbxref_id_fkey
stock.dbxref_id
dbxref.dbxref_id
Null on delete
stock_organism_id_fkey
stock.organism_id
organism.organism_id
Cascade on delete
bug_updated_by_fkey
bug.updated_by
sp_person.sp_person_id
Restrict delete
bug_created_by_fkey
bug.created_by
sp_person.sp_person_id
Restrict delete
bug_sp_person_id_fkey
bug.sp_person_id
sp_person.sp_person_id
Restrict delete
project_relationship_type_id_fkey
project_relationship.type_id
cvterm.cvterm_id
Restrict delete
project_relationship_object_project_id_fkey
project_relationship.object_project_id
project.project_id
Cascade on delete
project_relationship_subject_project_id_fkey
project_relationship.subject_project_id
project.project_id
Cascade on delete
blastwatch_queries_sp_person_id_fkey
blastwatch_queries.sp_person_id
sp_person.sp_person_id
Cascade on delete
phenotype_comparison_genotype1_id_fkey
phenotype_comparison.genotype1_id
genotype.genotype_id
Cascade on delete
phenotype_comparison_phenotype1_id_fkey
phenotype_comparison.phenotype1_id
phenotype.phenotype_id
Cascade on delete
phenotype_comparison_genotype2_id_fkey
phenotype_comparison.genotype2_id
genotype.genotype_id
Cascade on delete
phenotype_comparison_environment1_id_fkey
phenotype_comparison.environment1_id
environment.environment_id
Cascade on delete
phenotype_comparison_pub_id_fkey
phenotype_comparison.pub_id
pub.pub_id
Cascade on delete
phenotype_comparison_environment2_id_fkey
phenotype_comparison.environment2_id
environment.environment_id
Cascade on delete
phenotype_comparison_organism_id_fkey
phenotype_comparison.organism_id
organism.organism_id
Cascade on delete
phenotype_comparison_phenotype2_id_fkey
phenotype_comparison.phenotype2_id
phenotype.phenotype_id
Cascade on delete
phylonode_phylotree_id_fkey
phylonode.phylotree_id
phylotree.phylotree_id
Cascade on delete
phylonode_feature_id_fkey
phylonode.feature_id
feature.feature_id
Cascade on delete
phylonode_parent_phylonode_id_fkey
phylonode.parent_phylonode_id
phylonode.phylonode_id
Cascade on delete
phylonode_type_id_fkey
phylonode.type_id
cvterm.cvterm_id
Cascade on delete
nd_reagent_type_id_fkey
nd_reagent.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
featureloc_feature_id_fkey
featureloc.feature_id
feature.feature_id
Cascade on delete
featureloc_srcfeature_id_fkey
featureloc.srcfeature_id
feature.feature_id
Null on 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
phenotype_observable_id_fkey
phenotype.observable_id
cvterm.cvterm_id
Cascade on delete
phenotype_individual_id_fkey
phenotype.individual_id
individual.individual_id
Cascade on delete
phenotype_cvalue_id_fkey
phenotype.cvalue_id
cvterm.cvterm_id
Null on delete
phenotype_attr_id_fkey
phenotype.attr_id
cvterm.cvterm_id
Null on delete
phenotype_assay_id_fkey
phenotype.assay_id
cvterm.cvterm_id
Null on delete
phenotype_sp_person_id_fkey
phenotype.sp_person_id
sp_person.sp_person_id
Null on delete
contact_relationship_object_id_fkey
contact_relationship.object_id
contact.contact_id
Cascade on delete
contact_relationship_type_id_fkey
contact_relationship.type_id
cvterm.cvterm_id
Cascade on delete
contact_relationship_subject_id_fkey
contact_relationship.subject_id
contact.contact_id
Cascade on delete
phenotype_cvterm_phenotype_id_fkey
phenotype_cvterm.phenotype_id
phenotype.phenotype_id
Cascade on delete
phenotype_cvterm_cvterm_id_fkey
phenotype_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
featureprop_pub_pub_id_fkey
featureprop_pub.pub_id
pub.pub_id
Cascade on delete
featureprop_pub_featureprop_id_fkey
featureprop_pub.featureprop_id
featureprop.featureprop_id
Cascade on delete
stock_dbxref_stock_id_fkey
stock_dbxref.stock_id
stock.stock_id
Cascade on delete
stock_dbxref_dbxref_id_fkey
stock_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on 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
project_contact_contact_id_fkey
project_contact.contact_id
contact.contact_id
Cascade on delete
project_contact_project_id_fkey
project_contact.project_id
project.project_id
Cascade on delete
phenstatement_genotype_id_fkey
phenstatement.genotype_id
genotype.genotype_id
Cascade on delete
phenstatement_type_id_fkey
phenstatement.type_id
cvterm.cvterm_id
Cascade on delete
phenstatement_environment_id_fkey
phenstatement.environment_id
environment.environment_id
Cascade on delete
phenstatement_phenotype_id_fkey
phenstatement.phenotype_id
phenotype.phenotype_id
Cascade on delete
phenstatement_pub_id_fkey
phenstatement.pub_id
pub.pub_id
Cascade on delete
unigene_dbxref_dbxref_id_fkey
unigene_dbxref.dbxref_id
dbxref.dbxref_id
Restrict delete
unigene_dbxref_unigene_id_fkey
unigene_dbxref.unigene_id
unigene.unigene_id
Restrict delete
fpc_build_fpc_series_id_fkey
fpc_build.fpc_series_id
fpc_series.fpc_series_id
Restrict delete
genotypeprop_genotype_id_fkey
genotypeprop.genotype_id
genotype.genotype_id
Cascade on delete
genotypeprop_type_id_fkey
genotypeprop.type_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
stock_relationship_subject_id_fkey
stock_relationship.subject_id
stock.stock_id
Cascade on delete
stock_relationship_object_id_fkey
stock_relationship.object_id
stock.stock_id
Cascade on delete
stock_relationship_type_id_fkey
stock_relationship.type_id
cvterm.cvterm_id
Cascade on delete
feature_dbxref_dbxref_id_fkey
feature_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
feature_dbxref_feature_id_fkey
feature_dbxref.feature_id
feature.feature_id
Cascade on delete
contact_type_id_fkey
contact.type_id
cvterm.cvterm_id
Restrict delete
blastwatch_results_blastwatch_queries_id_fkey
blastwatch_results.blastwatch_queries_id
blastwatch_queries.blastwatch_queries_id
Cascade on delete
projectprop_type_id_fkey
projectprop.type_id
cvterm.cvterm_id
Cascade on delete
projectprop_project_id_fkey
projectprop.project_id
project.project_id
Cascade on delete
feature_cvterm_pub_pub_id_fkey
feature_cvterm_pub.pub_id
pub.pub_id
Cascade on delete
feature_cvterm_pub_feature_cvterm_id_fkey
feature_cvterm_pub.feature_cvterm_id
feature_cvterm.feature_cvterm_id
Cascade on delete
fkey_dbxref_id
project_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
fkey_project_id
project_dbxref.project_id
project.project_id
Cascade on delete
pubabstract_pub_id_fkey
pubabstract.pub_id
pub.pub_id
Cascade on delete
phenotype_comparison_cvterm_pub_id_fkey
phenotype_comparison_cvterm.pub_id
pub.pub_id
Cascade on delete
phenotype_comparison_cvterm_cvterm_id_fkey
phenotype_comparison_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
phenotype_comparison_cvterm_phenotype_comparison_id_fkey
phenotype_comparison_cvterm.phenotype_comparison_id
phenotype_comparison.phenotype_comparison_id
Cascade on delete
feature_relationship_subject_id_fkey
feature_relationship.subject_id
feature.feature_id
Cascade on delete
feature_relationship_type_id_fkey
feature_relationship.type_id
cvterm.cvterm_id
Cascade on delete
feature_relationship_object_id_fkey
feature_relationship.object_id
feature.feature_id
Cascade on delete
phylonode_relationship_type_id_fkey
phylonode_relationship.type_id
cvterm.cvterm_id
Cascade on delete
phylonode_relationship_phylotree_id_fkey
phylonode_relationship.phylotree_id
phylotree.phylotree_id
Cascade on delete
phylonode_relationship_object_id_fkey
phylonode_relationship.object_id
phylonode.phylonode_id
Cascade on delete
phylonode_relationship_subject_id_fkey
phylonode_relationship.subject_id
phylonode.phylonode_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
stock_genotype_stock_id_fkey
stock_genotype.stock_id
stock.stock_id
Cascade on delete
stock_genotype_genotype_id_fkey
stock_genotype.genotype_id
genotype.genotype_id
Cascade on delete
nd_experiment_project_nd_experiment_id_fkey
nd_experiment_project.nd_experiment_id
nd_experiment.nd_experiment_id
Cascade on delete
nd_experiment_project_project_id_fkey
nd_experiment_project.project_id
project.project_id
Cascade on delete
feature_relationshipprop_feature_relationship_id_fkey
feature_relationshipprop.feature_relationship_id
feature_relationship.feature_relationship_id
Cascade on delete
feature_relationshipprop_type_id_fkey
feature_relationshipprop.type_id
cvterm.cvterm_id
Cascade on delete
stock_dbxrefprop_stock_dbxref_id_fkey
stock_dbxrefprop.stock_dbxref_id
stock_dbxref.stock_dbxref_id
Cascade on delete
stock_dbxrefprop_type_id_fkey
stock_dbxrefprop.type_id
cvterm.cvterm_id
Cascade on delete
stockcollection_stock_stock_id_fkey
stockcollection_stock.stock_id
stock.stock_id
Cascade on delete
stockcollection_stock_stockcollection_id_fkey
stockcollection_stock.stockcollection_id
stockcollection.stockcollection_id
Cascade on delete
project_type_id_fkey
project.type_id
cvterm.cvterm_id
Null on delete
stock_relationship_cvterm_stock_relationship_id_fkey
stock_relationship_cvterm.stock_relationship_id
stock_relationship.stock_relationship_id
Cascade on delete
stock_relationship_cvterm_cvterm_id_fkey
stock_relationship_cvterm.cvterm_id
cvterm.cvterm_id
Restrict delete
stock_relationship_cvterm_pub_id_fkey
stock_relationship_cvterm.pub_id
pub.pub_id
Restrict delete
organism_dbxref_dbxref_id_fkey
organism_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
organism_dbxref_organism_id_fkey
organism_dbxref.organism_id
organism.organism_id
Cascade on delete
phylotree_analysis_id_fkey
phylotree.analysis_id
analysis.analysis_id
Cascade on delete
phylotree_dbxref_id_fkey
phylotree.dbxref_id
dbxref.dbxref_id
Cascade on delete
phylotree_type_id_fkey
phylotree.type_id
cvterm.cvterm_id
Cascade on delete
feature_synonym_synonym_id_fkey
feature_synonym.synonym_id
synonym.synonym_id
Cascade on delete
feature_synonym_pub_id_fkey
feature_synonym.pub_id
pub.pub_id
Cascade on delete
feature_synonym_feature_id_fkey
feature_synonym.feature_id
feature.feature_id
Cascade on delete
nd_geolocationprop_nd_geolocation_id_fkey
nd_geolocationprop.nd_geolocation_id
nd_geolocation.nd_geolocation_id
Cascade on delete
nd_geolocationprop_type_id_fkey
nd_geolocationprop.type_id
cvterm.cvterm_id
Cascade on delete
featureloc_pub_pub_id_fkey
featureloc_pub.pub_id
pub.pub_id
Cascade on delete
featureloc_pub_featureloc_id_fkey
featureloc_pub.featureloc_id
featureloc.featureloc_id
Cascade on delete
feature_dbxref_id_fkey
feature.dbxref_id
dbxref.dbxref_id
Null on delete
feature_type_id_fkey
feature.type_id
cvterm.cvterm_id
Cascade on delete
feature_organism_id_fkey
feature.organism_id
organism.organism_id
Cascade on delete
stock_relationship_pub_pub_id_fkey
stock_relationship_pub.pub_id
pub.pub_id
Cascade on delete
stock_relationship_pub_stock_relationship_id_fkey
stock_relationship_pub.stock_relationship_id
stock_relationship.stock_relationship_id
Cascade on delete
fpc_contig_fpc_build_id_fkey
fpc_contig.fpc_build_id
fpc_build.fpc_build_id
Cascade on delete
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
phylonode_pub_phylonode_id_fkey
phylonode_pub.phylonode_id
phylonode.phylonode_id
Cascade on delete
phylonode_pub_pub_id_fkey
phylonode_pub.pub_id
pub.pub_id
Cascade on delete
genotype_type_id_fkey
genotype.type_id
cvterm.cvterm_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
fpc_band_fpc_fingerprint_id_fkey
fpc_band.fpc_fingerprint_id
fpc_fingerprint.fpc_fingerprint_id
Cascade on delete
phylonode_dbxref_phylonode_id_fkey
phylonode_dbxref.phylonode_id
phylonode.phylonode_id
Cascade on delete
phylonode_dbxref_dbxref_id_fkey
phylonode_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
analysisprop_type_id_fkey
analysisprop.type_id
cvterm.cvterm_id
Cascade on delete
analysisprop_analysis_id_fkey
analysisprop.analysis_id
analysis.analysis_id
Cascade on delete
feature_cvtermprop_feature_cvterm_id_fkey
feature_cvtermprop.feature_cvterm_id
feature_cvterm.feature_cvterm_id
Cascade on delete
feature_cvtermprop_type_id_fkey
feature_cvtermprop.type_id
cvterm.cvterm_id
Cascade on delete
nd_protocolprop_nd_protocol_id_fkey
nd_protocolprop.nd_protocol_id
nd_protocol.nd_protocol_id
Cascade on delete
nd_protocolprop_type_id_fkey
nd_protocolprop.type_id
cvterm.cvterm_id
Cascade on delete
nd_reagent_relationship_type_id_fkey
nd_reagent_relationship.type_id
cvterm.cvterm_id
Cascade on delete
nd_reagent_relationship_subject_reagent_id_fkey
nd_reagent_relationship.subject_reagent_id
nd_reagent.nd_reagent_id
Cascade on delete
nd_reagent_relationship_object_reagent_id_fkey
nd_reagent_relationship.object_reagent_id
nd_reagent.nd_reagent_id
Cascade on delete
organism_sgn_organism_id_fkey
organism.sgn_organism_id
organism.organism_id
Restrict delete
phylotree_pub_phylotree_id_fkey
phylotree_pub.phylotree_id
phylotree.phylotree_id
Cascade on delete
phylotree_pub_pub_id_fkey
phylotree_pub.pub_id
pub.pub_id
Cascade on delete
featureprop_feature_id_fkey
featureprop.feature_id
feature.feature_id
Cascade on delete
featureprop_type_id_fkey
featureprop.type_id
cvterm.cvterm_id
Cascade on delete
fpc_contig_clone_fpc_contig_id_fkey
fpc_contig_clone.fpc_contig_id
fpc_contig.fpc_contig_id
Cascade on delete
fpc_contig_clone_clone_id_fkey
fpc_contig_clone.clone_id
clone.clone_id
Restrict delete
nd_experiment_stock_dbxref_dbxref_id_fkey
nd_experiment_stock_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
nd_experiment_stock_dbxref_nd_experiment_stock_id_fkey
nd_experiment_stock_dbxref.nd_experiment_stock_id
nd_experiment_stock.nd_experiment_stock_id
Cascade on delete
nd_experiment_genotype_nd_experiment_id_fkey
nd_experiment_genotype.nd_experiment_id
nd_experiment.nd_experiment_id
Cascade on delete
nd_experiment_genotype_genotype_id_fkey
nd_experiment_genotype.genotype_id
genotype.genotype_id
Cascade on delete
stock_pub_stock_id_fkey
stock_pub.stock_id
stock.stock_id
Cascade on delete
stock_pub_pub_id_fkey
stock_pub.pub_id
pub.pub_id
Cascade on delete
nd_experiment_pub_nd_experiment_id_fkey
nd_experiment_pub.nd_experiment_id
nd_experiment.nd_experiment_id
Cascade on delete
nd_experiment_pub_pub_id_fkey
nd_experiment_pub.pub_id
pub.pub_id
Cascade on delete
pub_type_id_fkey
pub.type_id
cvterm.cvterm_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
stockcollectionprop_stockcollection_id_fkey
stockcollectionprop.stockcollection_id
stockcollection.stockcollection_id
Cascade on delete
stockcollectionprop_type_id_fkey
stockcollectionprop.type_id
cvterm.cvterm_id
Restrict delete
nd_experiment_dbxref_dbxref_id_fkey
nd_experiment_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
nd_experiment_dbxref_nd_experiment_id_fkey
nd_experiment_dbxref.nd_experiment_id
nd_experiment.nd_experiment_id
Cascade on delete
stockcollection_type_id_fkey
stockcollection.type_id
cvterm.cvterm_id
Cascade on delete
stockcollection_contact_id_fkey
stockcollection.contact_id
contact.contact_id
Null on delete
featureprop_json_nd_protocol_id_fkey
featureprop_json.nd_protocol_id
nd_protocol.nd_protocol_id
Restrict delete
featureprop_json_feature_id_fkey
featureprop_json.feature_id
feature.feature_id
Restrict delete
featureprop_json_type_id_fkey
featureprop_json.type_id
cvterm.cvterm_id
Restrict delete
stockprop_stock_id_fkey
stockprop.stock_id
stock.stock_id
Cascade on delete
stockprop_type_id_fkey
stockprop.type_id
cvterm.cvterm_id
Cascade on delete
nd_experiment_nd_geolocation_id_fkey
nd_experiment.nd_geolocation_id
nd_geolocation.nd_geolocation_id
Cascade on delete
nd_experiment_type_id_fkey
nd_experiment.type_id
cvterm.cvterm_id
Cascade on delete
pubauthor_pub_id_fkey
pubauthor.pub_id
pub.pub_id
Cascade on delete
analysisfeature_analysis_id_fkey
analysisfeature.analysis_id
analysis.analysis_id
Cascade on delete
analysisfeature_feature_id_fkey
analysisfeature.feature_id
feature.feature_id
Cascade on delete
stockprop_pub_stockprop_id_fkey
stockprop_pub.stockprop_id
stockprop.stockprop_id
Cascade on delete
stockprop_pub_pub_id_fkey
stockprop_pub.pub_id
pub.pub_id
Cascade on delete
fpc_fingerprint_enzyme_id_fkey
fpc_fingerprint.enzyme_id
enzymes.enzyme_id
Restrict delete
fpc_fingerprint_clone_id_fkey
fpc_fingerprint.clone_id
clone.clone_id
Cascade on delete
nd_experiment_stockprop_type_id_fkey
nd_experiment_stockprop.type_id
cvterm.cvterm_id
Cascade on delete
nd_experiment_stockprop_nd_experiment_stock_id_fkey
nd_experiment_stockprop.nd_experiment_stock_id
nd_experiment_stock.nd_experiment_stock_id
Cascade on delete
organismpath_object_id_fkey
organismpath.object_id
organism.organism_id
Restrict delete
organismpath_type_id_fkey
organismpath.type_id
cvterm.cvterm_id
Restrict delete
organismpath_subject_id_fkey
organismpath.subject_id
organism.organism_id
Restrict delete
phylonodeprop_type_id_fkey
phylonodeprop.type_id
cvterm.cvterm_id
Cascade on delete
phylonodeprop_phylonode_id_fkey
phylonodeprop.phylonode_id
phylonode.phylonode_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
project_pub_project_id_fkey
project_pub.project_id
project.project_id
Cascade on delete
project_pub_pub_id_fkey
project_pub.pub_id
pub.pub_id
Cascade on delete
nd_reagentprop_nd_reagent_id_fkey
nd_reagentprop.nd_reagent_id
nd_reagent.nd_reagent_id
Cascade on delete
nd_reagentprop_type_id_fkey
nd_reagentprop.type_id
cvterm.cvterm_id
Cascade on delete
tmp_cds_handler_relationship_cds_row_id_fkey
tmp_cds_handler_relationship.cds_row_id
tmp_cds_handler.cds_row_id
Cascade on delete
phendesc_pub_id_fkey
phendesc.pub_id
pub.pub_id
Cascade on delete
phendesc_environment_id_fkey
phendesc.environment_id
environment.environment_id
Cascade on delete
phendesc_genotype_id_fkey
phendesc.genotype_id
genotype.genotype_id
Cascade on delete
phendesc_type_id_fkey
phendesc.type_id
cvterm.cvterm_id
Cascade on delete
feature_genotype_genotype_id_fkey
feature_genotype.genotype_id
genotype.genotype_id
Cascade on delete
feature_genotype_chromosome_id_fkey
feature_genotype.chromosome_id
feature.feature_id
Null on delete
feature_genotype_cvterm_id_fkey
feature_genotype.cvterm_id
cvterm.cvterm_id
Cascade on delete
feature_genotype_feature_id_fkey
feature_genotype.feature_id
feature.feature_id
Cascade on delete
enzyme_restriction_sites_enzyme_id_fkey
enzyme_restriction_sites.enzyme_id
enzymes.enzyme_id
Restrict delete
feature_relationshipprop_pub_feature_relationshipprop_id_fkey
feature_relationshipprop_pub.feature_relationshipprop_id
feature_relationshipprop.feature_relationshipprop_id
Cascade on delete
feature_relationshipprop_pub_pub_id_fkey
feature_relationshipprop_pub.pub_id
pub.pub_id
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)))