Table homo_sapiens_core_98_38.intron_supporting_evidence 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
intron_supporting_evidence_id int unsigned 10  √ 
transcript_intron_supporting_evidence.intron_supporting_evidence_id Implied Constraint R
analysis_id smallint unsigned 5
analysis.analysis_id Implied Constraint R
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
hit_name varchar 100
score decimal 10,3  √  null
score_type enum 5  √  NONE
is_splice_canonical bit 0 0

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

Indexes:
Column(s) Type Sort Constraint Name
intron_supporting_evidence_id Primary key Asc PRIMARY
analysis_id + seq_region_id + seq_region_start + seq_region_end + seq_region_strand + hit_name Must be unique Asc/Asc/Asc/Asc/Asc/Asc analysis_id
seq_region_id + seq_region_start Performance Asc/Asc seq_region_idx

Close relationships: