Table zfindb.public.feature_stats_old 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
fstat_pk_id bigserial 19  √  nextval('feature_stats_temp_fstat_pk_id_seq1'::regclass)
fstat_feat_zdb_id text 2147483647
fstat_superterm_zdb_id text 2147483647
fstat_subterm_zdb_id text 2147483647
fstat_gene_zdb_id text 2147483647  √  null
fstat_fig_zdb_id text 2147483647
fstat_pub_zdb_id text 2147483647
fstat_xpatres_zdb_id int8 19
fstat_type varchar 20  √  null
fstat_img_zdb_id text 2147483647  √  null

Table contained 639,345 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
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