Table homo_sapiens_core_98_38.marker_synonym 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_synonym_id int unsigned 10  √ 
marker_map_location.marker_synonym_id Implied Constraint R
marker_id int unsigned 10
marker.marker_id Implied Constraint R
source varchar 20  √  null
name varchar 50  √  null

Table contained 720,716 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
marker_synonym_id Primary key Asc PRIMARY
marker_id Performance Asc marker_idx
marker_synonym_id + name Performance Asc/Asc marker_synonym_idx

Close relationships: