Table homo_sapiens_core_98_38.associated_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
associated_xref_id int unsigned 10  √ 
object_xref_id int unsigned 10 0
dependent_xref.object_xref_id Implied Constraint R
xref_id int unsigned 10 0
xref.xref_id Implied Constraint R
source_xref_id int unsigned 10  √  null
condition_type varchar 128  √  null
associated_group_id int unsigned 10  √  null
associated_group.associated_group_id Implied Constraint R
rank int unsigned 10  √  0

Table contained 0 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
associated_xref_id Primary key Asc PRIMARY
associated_group_id Performance Asc associated_group_idx
xref_id Performance Asc associated_idx
object_xref_id Performance Asc associated_object_idx
source_xref_id Performance Asc associated_source_idx
object_xref_id + xref_id + source_xref_id + condition_type + associated_group_id Must be unique Asc/Asc/Asc/Asc/Asc object_associated_source_type_idx

Close relationships: