Table zfindb.public.panel_count 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
panelcnt_panel_zdb_id text 2147483647
panels.zdb_id panelcnt_panel_zdb_id_foreign_key C
panelcnt_mrkr_type text 2147483647
panelcnt_or_lg text 2147483647  √  null
linkage_group.lg_name panelcnt_or_lg_foreign_key C
panelcnt_count int4 10
panelcnt_chromosome text 2147483647
chromosome.chrom_name panelcnt_chromosome_foreign_key C

Table contained 608 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
panelcnt_panel_zdb_id + panelcnt_mrkr_type + panelcnt_chromosome Primary key Asc/Asc/Asc panel_count_primary_key
panelcnt_chromosome Performance Asc panelcnt_chromosome_index
panelcnt_mrkr_type Performance Asc panelcnt_mrkr_type_index
panelcnt_or_lg Performance Asc panelcnt_or_lg_index
panelcnt_panel_zdb_id Performance Asc panelcnt_panel_zdb_id

Close relationships  within of separation: