Table homo_sapiens_core_52_36n.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
transcript_attrib.transcript_id Implied Constraint
transcript_stable_id.transcript_id Implied Constraint
transcript_supporting_feature.transcript_id Implied Constraint
translation.transcript_id Implied Constraint
unconventional_transcript_association.transcript_id Implied Constraint
gene_id int unsigned 10  √  null
gene.gene_id Implied Constraint
analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
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 tinyint 3 0
display_xref_id int unsigned 10  √  null
biotype varchar 40
status enum 19  √  null
description text 65535  √  null
is_current bit 0 1

Table contained 63 280 rows at ma maalis 23 00:31 EET 2009

Indexes:
Column(s) Type Sort Constraint Name
transcript_id Primary key Asc PRIMARY
analysis_id Performance Asc analysis_idx
gene_id Performance Asc gene_index
seq_region_id + seq_region_start Performance Asc/Asc seq_region_idx
display_xref_id Performance Asc xref_id_index

Close relationships: