Table zfindb.informix.construct_gene_feature_result_view 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
cgfrv_pk_id serial8 19  √ 
cgfrv_cs_id int8 19
cgfrv_allele_gene_zdb_id varchar 50  √  null
cgfrv_allele_gene_abbrev varchar 255  √  null
cgfrv_allele_gene_all_names lvarchar 15000  √  null
cgfrv_allele_gene_order varchar 255  √  null
cgfrv_feature_zdb_id varchar 50  √  null
cgfrv_feature_abbrev varchar 50  √  null
cgfrv_feature_name varchar 255  √  null
cgfrv_feature_order varchar 255  √  null
cgfrv_lab_of_origin varchar 50  √  null
cgfrv_lab_name varchar 255  √  null
cgfrv_available varchar 50  √  null

Table contained 22,452 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
cgfrv_allele_gene_all_names + cgfrv_allele_gene_zdb_id Performance Asc/Asc cgfrv_allele_gene_zdb_id_index
cgfrv_allele_gene_all_names + cgfrv_cs_id Performance Asc/Asc cgfrv_cs_id_foreign_key_index
cgfrv_allele_gene_all_names + cgfrv_pk_id Must be unique Asc/Asc cgfrv_primary_key_index
cgfrv_allele_gene_all_names Performance Asc construct_gene_feature_result_view_all_allele_gene_names_bts_index