Table zfindb.informix.fish_search 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
fish_id varchar 50
environment_staging.fish_id Implied Constraint R
fish_genox.fish_id Implied Constraint R
fish_staging.fish_id Implied Constraint R
name varchar 255
fishsearch_name_order varchar 100
line_type varchar 30  √  null
abbrev varchar 30  √  null
phenotype lvarchar 6000  √  null
chrom_num varchar 3  √  null
chrom_change varchar 30  √  null
comments lvarchar 2048  √  null
allele varchar 40  √  null
fishsearch_allele_order varchar 50
mutagen varchar 20  √  null
pheno_keywords lvarchar 2048  √  null
locus varchar 50  √  null
gene_id varchar 50  √  null
marker.mrkr_zdb_id fish_search_gene_id_foreign_key C
gene_abbrev varchar 15  √  null
alt_zdb_id varchar 50  √  null

Table contained 1,253 rows at Tue Nov 10 13:18 PST 2015

Indexes:
Column(s) Type Sort Constraint Name
comments + pheno_keywords + phenotype + abbrev Performance Asc/Asc/Asc/Asc fish_search_abbrev_index
comments + pheno_keywords + phenotype + allele Performance Asc/Asc/Asc/Asc fish_search_allele_index
comments + pheno_keywords + phenotype + alt_zdb_id Performance Asc/Asc/Asc/Asc fish_search_alt_zdb_id_index
comments + pheno_keywords + phenotype + gene_abbrev Performance Asc/Asc/Asc/Asc fish_search_gene_abbrev_index
comments + pheno_keywords + phenotype + gene_id Performance Asc/Asc/Asc/Asc fish_search_gene_id_index
comments + pheno_keywords + phenotype + locus Performance Asc/Asc/Asc/Asc fish_search_locus_index
comments + pheno_keywords + phenotype + fish_id Must be unique Asc/Asc/Asc/Asc fish_search_primary_key_index

Close relationships  within of separation: