Schema Version: 1.3

Constraints

466 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
protocolparam_protocol_id_fkey
protocolparam.protocol_id
protocol.protocol_id
Cascade on delete
protocolparam_datatype_id_fkey
protocolparam.datatype_id
cvterm.cvterm_id
Null on delete
protocolparam_unittype_id_fkey
protocolparam.unittype_id
cvterm.cvterm_id
Null on delete
organism_cvtermprop_type_id_fkey
organism_cvtermprop.type_id
cvterm.cvterm_id
Cascade on delete
organism_cvtermprop_organism_cvterm_id_fkey
organism_cvtermprop.organism_cvterm_id
organism_cvterm.organism_cvterm_id
Cascade on delete
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
treatment_protocol_id_fkey
treatment.protocol_id
protocol.protocol_id
Null on delete
treatment_biomaterial_id_fkey
treatment.biomaterial_id
biomaterial.biomaterial_id
Cascade on delete
treatment_type_id_fkey
treatment.type_id
cvterm.cvterm_id
Cascade on delete
element_relationship_type_id_fkey
element_relationship.type_id
cvterm.cvterm_id
Restrict delete
element_relationship_object_id_fkey
element_relationship.object_id
element.element_id
Restrict delete
element_relationship_subject_id_fkey
element_relationship.subject_id
element.element_id
Restrict delete
expression_cvterm_cvterm_id_fkey
expression_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
expression_cvterm_expression_id_fkey
expression_cvterm.expression_id
expression.expression_id
Cascade on delete
expression_cvterm_cvterm_type_id_fkey
expression_cvterm.cvterm_type_id
cvterm.cvterm_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
phylotreeprop_phylotree_id_fkey
phylotreeprop.phylotree_id
phylotree.phylotree_id
Cascade on delete
phylotreeprop_type_id_fkey
phylotreeprop.type_id
cvterm.cvterm_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
analysis_relationship_object_id_fkey
analysis_relationship.object_id
analysis.analysis_id
Cascade on delete
analysis_relationship_subject_id_fkey
analysis_relationship.subject_id
analysis.analysis_id
Cascade on delete
analysis_relationship_type_id_fkey
analysis_relationship.type_id
cvterm.cvterm_id
Cascade on 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
featuremap_pub_pub_id_fkey
featuremap_pub.pub_id
pub.pub_id
Cascade on delete
featuremap_pub_featuremap_id_fkey
featuremap_pub.featuremap_id
featuremap.featuremap_id
Cascade on 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
library_relationship_pub_library_relationship_id_fkey
library_relationship_pub.library_relationship_id
library_relationship.library_relationship_id
Cascade on delete
library_relationship_pub_pub_id_fkey
library_relationship_pub.pub_id
pub.pub_id
Restrict delete
project_feature_feature_id_fkey
project_feature.feature_id
feature.feature_id
Cascade on delete
project_feature_project_id_fkey
project_feature.project_id
project.project_id
Cascade on delete
library_type_id_fkey
library.type_id
cvterm.cvterm_id
Restrict delete
library_organism_id_fkey
library.organism_id
organism.organism_id
Restrict 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
feature_phenotype_feature_id_fkey
feature_phenotype.feature_id
feature.feature_id
Cascade on delete
feature_phenotype_phenotype_id_fkey
feature_phenotype.phenotype_id
phenotype.phenotype_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
pubauthor_contact_contact_id_fkey
pubauthor_contact.contact_id
contact.contact_id
Cascade on delete
pubauthor_contact_pubauthor_id_fkey
pubauthor_contact.pubauthor_id
pubauthor.pubauthor_id
Cascade on delete
cell_lineprop_type_id_fkey
cell_lineprop.type_id
cvterm.cvterm_id
Cascade on delete
cell_lineprop_cell_line_id_fkey
cell_lineprop.cell_line_id
cell_line.cell_line_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
cell_line_dbxref_cell_line_id_fkey
cell_line_dbxref.cell_line_id
cell_line.cell_line_id
Cascade on delete
cell_line_dbxref_dbxref_id_fkey
cell_line_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
assay_project_project_id_fkey
assay_project.project_id
project.project_id
Restrict delete
assay_project_assay_id_fkey
assay_project.assay_id
assay.assay_id
Restrict 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
stock_featuremap_featuremap_id_fkey
stock_featuremap.featuremap_id
featuremap.featuremap_id
Cascade on delete
stock_featuremap_type_id_fkey
stock_featuremap.type_id
cvterm.cvterm_id
Cascade on delete
stock_featuremap_stock_id_fkey
stock_featuremap.stock_id
stock.stock_id
Cascade on 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
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
feature_expression_pub_id_fkey
feature_expression.pub_id
pub.pub_id
Cascade on delete
feature_expression_feature_id_fkey
feature_expression.feature_id
feature.feature_id
Cascade on delete
feature_expression_expression_id_fkey
feature_expression.expression_id
expression.expression_id
Cascade on delete
project_stock_project_id_fkey
project_stock.project_id
project.project_id
Cascade on delete
project_stock_stock_id_fkey
project_stock.stock_id
stock.stock_id
Cascade on delete
feature_expressionprop_type_id_fkey
feature_expressionprop.type_id
cvterm.cvterm_id
Cascade on delete
feature_expressionprop_feature_expression_id_fkey
feature_expressionprop.feature_expression_id
feature_expression.feature_expression_id
Cascade on delete
expression_cvtermprop_type_id_fkey
expression_cvtermprop.type_id
cvterm.cvterm_id
Cascade on delete
expression_cvtermprop_expression_cvterm_id_fkey
expression_cvtermprop.expression_cvterm_id
expression_cvterm.expression_cvterm_id
Cascade 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_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
studydesign_study_id_fkey
studydesign.study_id
study.study_id
Cascade on delete
library_relationship_type_id_fkey
library_relationship.type_id
cvterm.cvterm_id
Restrict delete
library_relationship_subject_id_fkey
library_relationship.subject_id
library.library_id
Cascade on delete
library_relationship_object_id_fkey
library_relationship.object_id
library.library_id
Cascade on delete
featurepos_feature_id_fkey
featurepos.feature_id
feature.feature_id
Cascade on delete
featurepos_featuremap_id_fkey
featurepos.featuremap_id
featuremap.featuremap_id
Cascade on delete
featurepos_map_feature_id_fkey
featurepos.map_feature_id
feature.feature_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
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
magedocumentation_tableinfo_id_fkey
magedocumentation.tableinfo_id
tableinfo.tableinfo_id
Cascade on delete
magedocumentation_mageml_id_fkey
magedocumentation.mageml_id
mageml.mageml_id
Cascade on delete
libraryprop_library_id_fkey
libraryprop.library_id
library.library_id
Cascade on delete
libraryprop_type_id_fkey
libraryprop.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
arraydesign_dbxref_id_fkey
arraydesign.dbxref_id
dbxref.dbxref_id
Null on delete
arraydesign_platformtype_id_fkey
arraydesign.platformtype_id
cvterm.cvterm_id
Cascade on delete
arraydesign_protocol_id_fkey
arraydesign.protocol_id
protocol.protocol_id
Null on delete
arraydesign_substratetype_id_fkey
arraydesign.substratetype_id
cvterm.cvterm_id
Null on delete
arraydesign_manufacturer_id_fkey
arraydesign.manufacturer_id
contact.contact_id
Cascade on delete
expressionprop_type_id_fkey
expressionprop.type_id
cvterm.cvterm_id
Cascade on delete
expressionprop_expression_id_fkey
expressionprop.expression_id
expression.expression_id
Cascade on delete
project_dbxref_dbxref_id_fkey
project_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
project_dbxref_project_id_fkey
project_dbxref.project_id
project.project_id
Cascade on delete
featureposprop_type_id_fkey
featureposprop.type_id
cvterm.cvterm_id
Cascade on delete
featureposprop_featurepos_id_fkey
featureposprop.featurepos_id
featurepos.featurepos_id
Cascade on delete
expression_image_expression_id_fkey
expression_image.expression_id
expression.expression_id
Cascade on delete
expression_image_eimage_id_fkey
expression_image.eimage_id
eimage.eimage_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
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
quantificationprop_type_id_fkey
quantificationprop.type_id
cvterm.cvterm_id
Cascade on delete
quantificationprop_quantification_id_fkey
quantificationprop.quantification_id
quantification.quantification_id
Cascade on delete
biomaterialprop_type_id_fkey
biomaterialprop.type_id
cvterm.cvterm_id
Cascade on delete
biomaterialprop_biomaterial_id_fkey
biomaterialprop.biomaterial_id
biomaterial.biomaterial_id
Cascade 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
nd_experiment_analysis_nd_experiment_id_fkey
nd_experiment_analysis.nd_experiment_id
nd_experiment.nd_experiment_id
Cascade on delete
nd_experiment_analysis_type_id_fkey
nd_experiment_analysis.type_id
cvterm.cvterm_id
Cascade on delete
nd_experiment_analysis_analysis_id_fkey
nd_experiment_analysis.analysis_id
analysis.analysis_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
library_expressionprop_library_expression_id_fkey
library_expressionprop.library_expression_id
library_expression.library_expression_id
Cascade on delete
library_expressionprop_type_id_fkey
library_expressionprop.type_id
cvterm.cvterm_id
Restrict 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
stockcollection_db_db_id_fkey
stockcollection_db.db_id
db.db_id
Cascade on delete
stockcollection_db_stockcollection_id_fkey
stockcollection_db.stockcollection_id
stockcollection.stockcollection_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
control_tableinfo_id_fkey
control.tableinfo_id
tableinfo.tableinfo_id
Cascade on delete
control_type_id_fkey
control.type_id
cvterm.cvterm_id
Cascade on delete
control_assay_id_fkey
control.assay_id
assay.assay_id
Cascade on delete
library_synonym_synonym_id_fkey
library_synonym.synonym_id
synonym.synonym_id
Cascade on delete
library_synonym_pub_id_fkey
library_synonym.pub_id
pub.pub_id
Cascade on delete
library_synonym_library_id_fkey
library_synonym.library_id
library.library_id
Cascade on delete
assayprop_type_id_fkey
assayprop.type_id
cvterm.cvterm_id
Cascade on delete
assayprop_assay_id_fkey
assayprop.assay_id
assay.assay_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
feature_pubprop_type_id_fkey
feature_pubprop.type_id
cvterm.cvterm_id
Cascade on delete
feature_pubprop_feature_pub_id_fkey
feature_pubprop.feature_pub_id
feature_pub.feature_pub_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
elementresult_relationship_object_id_fkey
elementresult_relationship.object_id
elementresult.elementresult_id
Restrict delete
elementresult_relationship_subject_id_fkey
elementresult_relationship.subject_id
elementresult.elementresult_id
Restrict delete
elementresult_relationship_type_id_fkey
elementresult_relationship.type_id
cvterm.cvterm_id
Restrict 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
library_expression_expression_id_fkey
library_expression.expression_id
expression.expression_id
Cascade on delete
library_expression_pub_id_fkey
library_expression.pub_id
pub.pub_id
Restrict delete
library_expression_library_id_fkey
library_expression.library_id
library.library_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_pub_pub_id_fkey
organism_pub.pub_id
pub.pub_id
Cascade on delete
organism_pub_organism_id_fkey
organism_pub.organism_id
organism.organism_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
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
acquisitionprop_type_id_fkey
acquisitionprop.type_id
cvterm.cvterm_id
Cascade on delete
acquisitionprop_acquisition_id_fkey
acquisitionprop.acquisition_id
acquisition.acquisition_id
Cascade on delete
studydesignprop_studydesign_id_fkey
studydesignprop.studydesign_id
studydesign.studydesign_id
Cascade on delete
studydesignprop_type_id_fkey
studydesignprop.type_id
cvterm.cvterm_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
featuremapprop_featuremap_id_fkey
featuremapprop.featuremap_id
featuremap.featuremap_id
Cascade on delete
featuremapprop_type_id_fkey
featuremapprop.type_id
cvterm.cvterm_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
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
cell_line_synonym_synonym_id_fkey
cell_line_synonym.synonym_id
synonym.synonym_id
Cascade on delete
cell_line_synonym_cell_line_id_fkey
cell_line_synonym.cell_line_id
cell_line.cell_line_id
Cascade on delete
cell_line_synonym_pub_id_fkey
cell_line_synonym.pub_id
pub.pub_id
Cascade on delete
pubauthor_pub_id_fkey
pubauthor.pub_id
pub.pub_id
Cascade on delete
study_assay_study_id_fkey
study_assay.study_id
study.study_id
Cascade on delete
study_assay_assay_id_fkey
study_assay.assay_id
assay.assay_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
acquisition_relationship_object_id_fkey
acquisition_relationship.object_id
acquisition.acquisition_id
Cascade on delete
acquisition_relationship_type_id_fkey
acquisition_relationship.type_id
cvterm.cvterm_id
Cascade on delete
acquisition_relationship_subject_id_fkey
acquisition_relationship.subject_id
acquisition.acquisition_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
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
analysis_pub_analysis_id_fkey
analysis_pub.analysis_id
analysis.analysis_id
Cascade on delete
analysis_pub_pub_id_fkey
analysis_pub.pub_id
pub.pub_id
Cascade on delete
organism_cvterm_cvterm_id_fkey
organism_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
organism_cvterm_pub_id_fkey
organism_cvterm.pub_id
pub.pub_id
Cascade on delete
organism_cvterm_organism_id_fkey
organism_cvterm.organism_id
organism.organism_id
Cascade on delete
biomaterial_treatment_unittype_id_fkey
biomaterial_treatment.unittype_id
cvterm.cvterm_id
Null on delete
biomaterial_treatment_treatment_id_fkey
biomaterial_treatment.treatment_id
treatment.treatment_id
Cascade on delete
biomaterial_treatment_biomaterial_id_fkey
biomaterial_treatment.biomaterial_id
biomaterial.biomaterial_id
Cascade on delete
study_contact_id_fkey
study.contact_id
contact.contact_id
Cascade on delete
study_pub_id_fkey
study.pub_id
pub.pub_id
Null on delete
study_dbxref_id_fkey
study.dbxref_id
dbxref.dbxref_id
Null 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
cell_lineprop_pub_cell_lineprop_id_fkey
cell_lineprop_pub.cell_lineprop_id
cell_lineprop.cell_lineprop_id
Cascade on delete
cell_lineprop_pub_pub_id_fkey
cell_lineprop_pub.pub_id
pub.pub_id
Cascade on delete
studyprop_study_id_fkey
studyprop.study_id
study.study_id
Cascade on delete
studyprop_type_id_fkey
studyprop.type_id
cvterm.cvterm_id
Cascade on delete
stock_feature_feature_id_fkey
stock_feature.feature_id
feature.feature_id
Cascade on delete
stock_feature_type_id_fkey
stock_feature.type_id
cvterm.cvterm_id
Cascade on delete
stock_feature_stock_id_fkey
stock_feature.stock_id
stock.stock_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
biomaterial_dbxref_biomaterial_id_fkey
biomaterial_dbxref.biomaterial_id
biomaterial.biomaterial_id
Cascade on delete
biomaterial_dbxref_dbxref_id_fkey
biomaterial_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
quantification_acquisition_id_fkey
quantification.acquisition_id
acquisition.acquisition_id
Cascade on delete
quantification_operator_id_fkey
quantification.operator_id
contact.contact_id
Null on delete
quantification_analysis_id_fkey
quantification.analysis_id
analysis.analysis_id
Cascade on delete
quantification_protocol_id_fkey
quantification.protocol_id
protocol.protocol_id
Null on delete
protocol_dbxref_id_fkey
protocol.dbxref_id
dbxref.dbxref_id
Null on delete
protocol_pub_id_fkey
protocol.pub_id
pub.pub_id
Null on delete
protocol_type_id_fkey
protocol.type_id
cvterm.cvterm_id
Cascade on delete
library_pub_library_id_fkey
library_pub.library_id
library.library_id
Cascade on delete
library_pub_pub_id_fkey
library_pub.pub_id
pub.pub_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
quantification_relationship_object_id_fkey
quantification_relationship.object_id
quantification.quantification_id
Cascade on delete
quantification_relationship_type_id_fkey
quantification_relationship.type_id
cvterm.cvterm_id
Cascade on delete
quantification_relationship_subject_id_fkey
quantification_relationship.subject_id
quantification.quantification_id
Cascade on delete
organism_relationship_subject_id_fkey
organism_relationship.subject_id
organism.organism_id
Cascade on delete
organism_relationship_type_id_fkey
organism_relationship.type_id
cvterm.cvterm_id
Cascade on delete
organism_relationship_object_id_fkey
organism_relationship.object_id
organism.organism_id
Cascade on delete
synonym_type_id_fkey
synonym.type_id
cvterm.cvterm_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
featurerange_rightstartf_id_fkey
featurerange.rightstartf_id
feature.feature_id
Null on delete
featurerange_leftendf_id_fkey
featurerange.leftendf_id
feature.feature_id
Null on delete
featurerange_featuremap_id_fkey
featurerange.featuremap_id
featuremap.featuremap_id
Cascade on delete
featurerange_rightendf_id_fkey
featurerange.rightendf_id
feature.feature_id
Cascade on delete
featurerange_feature_id_fkey
featurerange.feature_id
feature.feature_id
Cascade on delete
featurerange_leftstartf_id_fkey
featurerange.leftstartf_id
feature.feature_id
Cascade on delete
studyprop_feature_type_id_fkey
studyprop_feature.type_id
cvterm.cvterm_id
Cascade on delete
studyprop_feature_studyprop_id_fkey
studyprop_feature.studyprop_id
studyprop.studyprop_id
Cascade on delete
studyprop_feature_feature_id_fkey
studyprop_feature.feature_id
feature.feature_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
featuremap_dbxref_dbxref_id_fkey
featuremap_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
featuremap_dbxref_featuremap_id_fkey
featuremap_dbxref.featuremap_id
featuremap.featuremap_id
Cascade on delete
expression_pub_expression_id_fkey
expression_pub.expression_id
expression.expression_id
Cascade on delete
expression_pub_pub_id_fkey
expression_pub.pub_id
pub.pub_id
Cascade on delete
cell_line_cvtermprop_type_id_fkey
cell_line_cvtermprop.type_id
cvterm.cvterm_id
Cascade on delete
cell_line_cvtermprop_cell_line_cvterm_id_fkey
cell_line_cvtermprop.cell_line_cvterm_id
cell_line_cvterm.cell_line_cvterm_id
Cascade on delete
analysis_dbxref_dbxref_id_fkey
analysis_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
analysis_dbxref_analysis_id_fkey
analysis_dbxref.analysis_id
analysis.analysis_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
library_featureprop_type_id_fkey
library_featureprop.type_id
cvterm.cvterm_id
Restrict delete
library_featureprop_library_feature_id_fkey
library_featureprop.library_feature_id
library_feature.library_feature_id
Cascade on delete
library_feature_feature_id_fkey
library_feature.feature_id
feature.feature_id
Cascade on delete
library_feature_library_id_fkey
library_feature.library_id
library.library_id
Cascade on delete
acquisition_channel_id_fkey
acquisition.channel_id
channel.channel_id
Null on delete
acquisition_assay_id_fkey
acquisition.assay_id
assay.assay_id
Cascade on delete
acquisition_protocol_id_fkey
acquisition.protocol_id
protocol.protocol_id
Null on delete
library_cvterm_pub_id_fkey
library_cvterm.pub_id
pub.pub_id
Restrict delete
library_cvterm_library_id_fkey
library_cvterm.library_id
library.library_id
Cascade on delete
library_cvterm_cvterm_id_fkey
library_cvterm.cvterm_id
cvterm.cvterm_id
Restrict delete
nd_protocol_type_id_fkey
nd_protocol.type_id
cvterm.cvterm_id
Cascade on delete
featuremap_unittype_id_fkey
featuremap.unittype_id
cvterm.cvterm_id
Null on delete
dbxref_db_id_fkey
dbxref.db_id
db.db_id
Cascade on delete
studyfactorvalue_studyfactor_id_fkey
studyfactorvalue.studyfactor_id
studyfactor.studyfactor_id
Cascade on delete
studyfactorvalue_assay_id_fkey
studyfactorvalue.assay_id
assay.assay_id
Cascade on delete
nd_reagent_feature_id_fkey
nd_reagent.feature_id
feature.feature_id
Cascade on delete
nd_reagent_type_id_fkey
nd_reagent.type_id
cvterm.cvterm_id
Cascade on delete
featuremap_organism_organism_id_fkey
featuremap_organism.organism_id
organism.organism_id
Cascade on delete
featuremap_organism_featuremap_id_fkey
featuremap_organism.featuremap_id
featuremap.featuremap_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
cell_line_library_cell_line_id_fkey
cell_line_library.cell_line_id
cell_line.cell_line_id
Cascade on delete
cell_line_library_library_id_fkey
cell_line_library.library_id
library.library_id
Cascade on delete
cell_line_library_pub_id_fkey
cell_line_library.pub_id
pub.pub_id
Cascade 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
cell_line_feature_cell_line_id_fkey
cell_line_feature.cell_line_id
cell_line.cell_line_id
Cascade on delete
cell_line_feature_pub_id_fkey
cell_line_feature.pub_id
pub.pub_id
Cascade on delete
cell_line_feature_feature_id_fkey
cell_line_feature.feature_id
feature.feature_id
Cascade on delete
libraryprop_pub_pub_id_fkey
libraryprop_pub.pub_id
pub.pub_id
Cascade on delete
libraryprop_pub_libraryprop_id_fkey
libraryprop_pub.libraryprop_id
libraryprop.libraryprop_id
Cascade on delete
biomaterial_dbxref_id_fkey
biomaterial.dbxref_id
dbxref.dbxref_id
Null on delete
biomaterial_biosourceprovider_id_fkey
biomaterial.biosourceprovider_id
contact.contact_id
Null on delete
biomaterial_taxon_id_fkey
biomaterial.taxon_id
organism.organism_id
Null on delete
featuremap_contact_featuremap_id_fkey
featuremap_contact.featuremap_id
featuremap.featuremap_id
Cascade on delete
featuremap_contact_contact_id_fkey
featuremap_contact.contact_id
contact.contact_id
Cascade on delete
element_type_id_fkey
element.type_id
cvterm.cvterm_id
Null on delete
element_dbxref_id_fkey
element.dbxref_id
dbxref.dbxref_id
Null on delete
element_arraydesign_id_fkey
element.arraydesign_id
arraydesign.arraydesign_id
Cascade on delete
element_feature_id_fkey
element.feature_id
feature.feature_id
Null 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
dbxrefprop_dbxref_id_fkey
dbxrefprop.dbxref_id
dbxref.dbxref_id
Restrict delete
dbxrefprop_type_id_fkey
dbxrefprop.type_id
cvterm.cvterm_id
Restrict delete
contact_type_id_fkey
contact.type_id
cvterm.cvterm_id
Restrict 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
arraydesignprop_type_id_fkey
arraydesignprop.type_id
cvterm.cvterm_id
Cascade on delete
arraydesignprop_arraydesign_id_fkey
arraydesignprop.arraydesign_id
arraydesign.arraydesign_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
cell_line_pub_pub_id_fkey
cell_line_pub.pub_id
pub.pub_id
Cascade on delete
cell_line_pub_cell_line_id_fkey
cell_line_pub.cell_line_id
cell_line.cell_line_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
organismprop_pub_organismprop_id_fkey
organismprop_pub.organismprop_id
organismprop.organismprop_id
Cascade on delete
organismprop_pub_pub_id_fkey
organismprop_pub.pub_id
pub.pub_id
Cascade on delete
project_analysis_analysis_id_fkey
project_analysis.analysis_id
analysis.analysis_id
Cascade on delete
project_analysis_project_id_fkey
project_analysis.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
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
cell_line_cvterm_cvterm_id_fkey
cell_line_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
cell_line_cvterm_cell_line_id_fkey
cell_line_cvterm.cell_line_id
cell_line.cell_line_id
Cascade on delete
cell_line_cvterm_pub_id_fkey
cell_line_cvterm.pub_id
pub.pub_id
Cascade on delete
cell_line_organism_id_fkey
cell_line.organism_id
organism.organism_id
Cascade on delete
contactprop_type_id_fkey
contactprop.type_id
cvterm.cvterm_id
Cascade on delete
contactprop_contact_id_fkey
contactprop.contact_id
contact.contact_id
Cascade on delete
stock_library_library_id_fkey
stock_library.library_id
library.library_id
Cascade on delete
stock_library_stock_id_fkey
stock_library.stock_id
stock.stock_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
elementresult_quantification_id_fkey
elementresult.quantification_id
quantification.quantification_id
Cascade on delete
elementresult_element_id_fkey
elementresult.element_id
element.element_id
Cascade on delete
biomaterial_relationship_type_id_fkey
biomaterial_relationship.type_id
cvterm.cvterm_id
Restrict delete
biomaterial_relationship_object_id_fkey
biomaterial_relationship.object_id
biomaterial.biomaterial_id
Restrict delete
biomaterial_relationship_subject_id_fkey
biomaterial_relationship.subject_id
biomaterial.biomaterial_id
Restrict 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
studyfactor_studydesign_id_fkey
studyfactor.studydesign_id
studydesign.studydesign_id
Cascade on delete
studyfactor_type_id_fkey
studyfactor.type_id
cvterm.cvterm_id
Null on delete
genotype_type_id_fkey
genotype.type_id
cvterm.cvterm_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
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
cell_line_relationship_subject_id_fkey
cell_line_relationship.subject_id
cell_line.cell_line_id
Cascade on delete
cell_line_relationship_object_id_fkey
cell_line_relationship.object_id
cell_line.cell_line_id
Cascade on delete
cell_line_relationship_type_id_fkey
cell_line_relationship.type_id
cvterm.cvterm_id
Cascade on delete
organism_type_id_fkey
organism.type_id
cvterm.cvterm_id
Cascade on 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
chadoprop_type_id_fkey
chadoprop.type_id
cvterm.cvterm_id
Restrict 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
feature_contact_feature_id_fkey
feature_contact.feature_id
feature.feature_id
Cascade on delete
feature_contact_contact_id_fkey
feature_contact.contact_id
contact.contact_id
Cascade on delete
library_contact_contact_id_fkey
library_contact.contact_id
contact.contact_id
Cascade on delete
library_contact_library_id_fkey
library_contact.library_id
library.library_id
Cascade on delete
library_dbxref_library_id_fkey
library_dbxref.library_id
library.library_id
Cascade on delete
library_dbxref_dbxref_id_fkey
library_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
assay_arraydesign_id_fkey
assay.arraydesign_id
arraydesign.arraydesign_id
Cascade on delete
assay_protocol_id_fkey
assay.protocol_id
protocol.protocol_id
Null on delete
assay_operator_id_fkey
assay.operator_id
contact.contact_id
Cascade on delete
assay_dbxref_id_fkey
assay.dbxref_id
dbxref.dbxref_id
Null 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
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
analysis_cvterm_cvterm_id_fkey
analysis_cvterm.cvterm_id
cvterm.cvterm_id
Cascade on delete
analysis_cvterm_analysis_id_fkey
analysis_cvterm.analysis_id
analysis.analysis_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
analysisfeatureprop_analysisfeature_id_fkey
analysisfeatureprop.analysisfeature_id
analysisfeature.analysisfeature_id
Cascade on delete
analysisfeatureprop_type_id_fkey
analysisfeatureprop.type_id
cvterm.cvterm_id
Cascade on 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
assay_biomaterial_assay_id_fkey
assay_biomaterial.assay_id
assay.assay_id
Cascade on delete
assay_biomaterial_biomaterial_id_fkey
assay_biomaterial.biomaterial_id
biomaterial.biomaterial_id
Cascade on delete
assay_biomaterial_channel_id_fkey
assay_biomaterial.channel_id
channel.channel_id
Null 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
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
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
None detected