Table homo_sapiens_core_52_36n.ditag_feature 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
ditag_feature_id int unsigned 10  √ 
ditag_id int unsigned 10 0
ditag.ditag_id Implied Constraint
ditag_pair_id int unsigned 10 0
seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
seq_region_start int unsigned 10 0
seq_region_end int unsigned 10 0
seq_region_strand bit 0 0
analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
hit_start int unsigned 10 0
hit_end int unsigned 10 0
hit_strand bit 0 0
cigar_line tinytext 255
ditag_side enum 2 F

Table contained 3 960 124 rows at ma maalis 23 00:31 EET 2009

Indexes:
Column(s) Type Sort Constraint Name
ditag_feature_id Primary key Asc PRIMARY
ditag_id Performance Asc ditag_id
ditag_pair_id Performance Asc ditag_pair_id
seq_region_id + seq_region_start + seq_region_end Performance Asc/Asc/Asc seq_region_idx

Close relationships: