Table zfindb.public.phenotype_figure_group 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
pfigg_group_name text 2147483647  √  null
pfigg_genox_zdb_id text 2147483647  √  null
pfigg_group_pk_id bigserial 19  √  nextval('phenotype_figure_group_pfigg_group_pk_id_seq'::regclass)
pfigg_geno_name text 2147483647  √  null
pfigg_geno_handle text 2147483647  √  null

Table contained 18,419 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
pfigg_group_pk_id Primary key Asc pfigg_group_primary_key
pfigg_geno_handle Performance Asc pfigg_geno_handle_index
pfigg_geno_name Performance Asc pfigg_geno_name_index
pfigg_genox_zdb_id Performance Asc pfigg_genox_zdb_index
pfigg_group_name Performance Asc pfigg_group_name_index