Table homo_sapiens_core_52_36n.stable_id_event 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
old_stable_id varchar 128  √  null
old_version smallint 5  √  null
new_stable_id varchar 128  √  null
new_version smallint 5  √  null
mapping_session_id int unsigned 10 0
mapping_session.mapping_session_id Implied Constraint
type enum 11 gene
score float 12 0

Table contained 3 361 218 rows at ma maalis 23 00:31 EET 2009

Indexes:
Column(s) Type Sort Constraint Name
new_stable_id Performance Asc new_idx
old_stable_id Performance Asc old_idx
mapping_session_id + old_stable_id + new_stable_id + type Must be unique Asc/Asc/Asc/Asc uni_idx

Close relationships: