Table zfindb.public.genotype 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
geno_zdb_id text 2147483647
fish.fish_genotype_zdb_id fish_genotype_zdb_id_foreign_key_odc C
genotype_background.genoback_background_zdb_id genotype_background_background_foreign_key_odc C
genotype_background.genoback_geno_zdb_id genotype_background_geno_foreign_key_odc C
genotype_feature.genofeat_geno_zdb_id genofeat_geno_foreign_key_odc C
genotype_figure_fast_search.gffs_geno_zdb_id gffs_geno_zdb_id_foreign_key C
primer_set.strain_id primerset_strain_id_foreign_key R
probe_library.probelib_strain_zdb_id probelib_strain_foreign_key_odc C
zdb_active_data.zactvd_zdb_id genotype_zdb_active_data_foreign_key_odc C
geno_display_name text 2147483647
geno_handle text 2147483647
geno_supplier_stock_number text 2147483647  √  null
geno_date_entered timestamp 29,6  √  now()
geno_name_order text 2147483647  √  null
geno_is_wildtype bool 1  √  false
geno_is_extinct bool 1  √  false
geno_nickname text 2147483647  √  null
geno_complexity_order int4 10 999999999

Table contained 29,903 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
geno_zdb_id Primary key Asc genotype_primary_key
geno_handle Must be unique Asc genotype_handle_alternate_key_index

Close relationships  within of separation: