Table homo_sapiens_core_98_38.assembly 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
asm_seq_region_id int unsigned 10
cmp_seq_region_id int unsigned 10
asm_start int 10
asm_end int 10
cmp_start int 10
cmp_end int 10
ori tinyint 3

Table contained 1,188,345 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
asm_seq_region_id + cmp_seq_region_id + asm_start + asm_end + cmp_start + cmp_end + ori Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc all_idx
asm_seq_region_id + asm_start Performance Asc/Asc asm_seq_region_idx
cmp_seq_region_id Performance Asc cmp_seq_region_idx