Table homo_sapiens_core_98_38.external_db 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
external_db_id int unsigned 10  √ 
dna_align_feature.external_db_id Implied Constraint R
protein_align_feature.external_db_id Implied Constraint R
seq_region_synonym.external_db_id Implied Constraint R
unmapped_object.external_db_id Implied Constraint R
xref.external_db_id Implied Constraint R
db_name varchar 100
db_release varchar 255  √  null
status enum 10
priority int 10
db_display_name varchar 255  √  null
type enum 18  √  null
secondary_db_name varchar 255  √  null
secondary_db_table varchar 255  √  null
description text 65535  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
external_db_id Primary key Asc PRIMARY
db_name + db_release Must be unique Asc/Asc db_name_db_release_idx

Close relationships: