Table zfindb.informix.zmap_pub_pan_mark 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  √  null
zdb_active_data.zactvd_zdb_id zmap_pub_pan_mark_zdb_id_foreign_key_odc C
abbrevp varchar 15
mtype varchar 10
lg_location decimal 8,2
metric varchar 5
map_metric.mapmetric_code zmap_pub_pan_mark_metric_foreign_key R
target_abbrev varchar 10
mghframework boolean 1
target_id varchar 50
panel_id varchar 50
mname varchar 80
abbrev varchar 10
entry_date datetime year to fraction(3) 23
panel_abbrev varchar 10  √  null
zmap_chromosome varchar 2
chromosome.chrom_name zmap_pub_pan_mark_chromosome_foreign_key R

Table contained 35,840 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
mghframework + metric Performance Asc/Asc zmap_pub_pan_mark_metric_index
mghframework + mname Performance Asc/Asc zmap_pub_pan_mark_mname_index
mghframework + mtype Performance Asc/Asc zmap_pub_pan_mark_mtype_index
mghframework + zmap_chromosome Performance Asc/Asc zmap_pub_pan_mark_or_lg_index
mghframework + panel_abbrev Performance Asc/Asc zmap_pub_pan_mark_panel_abbrev_index
mghframework + zdb_id Performance Asc/Asc zmap_pub_pan_mark_zdb_id_foreign_key_index

Close relationships  within of separation: