Table zfindb.public.pheno_term_fast_search_tmp 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
ptfs_pk_id bigserial 19  √  nextval('pheno_term_fast_search_tmp_ptfs_pk_id_seq'::regclass)
ptfs_term_zdb_id text 2147483647
ptfs_tag text 2147483647  √  null
ptfs_is_direct_annotation bool 1  √  false
ptfs_phenos_created_date timestamp 29,6
ptfs_created_date timestamp 29,6  √  now()
ptfs_psg_id int8 19  √  null

Table contained 3,010,581 rows at Wed Sep 15 00:41 PDT 2021