Table zfindb.informix.genotype 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
geno_zdb_id varchar 50
fish.fish_genotype_zdb_id fish_genotype_zdb_id_foreign_key_odc C
genotype_background.genoback_background_zdb_id genotype_background_background_foreign_key_odc C
genotype_background.genoback_geno_zdb_id genotype_background_geno_foreign_key_odc C
genotype_feature.genofeat_geno_zdb_id genofeat_geno_foreign_key_odc C
genotype_figure_fast_search.gffs_geno_zdb_id gffs_geno_zdb_id_foreign_key C
primer_set.strain_id primerset_strain_id_foreign_key R
probe_library.probelib_strain_zdb_id probelib_strain_foreign_key_odc C
zdb_active_data.zactvd_zdb_id genotype_zdb_active_data_foreign_key_odc C
geno_display_name varchar 255
geno_handle varchar 255
geno_supplier_stock_number varchar 100  √  null
geno_date_entered datetime year to second 19  √  current
geno_name_order varchar 255  √  null
geno_is_wildtype boolean 1  √  f
geno_is_extinct boolean 1  √  f
geno_nickname varchar 255  √  null
geno_complexity_order int 10 999999999

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

Indexes:
Column(s) Type Sort Constraint Name
geno_is_extinct + geno_is_wildtype + geno_handle Must be unique Asc/Asc/Asc genotype_handle_alternate_key_index
geno_is_extinct + geno_is_wildtype + geno_zdb_id Must be unique Asc/Asc/Asc genotype_primary_key_index

Close relationships  within of separation: