Table zfindb.informix.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 varchar 50
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
fish_str.fishstr_str_zdb_id fishstr_str_zdb_id_foreign_key_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
mutant_fast_search.mfs_mrkr_zdb_id mutant_fast_search_mrkr_zdb_id_foreign_key_odc 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
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 varchar 255
mrkr_comments lvarchar 1500  √  null
mrkr_abbrev varchar 150
mrkr_type varchar 60
marker_types.marker_type mrkr_type_foreign_key R
mrkr_owner varchar 50
person.zdb_id mrkr_owner_foreign_key R
mrkr_name_order varchar 140
mrkr_abbrev_order varchar 255

Table contained 162,536 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
mrkr_comments + mrkr_zdb_id Must be unique Asc/Asc marker_primary_key_index
mrkr_comments + mrkr_abbrev Must be unique Asc/Asc mrkr_abbrev_index
mrkr_comments + mrkr_name Must be unique Asc/Asc mrkr_name_index
mrkr_comments + mrkr_owner Performance Asc/Asc mrkr_owner_index
mrkr_comments + mrkr_type Performance Asc/Asc mrkr_type_index

Close relationships  within of separation: