Table homo_sapiens_core_98_38.seq_region 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_id int unsigned 10  √ 
dna.seq_region_id Implied Constraint R
name varchar 255
coord_system_id int unsigned 10
coord_system.coord_system_id Implied Constraint R
length int unsigned 10

Table contained 268,444 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
seq_region_id Primary key Asc PRIMARY
coord_system_id Performance Asc cs_idx
name + coord_system_id Must be unique Asc/Asc name_cs_idx

Close relationships: