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