Table zfindb.public.fish 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
fish_zdb_id text 2147483647
fish_experiment.genox_fish_zdb_id genox_fish_zdb_id_foreign_key_odc C
fish_str.fishstr_fish_zdb_id fishstr_fish_zdb_id_foreign_key_odc C
genotype_figure_fast_search.gffs_fish_zdb_id gffs_fish_zdb_id_foreign_key C
htp_dataset_sample.hds_fish_zdb_id hds_fish_zdb_id_fk_odc C
tmp_fish490.fish_zdb_id Implied Constraint R
tmp_fish_thatfitthebill.fish_zdb_id Implied Constraint R
tmp_fishnoeap.fish_zdb_id Implied Constraint R
tmp_onlyfish.fish_zdb_id Implied Constraint R
zdb_active_data.zactvd_zdb_id fish_zdb_active_data_foreign_key_odc C
fish_genotype_zdb_id text 2147483647
genotype.geno_zdb_id fish_genotype_zdb_id_foreign_key_odc C
fish_name text 2147483647
fish_handle text 2147483647
fish_name_order text 2147483647
fish_modified bool 1  √  false
fish_order int8 19
fish_functional_affected_gene_count int8 19
fish_is_wildtype bool 1 false
fish_full_name text 2147483647  √  null
fish_phenotypic_construct_count int4 10 0

Table contained 45,731 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
fish_zdb_id Primary key Asc fish_primary_key_constraint
fish_genotype_zdb_id Performance Asc fish_genotype_foreign_key_index
fish_handle Must be unique Asc fish_handle_ak_index

Close relationships  within of separation: