Table homo_sapiens_core_98_38.seq_region_synonym 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
seq_region_synonym_id int unsigned 10  √ 
seq_region_id int unsigned 10
dna.seq_region_id Implied Constraint R
synonym varchar 250
external_db_id int unsigned 10  √  null
external_db.external_db_id Implied Constraint R

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

Indexes:
Column(s) Type Sort Constraint Name
seq_region_synonym_id Primary key Asc PRIMARY
seq_region_id Performance Asc seq_region_idx
synonym + seq_region_id Must be unique Asc/Asc syn_idx

Close relationships: