Table homo_sapiens_core_98_38.coord_system 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
coord_system_id int unsigned 10  √ 
data_file.coord_system_id Implied Constraint R
meta_coord.coord_system_id Implied Constraint R
seq_region.coord_system_id Implied Constraint R
species_id int unsigned 10 1
name varchar 40
version varchar 255  √  null
rank int 10
attrib set 30  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
coord_system_id Primary key Asc PRIMARY
name + version + species_id Must be unique Asc/Asc/Asc name_idx
rank + species_id Must be unique Asc/Asc rank_idx
species_id Performance Asc species_idx

Close relationships: