Table homo_sapiens_core_98_38.marker_map_location 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
marker_id int unsigned 10
marker.marker_id Implied Constraint R
map_id int unsigned 10
map.map_id Implied Constraint R
chromosome_name varchar 15
marker_synonym_id int unsigned 10
marker_synonym.marker_synonym_id Implied Constraint R
position varchar 15
lod_score double 22  √  null

Table contained 164,580 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
marker_id + map_id Primary key Asc/Asc PRIMARY
map_id + chromosome_name + position Performance Asc/Asc/Asc map_idx

Close relationships: