Table zfindb.public.fish_components 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
fc_pk_id bigserial 19  √  nextval('fish_components_fc_pk_id_seq'::regclass)
fc_fish_zdb_id text 2147483647
fc_genotype_zdb_id text 2147483647
fc_fish_name text 2147483647
fc_affector_zdb_id text 2147483647
fc_gene_zdb_id text 2147483647  √  null
fc_construct_zdb_id text 2147483647  √  null

Table contained 71,452 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
fc_affector_zdb_id Performance Asc fc_affector_zdb_id_index
fc_construct_zdb_id Performance Asc fc_construct_zdb_id_index
fc_fish_zdb_id Performance Asc fc_fish_zdb_id_index
fc_gene_zdb_id Performance Asc fc_gene_zdb_id_index
fc_genotype_zdb_id Performance Asc fc_genotype_zdb_id_index