Table zfindb.informix.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 varchar 50
panel_count.panelcnt_panel_zdb_id panelcnt_panel_zdb_id_foreign_key C
lab.zdb_id Implied Constraint R
entry_time datetime year to fraction(3) 23
name varchar 50
abbrev varchar 20
panel_date date 10
producer varchar 50
person.zdb_id mappanel_producer_foreign_key R
owner varchar 50
person.zdb_id mappanel_owner_foreign_key R
source varchar 50
mappanel_comments lvarchar 15000
ptype varchar 50
status varchar 10
disp_order int 10
metric varchar 5
map_metric.mapmetric_code mappanel_metric_foreign_key R
mappanel_interactive_url varchar 60  √  null
mappanel_interactive_url_extra_text varchar 60  √  null
mappanel_rh_rad_dose varchar 60  √  null
mappanel_rh_num_cell_lines int 10  √  null
mappanel_meiotic_cross_type varchar 20  √  null
mappanel_meiotic_num_meioses int 10  √  null

Table contained 7 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
mappanel_comments + abbrev Must be unique Asc/Asc mappanel_abbrev_index
mappanel_comments + metric Performance Asc/Asc mappanel_metric_index
mappanel_comments + name Must be unique Asc/Asc mappanel_name_index_
mappanel_comments + owner Performance Asc/Asc mappanel_owner_index
mappanel_comments + producer Performance Asc/Asc mappanel_producer_index
mappanel_comments + zdb_id Must be unique Asc/Asc panels_primary_key_index

Close relationships  within of separation: