Table zfindb.informix.pheno_term_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
pt_pk_id serial8 19  √ 
pt_genox_zdb_id varchar 50
pt_start_stg_zdb_id varchar 50
pt_end_stg_zdb_id varchar 50
pt_fig_zdb_id varchar 50
pt_geno_zdb_id varchar 50
pt_pub_zdb_id varchar 50
pt_tag varchar 25  √  null
pt_geno_is_wildtype boolean 1
pt_pheno_entity varchar 50

Table contained 45,314 rows at Tue Nov 10 13:18 PST 2015

Column(s) Type Sort Constraint Name
pt_geno_is_wildtype + pt_end_stg_zdb_id Performance Asc/Asc pt_end_stg_index
pt_geno_is_wildtype + pt_pheno_entity Performance Asc/Asc pt_entity_index
pt_geno_is_wildtype + pt_fig_zdb_id Performance Asc/Asc pt_fig_index
pt_geno_is_wildtype + pt_geno_zdb_id Performance Asc/Asc pt_geno_index
pt_geno_is_wildtype + pt_genox_zdb_id Performance Asc/Asc pt_genox_index
pt_geno_is_wildtype + pt_pub_zdb_id Performance Asc/Asc pt_pub_index
pt_geno_is_wildtype + pt_start_stg_zdb_id Performance Asc/Asc pt_start_stg_index
pt_geno_is_wildtype + pt_tag Performance Asc/Asc pt_tag_index