Table homo_sapiens_core_52_36n.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  √ 
external_synonym.xref_id Implied Constraint
object_xref.xref_id Implied Constraint
external_db_id smallint unsigned 5 0
external_db.external_db_id Implied Constraint
dbprimary_acc varchar 40
display_label varchar 128
version varchar 10 0
description text 65535  √  null
info_type enum 18  √  null
info_text varchar 255  √  null

Table contained 1 982 159 rows at ma maalis 23 00:31 EET 2009

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 Must be unique Asc/Asc/Asc/Asc id_index
info_type Performance Asc info_type_idx

Close relationships: