Table zfindb.informix.feature_stats_old Generated by
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
fstat_pk_id serial8 19  √ 
fstat_feat_zdb_id varchar 50
fstat_superterm_zdb_id varchar 50
fstat_subterm_zdb_id varchar 50
fstat_gene_zdb_id varchar 50  √  null
fstat_fig_zdb_id varchar 50
fstat_pub_zdb_id varchar 50
fstat_xpatres_zdb_id int8 19
fstat_type varchar 20  √  null
fstat_img_zdb_id varchar 50  √  null

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

Column(s) Type Sort Constraint Name
fstat_feat_zdb_id Performance Asc fstat_feat_fk_index
fstat_fig_zdb_id Performance Asc fstat_fig_fk_index
fstat_gene_zdb_id Performance Asc fstat_gene_fk_index
fstat_img_zdb_id Performance Asc fstat_img_fk_index
fstat_pk_id Must be unique Asc fstat_pk_id_index
fstat_pub_zdb_id Performance Asc fstat_pub_fk_index
fstat_subterm_zdb_id Performance Asc fstat_subterm_fk_index
fstat_superterm_zdb_id Performance Asc fstat_superterm_fk_index