Table zfindb.public.zdb_active_data Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
zactvd_zdb_id text 2147483647
all_alias_tokens.aliastok_dalias_zdb_id aliastok_dalias_zdb_id_foreign_key C
apato_infrastructure.api_entity_1_subterm_zdb_id phenos_entity_1_subterm_zdb_id_fk_odc C
apato_infrastructure.api_entity_1_superterm_zdb_id phenos_entity_1_superterm_zdb_id_fk_odc C
apato_infrastructure.api_entity_2_subterm_zdb_id phenos_entity_2_subterm_zdb_id_fk_odc C
apato_infrastructure.api_entity_2_superterm_zdb_id phenos_entity_2_superterm_zdb_id_fk_odc C
apato_infrastructure.api_zdb_id apato_zdb_id_active_data_fk_odc C
candidate.cnd_zdb_id candidate_active_data_foreign_key_odc C
condition_data_type.cdt_zdb_id condition_data_type_zdb_active_data_foreign_key C
construct.construct_zdb_id construct_zdb_active_data_foreign_key_odc C
construct_component.cc_component_zdb_id cc_component_zdb_id_foreign_key C
construct_marker_relationship.conmrkrrel_zdb_id conmrkrrel_zdb_id_fk_odc C
controlled_vocabulary.cv_zdb_id cv_zdb_active_data_foreign_key_odc C
curation.cur_zdb_id cur_zdb_id_foreign_key C
data_alias.dalias_data_zdb_id dalias_data_zdb_id_foreign_key C
data_alias.dalias_zdb_id dalias_zdb_id_foreign_key C
data_note.dnote_data_zdb_id dnote_data_zdb_id_foreign_key C
data_note.dnote_zdb_id dnote_zdb_id_foreign_key C
db_link.dblink_linked_recid dblink_linked_recid_zactvd_zdb_id_foreign_key C
db_link.dblink_zdb_id dblink_zdb_id_foreign_key C
disease_annotation.dat_zdb_id dat_zdb_id_foreign_key_odc C
experiment.exp_zdb_id exp_zdb_id_foreign_key_odc C
experiment_condition.expcond_zdb_id expcond_zdb_id_fk_odc C
expression_experiment2.xpatex_zdb_id expression_experiment2_zdb_active_data_foreign_key C
expression_pattern_infrastructure.xpatinf_zdb_id xpatinf_active_data_foreign_key C
external_note.extnote_data_zdb_id extnote_data_zdb_id_foreign_key C
external_note.extnote_zdb_id extnote_zdb_id_foreign_key C
external_reference.exref_data_zdb_id exref_data_zdb_id_foreign_key C
feature.feature_zdb_id feature_zactvd_zdb_id_foreign_key_odc C
feature_dna_mutation_detail.fdmd_zdb_id fdmd_zdb_id_fk_odc C
feature_genomic_mutation_detail.fgmd_zdb_id fgmd_zdb_id_fk_odc C
feature_history.fhist_zdb_id fhist_zdb_id_foreign_key_odc C
feature_marker_relationship.fmrel_mrkr_zdb_id fmrel_mrkr_zdb_id_foreign_key C
feature_marker_relationship.fmrel_zdb_id fmrel_zdb_id_foreign_key C
feature_protein_mutation_detail.fpmd_zdb_id feature_protein_mutation_detail_zdb_active_data_fk_odc C
feature_transcript_mutation_detail.ftmd_zdb_id ftmd_zdb_id_fk_odc C
figure.fig_zdb_id fx_figure_zdb_id_active_data_foreign_key C
fish.fish_zdb_id fish_zdb_active_data_foreign_key_odc C
fish_experiment.genox_zdb_id genotype_experiment_genox_foregin_key_odc C
genotype.geno_zdb_id genotype_zdb_active_data_foreign_key_odc C
genotype_feature.genofeat_zdb_id genofeat_zdb_active_data_foreign_key R
go_term.goterm_zdb_id goterm_zdb_id_foreign_key C
htp_dataset.hd_zdb_id hd_zdb_id_fk_odc C
image.img_zdb_id img_zdb_id_foreign_key_odc C
int_data_source.ids_data_zdb_id ids_data_zdb_id_foreign_key C
int_data_supplier.idsup_data_zdb_id idsup_data_zdb_id_foreign_key C
interpro_protein.ip_interpro_id interpro_protein_zdb_active_data_fk_odc C
linkage.lnkg_zdb_id lnkgs_lnkg_zdb_id_foreign_key C
linkage_membership.lnkgm_member_1_zdb_id lnkgm_member_1_zdb_id_foreign_key R
linkage_membership.lnkgm_member_2_zdb_id lnkgm_member_2_zdb_id_foreign_key R
linkage_membership_search.lms_lnkg_zdb_id lms_lnkg_zdb_id_fk_zdb_active_data C
linkage_membership_search.lms_member_1_zdb_id lms_member_1_zdb_id_fk_zdb_active_data C
linkage_membership_search.lms_member_2_zdb_id lms_member_2_zdb_id_fk_zdb_active_data C
linkage_old.lnkg_zdb_id lnkg_lnkg_zdb_id_foreign_key C
linkage_single.lsingle_member_zdb_id lsingle_member_zdb_id_foreign_key C
mapped_marker.marker_id mm_marker_id_foreign_key C
mapped_marker.refcross_id mm_refcross_id_foreign_key C
marker.mrkr_zdb_id mrkr_zdb_id_foreign_key C
marker_go_term_evidence.mrkrgoev_zdb_id marker_go_term_evidence_zdb_active_data_id_foreign_key C
marker_history.mhist_zdb_id mhist_zdb_id_foreign_key C
marker_relationship.mrel_zdb_id mrel_zdb_id_foreign_key C
mutant_fast_search.mfs_data_zdb_id mutant_fast_search_data_zdb_id_foreign_key_odc C
ortholog.ortho_zdb_id ortho_zdb_id_active_data_foreign_key_odc C
paneled_markers.zdb_id paneled_markers_zdb_id_fk_odc C
probe_library.probelib_zdb_id probelib_zdb_id_foreign_key C
protein.up_uniprot_id protein_zdb_active_data_fk_odc C
publication_note.pnote_zdb_id pnote_zdb_id_foreign_key C
record_attribution.recattrib_data_zdb_id recattrib_data_zdb_id_foreign_key C
run.run_zdb_id run_zdb_active_data_foreign_key_odc C
sequence_feature_chromosome_location.sfcl_feature_zdb_id sfcl_feature_zdb_id_fk_odc C
sequence_feature_chromosome_location.sfcl_zdb_id sfcl_zdb_id_fk_odc C
sequence_feature_chromosome_location_generated.sfclg_data_zdb_id sfclg_zdb_active_data_fk C
stage.stg_zdb_id stage_active_data_foreign_key C
term.term_zdb_id term_zdb_id_foreign_key C
term_relationship.termrel_zdb_id termrel_zactvd_foreign_key_odc C
url_ref.urlref_data_zdb_id urlref_data_zdb_id_foreign_key C
variant_flanking_sequence.vfseq_data_zdb_id variant_sequence_zdb_active_data_foreign_key C
zdb_orphan_data.zorphand_zdb_id zorphand_zdb_id_foreign_key C
zdb_replaced_data.zrepld_new_zdb_id nzrepld_new_zdb_id_foreign_key C
zmap_pub_pan_mark.zdb_id zmap_pub_pan_mark_zdb_id_foreign_key_odc C
zygocity.zyg_zdb_id zygocity_zdb_active_data_foreign_key R

Table contained 5,430,580 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
zactvd_zdb_id Primary key Asc zdb_active_data_primary_key
zactvd_zdb_id Must be unique Asc zactvd_zdb_id_pk_index

Close relationships  within of separation: