Table zfindb.public.panels 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
zdb_id text 2147483647
panel_count.panelcnt_panel_zdb_id panelcnt_panel_zdb_id_foreign_key C
company.zdb_id Implied Constraint R
entry_time timestamp 26,3
name text 2147483647
abbrev text 2147483647
panel_date date 13
producer text 2147483647
person.zdb_id mappanel_producer_foreign_key R
owner text 2147483647
person.zdb_id mappanel_owner_foreign_key R
source text 2147483647
mappanel_comments text 2147483647
ptype text 2147483647
status text 2147483647
disp_order int4 10
metric text 2147483647
map_metric.mapmetric_code mappanel_metric_foreign_key R
mappanel_interactive_url text 2147483647  √  null
mappanel_interactive_url_extra_text text 2147483647  √  null
mappanel_rh_rad_dose text 2147483647  √  null
mappanel_rh_num_cell_lines int4 10  √  null
mappanel_meiotic_cross_type text 2147483647  √  null
mappanel_meiotic_num_meioses int4 10  √  null

Table contained 7 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
zdb_id Primary key Asc panels_primary_key
abbrev Must be unique Asc mappanel_abbrev_index
metric Performance Asc mappanel_metric_index
name Must be unique Asc mappanel_name_index_
owner Performance Asc mappanel_owner_index
producer Performance Asc mappanel_producer_index

Close relationships  within of separation: