Table zfindb.informix.mapped_marker 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
lab.zdb_id Implied Constraint R
marker_id varchar 50  √  null
zdb_active_data.zactvd_zdb_id mm_marker_id_foreign_key C
refcross_id varchar 50
zdb_active_data.zactvd_zdb_id mm_refcross_id_foreign_key C
submitter varchar 50  √  null
lab varchar 50  √  null
owner varchar 50  √  null
person.zdb_id owner_person_zdb_id_foreign_key_odc R
comments varchar 100  √  null
entry_date datetime year to fraction(3) 23  √  null
scoring_data varchar 200  √  null
marker_type varchar 10
framework_t boolean 1  √  null
metric varchar 5  √  null
map_metric.mapmetric_code mapped_marker_metric_foreign_key R
map_name varchar 40  √  null
mm_chromosome varchar 2
chromosome.chrom_name mapped_marker_chromosome_foreign_key R
mm_chrom_location decimal 8,2  √  null

Table contained 26,973 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
framework_t + owner Performance Asc/Asc 312_1671
framework_t + mm_chromosome Performance Asc/Asc mapped_marker_chromosome_index
framework_t + marker_id Performance Asc/Asc mapped_marker_marker_id_index
framework_t + marker_type Performance Asc/Asc mapped_marker_marker_type_index
framework_t + metric Performance Asc/Asc mapped_marker_metric_index
framework_t + zdb_id Must be unique Asc/Asc mapped_marker_primary_key_index
framework_t + refcross_id Performance Asc/Asc mapped_markers_refcross_id_index

Close relationships  within of separation: