Table zfindb.public.marker 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
mrkr_zdb_id text 2147483647
antibody.atb_zdb_id atb_mrkr_foreign_key_odc C
clean_expression_fast_search.cefs_mrkr_zdb_id clean_expression_fast_search_mrkr_zdb_id_foreign_key_odc C
clone.clone_mrkr_zdb_id clone_mrkr_zdb_id_foreign_key C
construct_marker_relationship.conmrkrrel_mrkr_zdb_id cmr_mrkr_fk_odc C
expression_experiment2.xpatex_gene_zdb_id xpatex2_gene_zdb_id_foreign_key R
expression_experiment2.xpatex_probe_feature_zdb_id expression_experiment2_probe_feature_foreign_key C
finalct3.mrkr_zdb_id Implied Constraint R
finalgo.mrkr_zdb_id Implied Constraint R
fish_str.fishstr_str_zdb_id fishstr_str_zdb_id_foreign_key_odc C
gene_description.gd_gene_zdb_id gd_gene_zdb_id_fk_odc C
genedom_family_member.gfammem_mrkr_zdb_id genedom_family_member_mrkr_zdb_id_foreign_key_odc C
genotype_figure_fast_search.gffs_morph_zdb_id gffs_morph_zdb_id_foreign_key C
marker_go_term_evidence.mrkrgoev_mrkr_zdb_id mrkrgoev_mrkr_zdb_id_foreign_key C
marker_history.mhist_mrkr_zdb_id mhist_mrkr_zdb_id_foreign_key C
marker_history_audit.mha_mrkr_zdb_id mha_mrkr_zdb_id_foreign_key C
marker_relationship.mrel_mrkr_1_zdb_id mrel_mrkr_1_zdb_id_foreign_key C
marker_relationship.mrel_mrkr_2_zdb_id mrel_mrkr_2_zdb_id_foreign_key C
marker_sequence.seq_mrkr_zdb_id mrkrseq2_mrkr_zdb_id_foreign_key_odc C
marker_to_protein.mtp_mrkr_zdb_id protein_to_interpro_interpro_id C
ortholog.ortho_zebrafish_gene_zdb_id ortholog_gene_zdb_id_fk_odc C
primer_set.marker_id primer_set_marker_id_foreign_key_odc C
snp_download.snpd_mrkr_zdb_id snpd_mrkr_zdb_id_foreign_key_odc C
tmp_go.mrkr_zdb_id Implied Constraint R
tmp_go1.mrkr_zdb_id Implied Constraint R
transcript.tscript_mrkr_zdb_id tscript_mrkr_zdb_id_foreign_key_odc C
zdb_active_data.zactvd_zdb_id mrkr_zdb_id_foreign_key C
mrkr_name text 2147483647
mrkr_comments text 2147483647  √  null
mrkr_abbrev text 2147483647
mrkr_type text 2147483647
marker_types.marker_type mrkr_type_foreign_key R
mrkr_owner text 2147483647
person.zdb_id mrkr_owner_foreign_key R
mrkr_name_order text 2147483647
mrkr_abbrev_order text 2147483647

Table contained 173,681 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
mrkr_zdb_id Primary key Asc marker_primary_key
mrkr_abbrev Must be unique Asc mrkr_abbrev_index
mrkr_name Must be unique Asc mrkr_name_index
mrkr_owner Performance Asc mrkr_owner_index
mrkr_type Performance Asc mrkr_type_index

Close relationships  within of separation: