Table zfindb.public.genotype_figure_fast_search 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
gffs_serial_id bigserial 19  √  nextval('genotype_figure_fast_search_new_gffs_serial_id_seq'::regclass)
gffs_geno_zdb_id text 2147483647
genotype.geno_zdb_id gffs_geno_zdb_id_foreign_key C
gffs_fig_zdb_id text 2147483647
figure.fig_zdb_id gffs_fig_zdb_id_foreign_key C
gffs_morph_zdb_id text 2147483647  √  null
marker.mrkr_zdb_id gffs_morph_zdb_id_foreign_key C
gffs_pg_id int8 19
gffs_date_created timestamp 29,6 now()
gffs_psg_id int8 19  √  null
gffs_fish_zdb_id text 2147483647
fish.fish_zdb_id gffs_fish_zdb_id_foreign_key C
gffs_genox_zdb_id text 2147483647  √  null

Table contained 138,238 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
gffs_serial_id Primary key Asc genotype_figure_fast_search_new_pkey
gffs_fig_zdb_id Performance Asc genotype_figure_fast_search_fig_zdb_id_foreign_key_index
gffs_fish_zdb_id Performance Asc genotype_figure_fast_search_fish_zdb_id_foreign_key_index
gffs_geno_zdb_id Performance Asc genotype_figure_fast_search_geno_zdb_id_foreign_key_index
gffs_morph_zdb_id Performance Asc genotype_figure_fast_search_morph_zdb_id_foreign_key_index
gffs_pg_id Performance Asc genotype_figure_fast_search_pg_id_foreign_key_index
gffs_psg_id Performance Asc genotype_figure_fast_search_psg_id_foreign_key_index

Close relationships  within of separation: