Table zfindb.informix.construct_gene_feature_result_view_backup 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 21,475 rows at Tue Nov 10 13:18 PST 2015

Indexes:
Column(s) Type Sort Constraint Name
cgfrv_allele_gene_all_names + cgfrv_allele_gene_zdb_id Performance Asc/Asc cgfrvb_allele_gene_zdb_id_index
cgfrv_allele_gene_all_names + cgfrv_cs_id Performance Asc/Asc cgfrvb_cs_id_foreign_key_index
cgfrv_allele_gene_all_names + cgfrv_pk_id Must be unique Asc/Asc cgfrvb_primary_key_index