SchemaSpy Analysis of zfindb.public - Constraints Generated by
SchemaSpy
447 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
accbk_fdbcont_zdb_id_foreign_key_odc accession_bank.accbk_fdbcont_zdb_id foreign_db_contains.fdbcont_zdb_id Cascade on delete 
af_feature_zdb_id_fk amsterdam_file.af_feature_zdb_id feature.feature_zdb_id Cascade on delete 
aliastok_dalias_zdb_id_foreign_key all_alias_tokens.aliastok_dalias_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
alltermcon_contained_zdb_id_foreign_key all_term_contains.alltermcon_contained_zdb_id term.term_zdb_id Cascade on delete 
alltermcon_container_zdb_id_foreign_key all_term_contains.alltermcon_container_zdb_id term.term_zdb_id Cascade on delete 
anatdisp_item_zdb_id_foreign_key anatomy_display.anatdisp_item_zdb_id term.term_zdb_id Cascade on delete 
anatdisp_stg_zdb_id_foreign_key anatomy_display.anatdisp_stg_zdb_id stage.stg_zdb_id Cascade on delete 
ant_type_foreign_key antibody.atb_type antibody_type.atbtype_name Restrict delete 
apato_quality_zdb_id_fk apato_infrastructure.api_quality_zdb_id term.term_zdb_id Restrict delete 
apato_tag_fk apato_infrastructure.api_tag apato_tag.apatotag_name Restrict delete 
apato_zdb_id_active_data_fk_odc apato_infrastructure.api_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
atb_host_organism_foreign_key antibody.atb_host_organism organism.organism_common_name Restrict delete 
atb_hviso_name_foreign_key antibody.atb_hviso_name heavy_chain_isotype.hviso_name Restrict delete 
atb_immun_organism_foreign_key antibody.atb_immun_organism organism.organism_common_name Restrict delete 
atb_ltiso_name_foreign_key antibody.atb_ltiso_name light_chain_isotype.ltiso_name Restrict delete 
atb_mrkr_foreign_key_odc antibody.atb_zdb_id marker.mrkr_zdb_id Cascade on delete 
authorpub_author_id_fk author_publication.authorpub_author_id author.author_pk_id Restrict delete 
authorpub_pub_zdb_id_fk author_publication.authorpub_pub_zdb_id publication.zdb_id Restrict delete 
bdborder_child_foreign_key blastdb_order.bdborder_child_blastdb_zdb_id blast_database.blastdb_zdb_id Restrict delete 
bdborder_parent_foreign_key blastdb_order.bdborder_parent_blastdb_zdb_id blast_database.blastdb_zdb_id Restrict delete 
bdot_origination_id_foreign_key blast_database.blastdb_origination_id blast_database_origination_type.bdot_pk_id Restrict delete 
bhit_bqry_zdb_id_foreign_keyn_odc blast_hit.bhit_bqry_zdb_id blast_query.bqry_zdb_id Cascade on delete 
bhit_target_accbk_pk_id_foreign_keyn_odc blast_hit.bhit_target_accbk_pk_id accession_bank.accbk_pk_id Cascade on delete 
blast_database_type_foreign_key blast_database.blastdb_type blast_database_type.bdbt_type Restrict delete 
blast_report_bqry_foreign_key_odc blast_report.brpt_bqry_zdb_id blast_query.bqry_zdb_id Cascade on delete 
blastdb_regen_content_blastdb_zdb_id_foreign_key blastdb_regen_content.brc_blastdb_zdb_id blast_database.blastdb_zdb_id Restrict delete 
blastdbr_blastdb_zdb_id_foreign_key blastdb_run.blastdbr_blastdb_zdb_id blast_database.blastdb_zdb_id Restrict delete 
blastdbr_run_zdb_id_foreign_key blastdb_run.blastdbr_run_zdb_id run.run_zdb_id Restrict delete 
bqry_accbk_pk_id_foreign_key_odc blast_query.bqry_accbk_pk_id accession_bank.accbk_pk_id Cascade on delete 
bqry_runcan_zdb_id_foreign_key_odc blast_query.bqry_runcan_zdb_id run_candidate.runcan_zdb_id Cascade on delete 
candidate_active_data_foreign_key_odc candidate.cnd_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
cc_component_zdb_id_foreign_key construct_component.cc_component_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
cc_construct_zdb_id_odc construct_component.cc_construct_zdb_id construct.construct_zdb_id Cascade on delete 
clean_expression_fast_search_genox_zdb_id_foreign_key_odc clean_expression_fast_search.cefs_genox_zdb_id fish_experiment.genox_zdb_id Cascade on delete 
clean_expression_fast_search_mrkr_zdb_id_foreign_key_odc clean_expression_fast_search.cefs_mrkr_zdb_id marker.mrkr_zdb_id Cascade on delete 
clone_mrkr_zdb_id_foreign_key clone.clone_mrkr_zdb_id marker.mrkr_zdb_id Cascade on delete 
clone_problem_type_foreign_key clone.clone_problem_type clone_problem_type.cpt_type Restrict delete 
clone_sequence_type_foreign_key clone.clone_sequence_type sequence_type.seqtype_name Restrict delete 
clone_vector_name_foreign_key clone.clone_vector_name vector.vector_name Restrict delete 
cmpy_zdb_id_foreign_key company.zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
cmr_construct_fk_odc construct_marker_relationship.conmrkrrel_construct_zdb_id construct.construct_zdb_id Cascade on delete 
cmr_mrkr_fk_odc construct_marker_relationship.conmrkrrel_mrkr_zdb_id marker.mrkr_zdb_id Cascade on delete 
company_contact_person_foreign_key company.contact_person person.zdb_id Restrict delete 
company_owner_foreign_key company.owner person.zdb_id Restrict delete 
condition_data_type_cdt_group_foreign_key condition_data_type.cdt_group condition.condition_group Cascade on delete 
condition_data_type_zdb_active_data_foreign_key condition_data_type.cdt_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
conmrkrrel_relationship_type_foreign_key construct_marker_relationship.conmrkrrel_relationship_type marker_relationship_type.mreltype_name Restrict delete 
conmrkrrel_zdb_id_fk_odc construct_marker_relationship.conmrkrrel_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
construct_figure_construct_zdb_id_foreign_key_odc construct_figure.consfig_construct_zdb_id construct.construct_zdb_id Cascade on delete 
construct_figure_fig_zdb_id_foreign_key_odc construct_figure.consfig_fig_zdb_id figure.fig_zdb_id Cascade on delete 
construct_owner_zdb_id construct.construct_owner_zdb_id person.zdb_id Restrict delete 
construct_zdb_active_data_foreign_key_odc construct.construct_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
cur_curator_zdb_id_foreign_key curation.cur_curator_zdb_id person.zdb_id Restrict delete 
cur_pub_zdb_id_foreign_key curation.cur_pub_zdb_id publication.zdb_id Cascade on delete 
cur_topic_foreign_key curation.cur_topic curation_topic.curtopic_name Restrict delete 
cur_zdb_id_foreign_key curation.cur_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
curator_session_person_zdb_id_foreign_key_odc curator_session.cs_person_zdb_id person.zdb_id Cascade on delete 
cv_zdb_active_data_foreign_key_odc controlled_vocabulary.cv_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
dalias_data_zdb_id_foreign_key data_alias.dalias_data_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
dalias_group_id_foreign_key data_alias.dalias_group_id alias_group.aliasgrp_pk_id Restrict delete 
dalias_scope_id_fk data_alias.dalias_scope_id alias_scope.aliasscope_pk_id Restrict delete 
dalias_zdb_id_foreign_key data_alias.dalias_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
damo_dat_fk_odc disease_annotation_model.damo_dat_zdb_id disease_annotation.dat_zdb_id Cascade on delete 
damo_genox_zdb_id_fk_odc disease_annotation_model.damo_genox_zdb_id fish_experiment.genox_zdb_id Cascade on delete 
dat_evidence_term_zdb_id_fk disease_annotation.dat_evidence_term_zdb_id term.term_zdb_id Restrict delete 
dat_source_zdb_id_foreign_key disease_annotation.dat_source_zdb_id zdb_active_source.zactvs_zdb_id Restrict delete 
dat_term_zdb_id_foreign_key disease_annotation.dat_term_zdb_id term.term_zdb_id Restrict delete 
dat_zdb_id_foreign_key_odc disease_annotation.dat_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
dblink_fdbcont_zdb_id_foreign_key_odc db_link.dblink_fdbcont_zdb_id foreign_db_contains.fdbcont_zdb_id Cascade on delete 
dblink_linked_recid_zactvd_zdb_id_foreign_key db_link.dblink_linked_recid zdb_active_data.zactvd_zdb_id Cascade on delete 
dblink_zdb_id_foreign_key db_link.dblink_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
dnote_curator_zdb_id_foreign_key data_note.dnote_curator_zdb_id person.zdb_id Restrict delete 
dnote_data_zdb_id_foreign_key data_note.dnote_data_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
dnote_zdb_id_foreign_key data_note.dnote_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
doi_attempts_pub_zdb_id_foreign_key doi_attempts.doia_pub_zdb_id publication.zdb_id Cascade on delete 
efs_xpatex_zdb_id_fk_odc expression_figure_stage.efs_xpatex_zdb_id expression_experiment2.xpatex_zdb_id Cascade on delete 
egm_eco_term_zdb_id_fk eco_go_mapping.egm_term_zdb_id term.term_zdb_id Cascade on delete 
ep_entrez_acc_num_foreign_key_odc entrez_to_protein.ep_entrez_acc_num entrez_gene.eg_acc_num Cascade on delete 
ept_term_foreign_key_odc expression_phenotype_term.ept_quality_term_zdb_id term.term_zdb_id Cascade on delete 
ept_xpatres_foreign_key_odc expression_phenotype_term.ept_xpatres_id expression_result2.xpatres_pk_id Cascade on delete 
evidence_code_fk sequence_feature_chromosome_location.sfcl_evidence_code term.term_zdb_id Restrict delete 
ex_entrez_acc_num_foreign_key_odc entrez_to_xref.ex_entrez_acc_num entrez_gene.eg_acc_num Cascade on delete 
exp_source_zdb_id_foreign_key_odc experiment.exp_source_zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
exp_zdb_id_foreign_key_odc experiment.exp_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
expcond_ao_term_zdb_id_fk experiment_condition.expcond_ao_term_zdb_id term.term_zdb_id Restrict delete 
expcond_chebi_term_zdb_id_fk experiment_condition.expcond_chebi_term_zdb_id term.term_zdb_id Restrict delete 
expcond_go_cc_term_zdb_id_fk experiment_condition.expcond_go_cc_term_zdb_id term.term_zdb_id Restrict delete 
expcond_spatial_term_zdb_id_fk experiment_condition.expcond_spatial_term_zdb_id term.term_zdb_id Restrict delete 
expcond_taxon_term_zdb_id_fk experiment_condition.expcond_taxon_term_zdb_id term.term_zdb_id Restrict delete 
expcond_zdb_id_fk_odc experiment_condition.expcond_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
experiment_condition_restricted_cdt_foreign_key experiment_condition_restricted.ecr_cdt_zdb_id condition_data_type.cdt_zdb_id Restrict delete 
experiment_condition_restricted_chebi_term_foreign_key experiment_condition_restricted.ecr_chebi_term_zdb_id term.term_zdb_id Restrict delete 
experiment_condition_restricted_exp_foreign_key experiment_condition_restricted.ecr_exp_zdb_id experiment.exp_zdb_id Restrict delete 
experiment_zdb_id_foreign_key experiment_condition.expcond_exp_zdb_id experiment.exp_zdb_id Cascade on delete 
expression_experiment2_dblink_foreign_key expression_experiment2.xpatex_dblink_zdb_id db_link.dblink_zdb_id Restrict delete 
expression_experiment2_probe_feature_foreign_key expression_experiment2.xpatex_probe_feature_zdb_id marker.mrkr_zdb_id Cascade on delete 
expression_experiment2_source_foreign_key expression_experiment2.xpatex_source_zdb_id publication.zdb_id Cascade on delete 
expression_experiment2_zdb_active_data_foreign_key expression_experiment2.xpatex_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
exref_attype_type_foreign_key external_reference.exref_attype_type attribution_type.attype_type Cascade on delete 
exref_data_zdb_id_foreign_key external_reference.exref_data_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
exref_foreign_db_id_foreign_key external_reference.exref_foreign_db_id foreign_db.fdb_db_pk_id Cascade on delete 
external_note_type_foreign_key external_note.extnote_note_type external_note_type.extntype_name Restrict delete 
extnote_data_zdb_id_foreign_key external_note.extnote_data_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
extnote_zdb_id_foreign_key external_note.extnote_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
fcc_feature_zdb_id_foreign_key feature_community_contribution.fcc_feature_zdb_id feature.feature_zdb_id Cascade on delete 
fcc_person_fk_odc feature_community_contribution.fcc_added_by person.zdb_id Cascade on delete 
fdbcdgm_group_id_foreign_key_odc foreign_db_contains_display_group_member.fdbcdgm_group_id foreign_db_contains_display_group.fdbcdg_pk_id Cascade on delete 
fdbcont_fdb_db_id_foriegn_key foreign_db_contains.fdbcont_fdb_db_id foreign_db.fdb_db_pk_id Restrict delete 
fdbcont_fdbdt_id_foreign_key foreign_db_contains.fdbcont_fdbdt_id foreign_db_data_type.fdbdt_pk_id Restrict delete 
fdbcont_primary_blastdb_zdb_id_foreign_key foreign_db_contains.fdbcont_primary_blastdb_zdb_id blast_database.blastdb_zdb_id Restrict delete 
fdmd_fdbcont_zdb_id_foreign_key feature_dna_mutation_detail.fdmd_fdbcont_zdb_id foreign_db_contains.fdbcont_zdb_id Restrict delete 
fdmd_feature_zdb_id_foreign_key feature_dna_mutation_detail.fdmd_feature_zdb_id feature.feature_zdb_id Restrict delete 
fdmd_mdcv_fk feature_dna_mutation_detail.fdmd_dna_mutation_term_zdb_id mutation_detail_controlled_vocabulary.mdcv_term_zdb_id Restrict delete 
fdmd_zdb_id_fk_odc feature_dna_mutation_detail.fdmd_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
featassay_feature_zdb_id_fk feature_assay.featassay_feature_zdb_id feature.feature_zdb_id Cascade on delete 
feature_lab_prefix_id_foreign_key feature.feature_lab_prefix_id feature_prefix.fp_pk_id Cascade on delete 
feature_protein_mutation_detail_zdb_active_data_fk_odc feature_protein_mutation_detail.fpmd_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
feature_type_foreign_key feature.feature_type feature_type.ftrtype_name Restrict delete 
feature_type_group_member_type_foreign_key feature_type_group_member.ftrgrpmem_ftr_type feature_type.ftrtype_name Restrict delete 
feature_zactvd_zdb_id_foreign_key_odc feature.feature_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
fgmd_feature_fk_odc feature_genomic_mutation_detail.fgmd_feature_zdb_id feature.feature_zdb_id Cascade on delete 
fgmd_zdb_id_fk_odc feature_genomic_mutation_detail.fgmd_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
fhist_dalias_zdb_id_foreign_key feature_history.fhist_dalias_zdb_id data_alias.dalias_zdb_id Restrict delete 
fhist_event_foreign_key feature_history.fhist_event marker_history_event.mhistvnt_name Restrict delete 
fhist_ftr_zdb_id_foreign_key_odc feature_history.fhist_ftr_zdb_id feature.feature_zdb_id Cascade on delete 
fhist_reason_foreign_key feature_history.fhist_reason marker_history_reason.mhistrsn_name Restrict delete 
fhist_zdb_id_foreign_key_odc feature_history.fhist_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
figure_source_foreign_key_odc figure.fig_source_zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
fish_experiment_experiment_foreign_key fish_experiment.genox_exp_zdb_id experiment.exp_zdb_id Cascade on delete 
fish_genotype_zdb_id_foreign_key_odc fish.fish_genotype_zdb_id genotype.geno_zdb_id Cascade on delete 
fish_zdb_active_data_foreign_key_odc fish.fish_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
fishstr_fish_zdb_id_foreign_key_odc fish_str.fishstr_fish_zdb_id fish.fish_zdb_id Cascade on delete 
fishstr_str_zdb_id_foreign_key_odc fish_str.fishstr_str_zdb_id marker.mrkr_zdb_id Cascade on delete 
fkllaf9w93qaiooguo8mfvwtwbg post_aud.rev revinfo.rev Restrict delete 
fli_inst_foreign_key fest_lib_inst.fli_inst geneprefix_institution.gpi_institution Restrict delete 
fmrel_ftr_zdb_id_foreign_key feature_marker_relationship.fmrel_ftr_zdb_id feature.feature_zdb_id Cascade on delete 
fmrel_mrkr_zdb_id_foreign_key feature_marker_relationship.fmrel_mrkr_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
fmrel_type_foreign_key feature_marker_relationship.fmrel_type feature_marker_relationship_type.fmreltype_name Restrict delete 
fmrel_zdb_id_foreign_key feature_marker_relationship.fmrel_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
fmreltype_ftr_type_group_ftr_foreign_key feature_marker_relationship_type.fmreltype_ftr_type_group feature_type_group.ftrgrp_name Restrict delete 
fmreltype_ftr_type_group_mrkr_foreign_key feature_marker_relationship_type.fmreltype_mrkr_type_group marker_type_group.mtgrp_name Restrict delete 
foreign_db_contains_organism_foreign_key foreign_db_contains.fdbcont_organism_common_name organism.organism_common_name Restrict delete 
fpmd_fdbcont_zdb_id_fk_constraint feature_protein_mutation_detail.fpmd_fdbcont_zdb_id foreign_db_contains.fdbcont_zdb_id Restrict delete 
fpmd_feature_zdb_id_fk_constraint feature_protein_mutation_detail.fpmd_feature_zdb_id feature.feature_zdb_id Restrict delete 
fpmd_mdcv_fk feature_protein_mutation_detail.fpmd_protein_consequence_term_zdb_id mutation_detail_controlled_vocabulary.mdcv_term_zdb_id Restrict delete 
ftmd_feature_zdb_id_fk_odc feature_transcript_mutation_detail.ftmd_feature_zdb_id feature.feature_zdb_id Cascade on delete 
ftmd_mdcv_fk feature_transcript_mutation_detail.ftmd_transcript_consequence_term_zdb_id mutation_detail_controlled_vocabulary.mdcv_term_zdb_id Restrict delete 
ftmd_zdb_id_fk_odc feature_transcript_mutation_detail.ftmd_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
ftmgm_feature_type_foreign_key_odc feature_type_mutagen_group_member.ftmgm_feature_type feature_type.ftrtype_name Cascade on delete 
ftmgm_mutagen_foreign_key_odc feature_type_mutagen_group_member.ftmgm_mutagen mutagen.mutagen_name Cascade on delete 
ftrgrpmem_ftr_type_group_foreign_key feature_type_group_member.ftrgrpmem_ftr_type_group feature_type_group.ftrgrp_name Restrict delete 
fx_figure_zdb_id_active_data_foreign_key figure.fig_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
gcs_fmrel_type_foreign_key genotype_component_significance.gcs_fmrel_type feature_marker_relationship_type.fmreltype_name Restrict delete 
gcs_ftr_type_foreign_key genotype_component_significance.gcs_ftr_type feature_type.ftrtype_name Restrict delete 
gd_gene_zdb_id_fk_odc gene_description.gd_gene_zdb_id marker.mrkr_zdb_id Cascade on delete 
genedom_family_member_gfam_name_foreign_key genedom_family_member.gfammem_gfam_name genedom_family_name.gfam_name Restrict delete 
genedom_family_member_mrkr_zdb_id_foreign_key_odc genedom_family_member.gfammem_mrkr_zdb_id marker.mrkr_zdb_id Cascade on delete 
genofeat_dad_zygocity_foreign_key genotype_feature.genofeat_dad_zygocity zygocity.zyg_zdb_id Restrict delete 
genofeat_feature_foreign_key_odc genotype_feature.genofeat_feature_zdb_id feature.feature_zdb_id Cascade on delete 
genofeat_geno_foreign_key_odc genotype_feature.genofeat_geno_zdb_id genotype.geno_zdb_id Cascade on delete 
genofeat_mom_zygocity_foreign_key genotype_feature.genofeat_mom_zygocity zygocity.zyg_zdb_id Restrict delete 
genofeat_zdb_active_data_foreign_key genotype_feature.genofeat_zdb_id zdb_active_data.zactvd_zdb_id Restrict delete 
genofeat_zygocity_foreign_key genotype_feature.genofeat_zygocity zygocity.zyg_zdb_id Restrict delete 
genotype_background_background_foreign_key_odc genotype_background.genoback_background_zdb_id genotype.geno_zdb_id Cascade on delete 
genotype_background_geno_foreign_key_odc genotype_background.genoback_geno_zdb_id genotype.geno_zdb_id Cascade on delete 
genotype_experiment_genox_foregin_key_odc fish_experiment.genox_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
genotype_zdb_active_data_foreign_key_odc genotype.geno_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
genox_fish_zdb_id_foreign_key_odc fish_experiment.genox_fish_zdb_id fish.fish_zdb_id Cascade on delete 
gffs_fig_zdb_id_foreign_key genotype_figure_fast_search.gffs_fig_zdb_id figure.fig_zdb_id Cascade on delete 
gffs_fish_zdb_id_foreign_key genotype_figure_fast_search.gffs_fish_zdb_id fish.fish_zdb_id Cascade on delete 
gffs_geno_zdb_id_foreign_key genotype_figure_fast_search.gffs_geno_zdb_id genotype.geno_zdb_id Cascade on delete 
gffs_morph_zdb_id_foreign_key genotype_figure_fast_search.gffs_morph_zdb_id marker.mrkr_zdb_id Cascade on delete 
goterm_ontology_foreign_key go_term.goterm_ontology go_ontology.gont_ontology_name Restrict delete 
goterm_zdb_id_foreign_key go_term.goterm_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
hd_zdb_id_fk_odc htp_dataset.hd_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
hdct_category_tag_fk htp_dataset_category_tag.hdct_category_tag htp_category_tag.hct_zdb_id Restrict delete 
hdct_dataset_zdb_id_fk htp_dataset_category_tag.hdct_dataset_zdb_id htp_dataset.hd_zdb_id Restrict delete 
hdp_dataset_zdb_id_fk htp_dataset_publication.hdp_dataset_zdb_id htp_dataset.hd_zdb_id Cascade on delete 
hdp_pub_zdb_id_fk htp_dataset_publication.hdp_pub_zdb_id publication.zdb_id Cascade on delete 
hds_fish_zdb_id_fk_odc htp_dataset_sample.hds_fish_zdb_id fish.fish_zdb_id Cascade on delete 
hds_hd_zdb_id_fk_odc htp_dataset_sample.hds_hd_zdb_id htp_dataset.hd_zdb_id Cascade on delete 
hds_stage_term_zdb_id_fk_odc htp_dataset_sample.hds_stage_term_zdb_id term.term_zdb_id Restrict delete 
hdsd_anatomy_sub_term_qualifier_zdb_id_fk htp_dataset_sample_detail.hdsd_anatomy_sub_term_qualifier_zdb_id term.term_zdb_id Restrict delete 
hdsd_anatomy_sub_term_zdb_id_fk htp_dataset_sample_detail.hdsd_anatomy_sub_term_zdb_id term.term_zdb_id Restrict delete 
hdsd_anatomy_super_term_qualifier_zdb_id_fk htp_dataset_sample_detail.hdsd_anatomy_super_term_qualifier_zdb_id term.term_zdb_id Restrict delete 
hdsd_anatomy_super_term_zdb_id_fk htp_dataset_sample_detail.hdsd_anatomy_super_term_zdb_id term.term_zdb_id Restrict delete 
hdsd_cellular_component_qualifier_term_zdb_id_fk htp_dataset_sample_detail.hdsd_cellular_component_term_qualifier_zdb_id term.term_zdb_id Restrict delete 
hdsd_cellular_component_term_zdb_id_fk htp_dataset_sample_detail.hdsd_cellular_component_term_zdb_id term.term_zdb_id Restrict delete 
ids_data_zdb_id_foreign_key int_data_source.ids_data_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
ids_source_zdb_id_foreign_key int_data_source.ids_source_zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
idsup_data_zdb_id_foreign_key int_data_supplier.idsup_data_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
idsup_supplier_zdb_id_foreign_key int_data_supplier.idsup_supplier_zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
ifat_blastdb_foreign_key_odc int_fdbcont_analysis_tool.ifat_blastdb_zdb_id blast_database.blastdb_zdb_id Cascade on delete 
ifgrmem_mrkrgoev_zdb_id_foreign_key_odc inference_group_member.infgrmem_mrkrgoev_zdb_id marker_go_term_evidence.mrkrgoev_zdb_id Cascade on delete 
iit_img_zdb_id_foreign_key int_image_term.iit_img_zdb_id image.img_zdb_id Restrict delete 
iit_term_zdb_id_foreign_key int_image_term.iit_term_zdb_id term.term_zdb_id Restrict delete 
image_fig_foreign_key_odc image.img_fig_zdb_id figure.fig_zdb_id Cascade on delete 
img_direction_foreign_key image.img_direction image_direction.imgdir_name Restrict delete 
img_form_foreign_key image.img_form image_form.imgform_name Restrict delete 
img_owner_zdb_id_foreign_key image.img_owner_zdb_id person.zdb_id Restrict delete 
img_preparation_foreign_key image.img_preparation image_preparation.imgprep_name Restrict delete 
img_view_foreign_key image.img_view image_view.imgview_name Restrict delete 
img_zdb_id_foreign_key_odc image.img_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
imgstg_end_stg_zdb_id_foregin_key image_stage.imgstg_end_stg_zdb_id stage.stg_zdb_id Restrict delete 
imgstg_img_zdb_id_foregin_key image_stage.imgstg_img_zdb_id image.img_zdb_id Cascade on delete 
imgstg_start_stg_zdb_id_foregin_key image_stage.imgstg_start_stg_zdb_id stage.stg_zdb_id Restrict delete 
int_person_company_position_foreign_key int_person_company.position_id company_position.compos_pk_id Restrict delete 
int_person_company_source_id_foreign_key int_person_company.source_id person.zdb_id Cascade on delete 
int_person_company_target_id_foreign_key int_person_company.target_id company.zdb_id Cascade on delete 
int_person_lab_position_foreign_key int_person_lab.position_id lab_position.labpos_pk_id Restrict delete 
int_person_lab_source_id_foreign_key int_person_lab.source_id person.zdb_id Cascade on delete 
int_person_lab_target_id_foreign_key int_person_lab.target_id lab.zdb_id Cascade on delete 
int_person_pub_source_id_foreign_key int_person_pub.source_id person.zdb_id Cascade on delete 
int_person_pub_target_id_foreign_key int_person_pub.target_id publication.zdb_id Cascade on delete 
interpro_protein_zdb_active_data_fk_odc interpro_protein.ip_interpro_id zdb_active_data.zactvd_zdb_id Cascade on delete 
ivtst_tscriptt_type_id_foreign_key int_vegatype_tscripttype.ivtst_tscriptt_type_id transcript_type.tscriptt_pk_id Restrict delete 
journal_zdb_active_source_foreign_key journal.jrnl_zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
lab_contact_person_foreign_key lab.contact_person person.zdb_id Restrict delete 
lab_owner_foreign_key lab.owner person.zdb_id Restrict delete 
lab_zdb_id_foreign_key lab.zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
laut_lab_zdb_id_foreign_key lab_address_update_tracking.laut_lab_zdb_id lab.zdb_id Cascade on delete 
lms_lnkg_zdb_id_fk_zdb_active_data linkage_membership_search.lms_lnkg_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
lms_member_1_zdb_id_fk_zdb_active_data linkage_membership_search.lms_member_1_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
lms_member_2_zdb_id_fk_zdb_active_data linkage_membership_search.lms_member_2_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
lnkg_lnkg_zdb_id_foreign_key linkage_old.lnkg_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
lnkg_or_lg_foreign_key linkage_old.lnkg_or_lg linkage_group.lg_name Restrict delete 
lnkg_submitter_zdb_id_foreign_key linkage_old.lnkg_submitter_zdb_id person.zdb_id Restrict delete 
lnkgm_member_1_zdb_id_foreign_key linkage_membership.lnkgm_member_1_zdb_id zdb_active_data.zactvd_zdb_id Restrict delete 
lnkgm_member_2_zdb_id_foreign_key linkage_membership.lnkgm_member_2_zdb_id zdb_active_data.zactvd_zdb_id Restrict delete 
lnkgmem_linkage_zdb_id_foreign_key linkage_member.lnkgmem_linkage_zdb_id linkage_old.lnkg_zdb_id Cascade on delete 
lnkgpair_linkage_zdb_id_foreign_key linkage_pair.lnkgpair_linkage_zdb_id linkage_old.lnkg_zdb_id Cascade on delete 
lnkgpair_metric_foreign_key linkage_pair.lnkgpair_metric map_metric.mapmetric_code Restrict delete 
lnkgs_chromosome_foreign_key linkage.lnkg_chromosome linkage_group.lg_name Restrict delete 
lnkgs_lnkg_zdb_id_foreign_key linkage.lnkg_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
lnkgs_submitter_zdb_id_foreign_key linkage.lnkg_submitter_zdb_id person.zdb_id Restrict delete 
lpmem_linkage_member_foreign_key linkage_pair_member.lpmem_linkage_zdb_id
linkage_pair_member.lpmem_member_zdb_id
linkage_member.lnkgmem_linkage_zdb_id
linkage_member.lnkgmem_member_zdb_id
Restrict delete 
lpmem_linkage_pair_zdb_id_foreign_key linkage_pair_member.lpmem_linkage_pair_zdb_id linkage_pair.lnkgpair_zdb_id Cascade on delete 
lsingle_lnkg_zdb_id_foreign_key linkage_single.lsingle_lnkg_zdb_id linkage.lnkg_zdb_id Cascade on delete 
lsingle_member_zdb_id_foreign_key linkage_single.lsingle_member_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
mappanel_metric_foreign_key panels.metric map_metric.mapmetric_code Restrict delete 
mappanel_owner_foreign_key panels.owner person.zdb_id Restrict delete 
mappanel_producer_foreign_key panels.producer person.zdb_id Restrict delete 
mapped_marker_chromosome_foreign_key mapped_marker.mm_chromosome chromosome.chrom_name Restrict delete 
mapped_marker_metric_foreign_key mapped_marker.metric map_metric.mapmetric_code Restrict delete 
marker_go_term_evidence_zdb_active_data_id_foreign_key marker_go_term_evidence.mrkrgoev_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
marker_to_protein_uniprot_id marker_to_protein.mtp_uniprot_id protein.up_uniprot_id Cascade on delete 
mdcv_term_zdb_id_fk mutation_detail_controlled_vocabulary.mdcv_term_zdb_id term.term_zdb_id Restrict delete 
mesh_heading_descriptor_foreign_key mesh_heading.mh_mesht_mesh_descriptor_id mesh_term.mesht_mesh_id Cascade on delete 
mesh_heading_pub_foreign_key_odc mesh_heading.mh_pub_zdb_id publication.zdb_id Cascade on delete 
mgtae_extension_group_id_fk_odc marker_go_term_annotation_extension.mgtae_extension_group_id marker_go_term_annotation_extension_group.mgtaeg_annotation_extension_group_id Cascade on delete 
mgtae_relationship_term_zdb_id_fk_odc marker_go_term_annotation_extension.mgtae_relationship_term_zdb_id term.term_zdb_id Cascade on delete 
mgtaeg_fk_odc marker_go_term_annotation_extension_group.mgtaeg_mrkrgoev_zdb_id marker_go_term_evidence.mrkrgoev_zdb_id Cascade on delete 
mha_mrkr_zdb_id_foreign_key marker_history_audit.mha_mrkr_zdb_id marker.mrkr_zdb_id Cascade on delete 
mhist_dalias_zdb_id_foreign_key marker_history.mhist_dalias_zdb_id data_alias.dalias_zdb_id Restrict delete 
mhist_event_foreign_key marker_history.mhist_event marker_history_event.mhistvnt_name Restrict delete 
mhist_mrkr_zdb_id_foreign_key marker_history.mhist_mrkr_zdb_id marker.mrkr_zdb_id Cascade on delete 
mhist_reason_foreign_key marker_history.mhist_reason marker_history_reason.mhistrsn_name Restrict delete 
mhist_zdb_id_foreign_key marker_history.mhist_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
mhq_mesh_heading_id_foreign_key_odc mesh_heading_qualifier.mhq_mesh_heading_id mesh_heading.mh_pk_id Cascade on delete 
mhq_mesht_mesh_qualifier_id_foreign_key_odc mesh_heading_qualifier.mhq_mesht_mesh_qualifier_id mesh_term.mesht_mesh_id Cascade on delete 
mm_marker_id_foreign_key mapped_marker.marker_id zdb_active_data.zactvd_zdb_id Cascade on delete 
mm_refcross_id_foreign_key mapped_marker.refcross_id zdb_active_data.zactvd_zdb_id Cascade on delete 
mrel_mrkr_1_zdb_id_foreign_key marker_relationship.mrel_mrkr_1_zdb_id marker.mrkr_zdb_id Cascade on delete 
mrel_mrkr_2_zdb_id_foreign_key marker_relationship.mrel_mrkr_2_zdb_id marker.mrkr_zdb_id Cascade on delete 
mrel_type_foreign_key marker_relationship.mrel_type marker_relationship_type.mreltype_name Restrict delete 
mrel_zdb_id_foreign_key marker_relationship.mrel_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
mreltype_mrkr_type_group_1_foreign_key marker_relationship_type.mreltype_mrkr_type_group_1 marker_type_group.mtgrp_name Restrict delete 
mreltype_mrkr_type_group_2_foreign_key marker_relationship_type.mreltype_mrkr_type_group_2 marker_type_group.mtgrp_name Restrict delete 
mrkr_owner_foreign_key marker.mrkr_owner person.zdb_id Restrict delete 
mrkr_type_foreign_key marker.mrkr_type marker_types.marker_type Restrict delete 
mrkr_zdb_id_foreign_key marker.mrkr_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
mrkrgoev_annotation_organization_foreign_key marker_go_term_evidence.mrkrgoev_annotation_organization marker_go_term_evidence_annotation_organization.mrkrgoevas_pk_id Restrict delete 
mrkrgoev_contributed_by_fk marker_go_term_evidence.mrkrgoev_contributed_by person.zdb_id Restrict delete 
mrkrgoev_gflag_name_foreign_key marker_go_term_evidence.mrkrgoev_gflag_name go_flag.gflag_name Restrict delete 
mrkrgoev_modified_by_fk marker_go_term_evidence.mrkrgoev_modified_by person.zdb_id Restrict delete 
mrkrgoev_mrkr_zdb_id_foreign_key marker_go_term_evidence.mrkrgoev_mrkr_zdb_id marker.mrkr_zdb_id Cascade on delete 
mrkrgoev_protein_dblink_id_fk_odc marker_go_term_evidence.mrkrgoev_protein_dblink_zdb_id db_link.dblink_zdb_id Cascade on delete 
mrkrgoev_relation_term_zdb_id_fk_odc marker_go_term_evidence.mrkrgoev_relation_term_zdb_id term.term_zdb_id Restrict delete 
mrkrgoev_source_zdb_id_foreign_key marker_go_term_evidence.mrkrgoev_source_zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
mrkrgoev_term_zdb_id_foreign_key marker_go_term_evidence.mrkrgoev_term_zdb_id term.term_zdb_id Cascade on delete 
mrkrseq2_mrkr_zdb_id_foreign_key_odc marker_sequence.seq_mrkr_zdb_id marker.mrkr_zdb_id Cascade on delete 
mrkrseq2_seq_type_foreign_key marker_sequence.seq_type sequence_type.seqtype_name Restrict delete 
mrkrseq2_variation_foreign_key snp_sequence.seq_variation sequence_ambiguity_code.seqac_meaning Restrict delete 
mtgrpmem_mrkr_type_fk marker_type_group_member.mtgrpmem_mrkr_type marker_types.marker_type Restrict delete 
mtgrpmem_mrkr_type_group_foreign_key marker_type_group_member.mtgrpmem_mrkr_type_group marker_type_group.mtgrp_name Restrict delete 
mutant_fast_search_data_zdb_id_foreign_key_odc mutant_fast_search.mfs_data_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
mutant_fast_search_genox_zdb_id_foreign_key_odc mutant_fast_search.mfs_genox_zdb_id fish_experiment.genox_zdb_id Cascade on delete 
nma_mrkrgoev_fk_odc noctua_model_annotation.nma_mrkrgoev_zdb_id marker_go_term_evidence.mrkrgoev_zdb_id Cascade on delete 
noa_ncbi_gene_id_fk ncbi_ortholog_alias.noa_ncbi_gene_id ncbi_ortholog.noi_ncbi_gene_id Restrict delete 
noer_fdbcont_zdb_id_fk_odc ncbi_ortholog_external_reference.noer_fdbcont_zdb_id foreign_db_contains.fdbcont_zdb_id Cascade on delete 
noer_other_species_ncbi_gene_id_fk_odc ncbi_ortholog_external_reference.noer_other_species_ncbi_gene_id ncbi_ortholog.noi_ncbi_gene_id Cascade on delete 
noi_taxid_foreign_key ncbi_ortholog.noi_taxid organism.organism_taxid Restrict delete 
nzrepld_new_zdb_id_foreign_key zdb_replaced_data.zrepld_new_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
obstermrep_term_replacement_zdb_id_foreign_key obsolete_term_replacement.obstermrep_term_replacement_zdb_id term.term_zdb_id Cascade on delete 
obstermrep_term_zdb_id_foreign_key obsolete_term_replacement.obstermrep_term_zdb_id term.term_zdb_id Cascade on delete 
obstermsug_term_suggestion_zdb_id_foreign_key obsolete_term_suggestion.obstermsug_term_suggestion_zdb_id term.term_zdb_id Cascade on delete 
obstermsug_term_zdb_id_foreign_key obsolete_term_suggestion.obstermsug_term_zdb_id term.term_zdb_id Cascade on delete 
oef_fdbcont_zdb_id_fk_odc ortholog_external_reference.oef_fdbcont_zdb_id foreign_db_contains.fdbcont_zdb_id Cascade on delete 
oef_ortho_zdb_id_fk_odc ortholog_external_reference.oef_ortho_zdb_id ortholog.ortho_zdb_id Cascade on delete 
oevn_evidence_code_foreign_key ortholog_evidence.oev_evidence_code ortholog_evidence_code.oevcode_code Restrict delete 
oevn_ortho_zdb_id_foreign_key ortholog_evidence.oev_ortho_zdb_id ortholog.ortho_zdb_id Cascade on delete 
oevn_pub_zdb_id_foreign_key ortholog_evidence.oev_pub_zdb_id publication.zdb_id Cascade on delete 
omim_phenotype_human_gene_id_fk omim_phenotype.omimp_human_gene_id human_gene_detail.hgd_gene_id Cascade on delete 
omimp_foreign_key_odc omimp_termxref_mapping.otm_omimp_id omim_phenotype.omimp_pk_id Cascade on delete 
omimp_ortho_zdb_id_fk_odc omim_phenotype.omimp_ortho_zdb_id ortholog.ortho_zdb_id Cascade on delete 
ooa_dblink_zdb_id_foreign_key one_to_one_accession.ooa_dblink_zdb_id db_link.dblink_zdb_id Restrict delete 
ooa_feature_zdb_id_foreign_key one_to_one_accession.ooa_feature_zdb_id feature.feature_zdb_id Restrict delete 
ortho_zdb_id_active_data_foreign_key_odc ortholog.ortho_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
ortholog_gene_zdb_id_fk_odc ortholog.ortho_zebrafish_gene_zdb_id marker.mrkr_zdb_id Cascade on delete 
owner_person_zdb_id_foreign_key_odc mapped_marker.owner person.zdb_id Restrict delete 
panelcnt_chromosome_foreign_key panel_count.panelcnt_chromosome chromosome.chrom_name Cascade on delete 
panelcnt_or_lg_foreign_key panel_count.panelcnt_or_lg linkage_group.lg_name Cascade on delete 
panelcnt_panel_zdb_id_foreign_key panel_count.panelcnt_panel_zdb_id panels.zdb_id Cascade on delete 
paneled_markers_zdb_id_fk_odc paneled_markers.zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
pct_curator_zdb_id_foreign_key publication_contact_tracking.pct_curator_zdb_id person.zdb_id Cascade on delete 
pct_pub_zdb_id_foreign_key publication_contact_tracking.pct_pub_zdb_id publication.zdb_id Cascade on delete 
pdx_db_xref_fdbcont_fk pub_db_xref.pdx_fdbcont_zdb_id foreign_db_contains.fdbcont_zdb_id Restrict delete 
persauth_author_id_fk person_author.persauth_author_id author.author_pk_id Restrict delete 
persauth_connected_by_fk person_author.persauth_connected_by person.zdb_id Restrict delete 
persauth_person_zdb_id_fk person_author.persauth_person_zdb_id person.zdb_id Restrict delete 
person_zdb_id_foreign_key person.zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
pf_file_type_id_foreign_key publication_file.pf_file_type_id publication_file_type.pft_pk_id Restrict delete 
pf_pub_zdb_id_fk_odc publication_file.pf_pub_zdb_id publication.zdb_id Cascade on delete 
phenos_entity_1_subterm_zdb_id_fk_odc apato_infrastructure.api_entity_1_subterm_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
phenos_entity_1_subterm_zdb_id_foreign_key phenotype_statement.phenos_entity_1_subterm_zdb_id term.term_zdb_id Restrict delete 
phenos_entity_1_superterm_zdb_id_fk_odc apato_infrastructure.api_entity_1_superterm_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
phenos_entity_1_superterm_zdb_id_foreign_key phenotype_statement.phenos_entity_1_superterm_zdb_id term.term_zdb_id Restrict delete 
phenos_entity_2_subterm_zdb_id_fk_odc apato_infrastructure.api_entity_2_subterm_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
phenos_entity_2_subterm_zdb_id_foreign_key phenotype_statement.phenos_entity_2_subterm_zdb_id term.term_zdb_id Restrict delete 
phenos_entity_2_superterm_zdb_id_fk_odc apato_infrastructure.api_entity_2_superterm_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
phenos_entity_2_superterm_zdb_id_foreign_key phenotype_statement.phenos_entity_2_superterm_zdb_id term.term_zdb_id Restrict delete 
phenos_phenox_id_foreign_key phenotype_statement.phenos_phenox_pk_id phenotype_experiment.phenox_pk_id Restrict delete 
phenos_quality_foreign_key phenotype_statement.phenos_quality_zdb_id term.term_zdb_id Restrict delete 
phenos_tag_foreign_key phenotype_statement.phenos_tag apato_tag.apatotag_name Restrict delete 
phenox_end_stg_foreign_key_odc phenotype_experiment.phenox_end_stg_zdb_id stage.stg_zdb_id Cascade on delete 
phenox_fig_foreign_key_odc phenotype_experiment.phenox_fig_zdb_id figure.fig_zdb_id Cascade on delete 
phenox_genox_foreign_key_odc phenotype_experiment.phenox_genox_zdb_id fish_experiment.genox_zdb_id Cascade on delete 
phenox_start_stg_foreign_key_odc phenotype_experiment.phenox_start_stg_zdb_id stage.stg_zdb_id Cascade on delete 
pnote_curator_zdb_id_foreign_key publication_note.pnote_curator_zdb_id person.zdb_id Restrict delete 
pnote_pub_zdb_id_foreign_key publication_note.pnote_pub_zdb_id publication.zdb_id Cascade on delete 
pnote_zdb_id_foreign_key publication_note.pnote_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
ppa_publication_fk pubmed_publication_author.ppa_publication_zdb_id publication.zdb_id Cascade on delete 
ppc_person_zdb_id_fk publication_processing_checklist.ppc_person_zdb_id person.zdb_id Restrict delete 
ppc_pub_zdb_id_fk publication_processing_checklist.ppc_pub_zdb_id publication.zdb_id Restrict delete 
ppc_task_id_fk publication_processing_checklist.ppc_task_id processing_checklist_task.pct_pk_id Restrict delete 
primer_set_marker_id_foreign_key_odc primer_set.marker_id marker.mrkr_zdb_id Cascade on delete 
primerset_strain_id_foreign_key primer_set.strain_id genotype.geno_zdb_id Restrict delete 
probelib_species_foreign_key probe_library.probelib_species organism.organism_species Restrict delete 
probelib_stg_zdb_id_foreign_key probe_library.probelib_stg_zdb_id stage.stg_zdb_id Restrict delete 
probelib_strain_foreign_key_odc probe_library.probelib_strain_zdb_id genotype.geno_zdb_id Cascade on delete 
probelib_tissue_zdb_id_foreign_key probe_library.probelib_tissue_zdb_id term.term_zdb_id Restrict delete 
probelib_zdb_id_foreign_key probe_library.probelib_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
protein_fdbcont_zdb_id_fk protein.up_fdbcont_zdb_id foreign_db_contains.fdbcont_zdb_id Restrict delete 
protein_to_interpro_interpro_id protein_to_interpro.pti_interpro_id interpro_protein.ip_interpro_id Cascade on delete 
protein_to_interpro_uniprot_id protein_to_interpro.pti_uniprot_id protein.up_uniprot_id Cascade on delete 
protein_to_pdb_uniprot_id protein_to_pdb.ptp_uniprot_id protein.up_uniprot_id Cascade on delete 
protein_zdb_active_data_fk_odc protein.up_uniprot_id zdb_active_data.zactvd_zdb_id Cascade on delete 
pth_claimed_by_foreign_key pub_tracking_history.pth_claimed_by person.zdb_id Restrict delete 
pth_location_fk pub_tracking_history.pth_location_id pub_tracking_location.ptl_pk_id Restrict delete 
pth_pub_fk_odc pub_tracking_history.pth_pub_zdb_id publication.zdb_id Cascade on delete 
pth_status_fk pub_tracking_history.pth_status_id pub_tracking_status.pts_pk_id Restrict delete 
pth_status_set_by_fk pub_tracking_history.pth_status_set_by person.zdb_id Restrict delete 
pub_correspondence_received_email_from_person_fk pub_correspondence_received_email.pubcre_correspondence_from_person_zdb_id person.zdb_id Restrict delete 
pub_correspondence_received_email_pub_fk_odc pub_correspondence_received_email.pubcre_pub_zdb_id publication.zdb_id Cascade on delete 
pub_correspondence_sent_tracker_pub_zdb_id_fk_odc pub_correspondence_sent_tracker.pubcst_pub_zdb_id publication.zdb_id Cascade on delete 
pub_correspondence_sent_tracker_sent_by_fk pub_correspondence_sent_tracker.pubcst_sent_by person.zdb_id Restrict delete 
pub_correspondence_sent_tracker_sent_email_id_fk pub_correspondence_sent_tracker.pubcst_sent_email_id pub_correspondence_sent_email.pubcse_pk_id Restrict delete 
pub_corresspondence_recipient_person_zdb_id_fk pub_correspondence_recipient.pubcr_recipient_person_zdb_id person.zdb_id Restrict delete 
pub_corresspondence_recipient_sent_email_id_fk pub_correspondence_recipient.pubcr_recipient_sent_email_id pub_correspondence_sent_email.pubcse_pk_id Restrict delete 
pub_db_xref_pub_fk pub_db_xref.pdx_pub_zdb_id publication.zdb_id Restrict delete 
pub_indexer_foreign_key publication.pub_indexed_by person.zdb_id Restrict delete 
pub_journal_foreign_key publication.pub_jrnl_zdb_id journal.jrnl_zdb_id Restrict delete 
pubcorr_curator_zdb_id_foreign_key publication_correspondence.pubcorr_curator_zdb_id person.zdb_id Cascade on delete 
pubcorr_pub_zdb_id_foreign_key publication_correspondence.pubcorr_pub_zdb_id publication.zdb_id Cascade on delete 
pubcse_pub_zdb_id_foreign_key_odc pub_correspondence_sent_email.pubcse_pub_zdb_id publication.zdb_id Cascade on delete 
pubcse_sent_by_foreign_key pub_correspondence_sent_email.pubcse_sent_by person.zdb_id Restrict delete 
publication_zdb_id_foreign_key publication.zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
recattrib_data_zdb_id_foreign_key record_attribution.recattrib_data_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
recattrib_source_type_foreign_key record_attribution.recattrib_source_type attribution_type.attype_type Restrict delete 
rermrel_type_foreign_key_to_term term_relationship.termrel_type term_relationship_type.termreltype_name Restrict delete 
run_nomen_pub_foreign_key_odc run.run_nomen_pub_zdb_id publication.zdb_id Cascade on delete 
run_program_foreign_key run.run_program run_program.runprog_program Restrict delete 
run_relation_pub_foreign_key_odc run.run_relation_pub_zdb_id publication.zdb_id Cascade on delete 
run_type_foreign_key run.run_type run_type.runtype_name Restrict delete 
run_zdb_active_data_foreign_key_odc run.run_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
runcan_cnd_zdb_id_foreign_key_odc run_candidate.runcan_cnd_zdb_id candidate.cnd_zdb_id Cascade on delete 
runcan_run_zdb_id_foreign_key_odc run_candidate.runcan_run_zdb_id run.run_zdb_id Cascade on delete 
salias_source_zdb_id_foreign_key_odc source_alias.salias_source_zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
salias_zdb_id_foreign_key_odc source_alias.salias_zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
sfcl_chromosome_fk_odc sequence_feature_chromosome_location.sfcl_chromosome chromosome.chrom_name Restrict delete 
sfcl_feature_zdb_id_fk_odc sequence_feature_chromosome_location.sfcl_feature_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
sfcl_zdb_id_fk_odc sequence_feature_chromosome_location.sfcl_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
sfclg_zdb_active_data_fk sequence_feature_chromosome_location_generated.sfclg_data_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
sfp_prefix_id_foreign_key source_feature_prefix.sfp_prefix_id feature_prefix.fp_pk_id Cascade on delete 
sfp_source_zdb_id_foreign_key source_feature_prefix.sfp_source_zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
snpd_mrkr_zdb_id_foreign_key_odc snp_download.snpd_mrkr_zdb_id marker.mrkr_zdb_id Cascade on delete 
so_zfin_mapping_term_foreign_key so_zfin_mapping.szm_term_ont_id term.term_ont_id Cascade on delete 
srcurl_purpose_foreign_key source_url.srcurl_purpose source_url_purpose.srcurlpurp_name Restrict delete 
srcurl_source_zdb_id_foreign_key source_url.srcurl_source_zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
stage_active_data_foreign_key stage.stg_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
term_ontology_foreign_key term.term_ontology_id ontology.ont_pk_id Restrict delete 
term_ontology_subset_foreign_key term.term_primary_subset_id ontology_subset.osubset_pk_id Restrict delete 
term_zdb_id_foreign_key term.term_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
termrel_term_1_zdb_id_foreign_key_to_term_odc term_relationship.termrel_term_1_zdb_id term.term_zdb_id Cascade on delete 
termrel_term_2_zdb_id_foreign_key_to_term_odc term_relationship.termrel_term_2_zdb_id term.term_zdb_id Cascade on delete 
termrel_zactvd_foreign_key_odc term_relationship.termrel_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
termsub_subset_id_foreign_key_odc term_subset.termsub_subset_id ontology_subset.osubset_pk_id Cascade on delete 
termsub_term_zdb_id_foreign_key_odc term_subset.termsub_term_zdb_id term.term_zdb_id Cascade on delete 
termxref_mapping_foreign_key_odc omimp_termxref_mapping.otm_tx_id term_xref.tx_pk_id Cascade on delete 
transcript_sequence_transcript_foreign_key transcript_sequence.ts_transcript_zdb_id transcript.tscript_mrkr_zdb_id Cascade on delete 
ts_end_stg_zdb_id_foreign_key term_stage.ts_end_stg_zdb_id stage.stg_zdb_id Restrict delete 
ts_start_stage_zdb_id_foreign_key term_stage.ts_start_stg_zdb_id stage.stg_zdb_id Restrict delete 
tscript_mrkr_zdb_id_foreign_key_odc transcript.tscript_mrkr_zdb_id marker.mrkr_zdb_id Cascade on delete 
tscript_status_foreign_key transcript.tscript_status_id transcript_status.tscripts_pk_id Restrict delete 
tscritp_type_foreign_key transcript.tscript_type_id transcript_type.tscriptt_pk_id Restrict delete 
ttsdef_tscript_status_id_foreign_key_constraint tscript_type_status_definition.ttsdef_tscript_status_id transcript_status.tscripts_pk_id Restrict delete 
ttsdef_tscript_type_id_foreign_key_constraint tscript_type_status_definition.ttsdef_tscript_type_id transcript_type.tscriptt_pk_id Restrict delete 
tx_fdb_db_id_foreign_key term_xref.tx_fdb_db_id foreign_db.fdb_db_pk_id Restrict delete 
tx_term_zdb_id_foreign_key term_xref.tx_term_zdb_id term.term_zdb_id Restrict delete 
urlref_data_zdb_id_foreign_key url_ref.urlref_data_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
variant_sequence_zdb_active_data_foreign_key variant_flanking_sequence.vfseq_data_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
vector_type_name_foreign_key vector.vector_type_name vector_type.vectype_name Restrict delete 
video_image_still_zdb_id_foreign_key video.video_image_still_zdb_id image.img_zdb_id Restrict delete 
xpatex2_assay_foregin_key expression_experiment2.xpatex_assay_name expression_pattern_assay.xpatassay_name Restrict delete 
xpatex2_atb_zdb_id_foreign_key expression_experiment2.xpatex_atb_zdb_id antibody.atb_zdb_id Cascade on delete 
xpatex2_gene_zdb_id_foreign_key expression_experiment2.xpatex_gene_zdb_id marker.mrkr_zdb_id Restrict delete 
xpatex2_genox_foreign_key expression_experiment2.xpatex_genox_zdb_id fish_experiment.genox_zdb_id Restrict delete 
xpatinf_active_data_foreign_key expression_pattern_infrastructure.xpatinf_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
xpatinf_curator_foreign_key expression_pattern_infrastructure.xpatinf_curator_zdb_id zdb_submitters.zdb_id Restrict delete 
xpatinf_pub_foreign_key expression_pattern_infrastructure.xpatinf_pub_zdb_id publication.zdb_id Restrict delete 
xpatinf_subterm_zdb_id_foreign_key expression_pattern_infrastructure.xpatinf_subterm_zdb_id term.term_zdb_id Restrict delete 
xpatinf_superterm_zdb_id_foreign_key expression_pattern_infrastructure.xpatinf_superterm_zdb_id term.term_zdb_id Restrict delete 
xpatres2_efs_id_fk_odc expression_result2.xpatres_efs_id expression_figure_stage.efs_pk_id Cascade on delete 
xpatres2_subterm_zdb_id_fk_odc expression_result2.xpatres_subterm_zdb_id term.term_zdb_id Cascade on delete 
xpatres2_superterm_zdb_id_fk_odc expression_result2.xpatres_superterm_zdb_id term.term_zdb_id Cascade on delete 
zdb_submitters_zdb_id_foreign_key zdb_submitters.zdb_id person.zdb_id Cascade on delete 
zdep_person_fk zebrashare_data_edit_permission.zdep_person_zdb_id person.zdb_id Cascade on delete 
zdep_pub_fk zebrashare_data_edit_permission.zdep_pub_zdb_id publication.zdb_id Cascade on delete 
zem_lab_fk zebrashare_submission_metadata.zsm_lab_of_origin_zdb_id lab.zdb_id Cascade on delete 
zem_pub_fk zebrashare_submission_metadata.zsm_pub_zdb_id publication.zdb_id Cascade on delete 
zem_submitter_fk zebrashare_submission_metadata.zsm_submitter_zdb_id person.zdb_id Cascade on delete 
zmap_pub_pan_mark_chromosome_foreign_key zmap_pub_pan_mark.zmap_chromosome chromosome.chrom_name Restrict delete 
zmap_pub_pan_mark_metric_foreign_key zmap_pub_pan_mark.metric map_metric.mapmetric_code Restrict delete 
zmap_pub_pan_mark_zdb_id_foreign_key_odc zmap_pub_pan_mark.zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
zorphand_zdb_id_foreign_key zdb_orphan_data.zorphand_zdb_id zdb_active_data.zactvd_zdb_id Cascade on delete 
zorphans_zdb_id_foreign_key zdb_orphan_source.zorphans_zdb_id zdb_active_source.zactvs_zdb_id Cascade on delete 
zygocity_zdb_active_data_foreign_key zygocity.zyg_zdb_id zdb_active_data.zactvd_zdb_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected