Table zfindb.informix.functional_annotation 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
fa_pk_id serial8 19  √ 
fa_all lvarchar 4000  √  null
fa_feature_order lvarchar 1000  √  null
fa_affector_type_group lvarchar 1000  √  null
fa_gene_order lvarchar 1000  √  null
fa_geno_zdb_id varchar 50  √  null
fa_feature_alias lvarchar 380  √  null
fa_gene_alias lvarchar 1500  √  null
fa_gene_alt_alias lvarchar 1000  √  null
fa_geno_alias lvarchar 1000  √  null
fa_str_alias lvarchar 1000  √  null
fa_construct_alias lvarchar 3000  √  null
fa_geno_name varchar 255  √  null
fa_geno_handle varchar 255
fa_genox_zdb_id varchar 50  √  null
fa_feature_group lvarchar 2500  √  null
fa_gene_group lvarchar 1500  √  null
fa_construct_group lvarchar 500  √  null
fa_str_group lvarchar 380  √  null
fa_feature_group_id int8 19  √  null
fa_environment_group lvarchar 380  √  null
fa_pheno_term_group lvarchar 4000  √  null
fa_pheno_figure_group lvarchar 3000  √  null
fa_xpat_figure_group lvarchar 3000  √  null
fa_environment_group_is_standard_or_control boolean 1  √  f
fa_geno_is_wildtype boolean 1  √  null
fa_fish_significance int 10  √  null
fa_feature_significance int 10  √  null
fa_str_significance int 10  √  null
fa_str_member_count int 10  √  null
fa_gene_count int 10  √  null
fa_fish_parts_count int 10  √  null
fa_feature_count int 10  √  null
fa_pheno_term_count int 10  √  null
fa_pheno_figure_count int 10  √  null
fa_total_figure_count int 10  √  null
fa_xfigg_has_images boolean 1  √  f

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

Indexes:
Column(s) Type Sort Constraint Name
fa_affector_type_group + fa_all + fa_construct_alias + fa_construct_group + fa_environment_group + fa_environment_group_is_standard_or_control + fa_feature_alias + fa_feature_group + fa_feature_order + fa_gene_alias + fa_gene_alt_alias + fa_gene_group + fa_gene_order + fa_geno_alias + fa_geno_is_wildtype + fa_pheno_figure_group + fa_pheno_term_group + fa_str_alias + fa_str_group + fa_xfigg_has_images + fa_xpat_figure_group + fa_geno_handle Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc fa_geno_handle_index
fa_affector_type_group + fa_all + fa_construct_alias + fa_construct_group + fa_environment_group + fa_environment_group_is_standard_or_control + fa_feature_alias + fa_feature_group + fa_feature_order + fa_gene_alias + fa_gene_alt_alias + fa_gene_group + fa_gene_order + fa_geno_alias + fa_geno_is_wildtype + fa_pheno_figure_group + fa_pheno_term_group + fa_str_alias + fa_str_group + fa_xfigg_has_images + fa_xpat_figure_group + fa_geno_zdb_id Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc fa_geno_index
fa_affector_type_group + fa_all + fa_construct_alias + fa_construct_group + fa_environment_group + fa_environment_group_is_standard_or_control + fa_feature_alias + fa_feature_group + fa_feature_order + fa_gene_alias + fa_gene_alt_alias + fa_gene_group + fa_gene_order + fa_geno_alias + fa_geno_is_wildtype + fa_pheno_figure_group + fa_pheno_term_group + fa_str_alias + fa_str_group + fa_xfigg_has_images + fa_xpat_figure_group + fa_geno_name Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc fa_geno_name_index
fa_affector_type_group + fa_all + fa_construct_alias + fa_construct_group + fa_environment_group + fa_environment_group_is_standard_or_control + fa_feature_alias + fa_feature_group + fa_feature_order + fa_gene_alias + fa_gene_alt_alias + fa_gene_group + fa_gene_order + fa_geno_alias + fa_geno_is_wildtype + fa_pheno_figure_group + fa_pheno_term_group + fa_str_alias + fa_str_group + fa_xfigg_has_images + fa_xpat_figure_group + fa_genox_zdb_id Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc fa_genox_zdb_id_index
fa_affector_type_group + fa_all + fa_construct_alias + fa_construct_group + fa_environment_group + fa_environment_group_is_standard_or_control + fa_feature_alias + fa_feature_group + fa_feature_order + fa_gene_alias + fa_gene_alt_alias + fa_gene_group + fa_gene_order + fa_geno_alias + fa_geno_is_wildtype + fa_pheno_figure_group + fa_pheno_term_group + fa_str_alias + fa_str_group + fa_xfigg_has_images + fa_xpat_figure_group + fa_pk_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc fa_pk_id_index
fa_affector_type_group + fa_all + fa_construct_alias + fa_construct_group + fa_environment_group + fa_environment_group_is_standard_or_control + fa_feature_alias + fa_feature_group + fa_feature_order + fa_gene_alias + fa_gene_alt_alias + fa_gene_group + fa_gene_order + fa_geno_alias + fa_geno_is_wildtype + fa_pheno_figure_group + fa_pheno_term_group + fa_str_alias + fa_str_group + fa_xfigg_has_images + fa_xpat_figure_group + fa_str_group Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc fa_str_group_index