Table homo_sapiens_core_98_38.xref 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
xref_id int unsigned 10  √ 
associated_xref.xref_id Implied Constraint R
external_synonym.xref_id Implied Constraint R
object_xref.xref_id Implied Constraint R
external_db_id int unsigned 10
external_db.external_db_id Implied Constraint R
dbprimary_acc varchar 512
display_label varchar 512
version varchar 10  √  null
description text 65535  √  null
info_type enum 18 NONE
info_text varchar 255

Table contained 2,858,554 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
xref_id Primary key Asc PRIMARY
display_label Performance Asc display_index
dbprimary_acc + external_db_id + info_type + info_text + version Must be unique Asc/Asc/Asc/Asc/Asc id_index
info_type Performance Asc info_type_idx

Close relationships: