Table homo_sapiens_core_98_38.object_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
object_xref_id int unsigned 10  √ 
dependent_xref.object_xref_id Implied Constraint R
ensembl_id int unsigned 10
ensembl_object_type enum 16
xref_id int unsigned 10
xref.xref_id Implied Constraint R
linkage_annotation varchar 255  √  null
analysis_id smallint unsigned 5  √  null
analysis.analysis_id Implied Constraint R

Table contained 5,153,057 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
object_xref_id Primary key Asc PRIMARY
analysis_id Performance Asc analysis_idx
ensembl_object_type + ensembl_id Performance Asc/Asc ensembl_idx
xref_id + ensembl_object_type + ensembl_id + analysis_id Must be unique Asc/Asc/Asc/Asc xref_idx

Close relationships: