Table homo_sapiens_core_98_38.prediction_exon 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
prediction_exon_id int unsigned 10  √ 
prediction_transcript_id int unsigned 10
prediction_transcript.prediction_transcript_id Implied Constraint R
exon_rank smallint unsigned 5
seq_region_id int unsigned 10
dna.seq_region_id Implied Constraint R
seq_region_start int unsigned 10
seq_region_end int unsigned 10
seq_region_strand tinyint 3
start_phase tinyint 3
score double 22  √  null
p_value double 22  √  null

Table contained 363,248 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
prediction_exon_id Primary key Asc PRIMARY
seq_region_id + seq_region_start Performance Asc/Asc seq_region_idx
prediction_transcript_id Performance Asc transcript_idx

Close relationships: