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

Table contained 93 250 rows at ma maalis 23 00:31 EET 2009

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_id
cmp_seq_region_id Performance Asc cmp_seq_region_id