Table zfindb.informix.pheno_term 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 123,066 rows at Thu Jun 22 08:42 PDT 2017

Column(s) Type Sort Constraint Name
pt_geno_is_wildtype + pt_end_stg_zdb_id Performance Asc/Asc ptfs_end_stg_index
pt_geno_is_wildtype + pt_pheno_entity Performance Asc/Asc ptfs_entity_index
pt_geno_is_wildtype + pt_fig_zdb_id Performance Asc/Asc ptfs_fig_index
pt_geno_is_wildtype + pt_geno_zdb_id Performance Asc/Asc ptfs_geno_index
pt_geno_is_wildtype + pt_genox_zdb_id Performance Asc/Asc ptfs_genox_index
pt_geno_is_wildtype + pt_pub_zdb_id Performance Asc/Asc ptfs_pub_index
pt_geno_is_wildtype + pt_start_stg_zdb_id Performance Asc/Asc ptfs_start_stg_index
pt_geno_is_wildtype + pt_tag Performance Asc/Asc ptfs_tag_index