Table homo_sapiens_core_98_38.transcript 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
transcript_id int unsigned 10  √ 
exon_transcript.transcript_id Implied Constraint R
rnaproduct.transcript_id Implied Constraint R
transcript_attrib.transcript_id Implied Constraint R
transcript_intron_supporting_evidence.transcript_id Implied Constraint R
transcript_supporting_feature.transcript_id Implied Constraint R
translation.transcript_id Implied Constraint R
gene_id int unsigned 10  √  null
gene.gene_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
display_xref_id int unsigned 10  √  null
source varchar 40 ensembl
biotype varchar 40
description text 65535  √  null
is_current bit 0 1
canonical_translation_id int unsigned 10  √  null
stable_id varchar 128  √  null
version smallint unsigned 5  √  null
created_date datetime 19  √  null
modified_date datetime 19  √  null

Table contained 250,194 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name Anomalies
transcript_id Primary key Asc PRIMARY  
analysis_id Performance Asc analysis_idx  
canonical_translation_id Must be unique Asc canonical_translation_idx This unique column is also nullable
gene_id Performance Asc gene_index  
seq_region_id + seq_region_start Performance Asc/Asc seq_region_idx  
stable_id + version Performance Asc/Asc stable_id_idx  
display_xref_id Performance Asc xref_id_index  

Close relationships: