Table homo_sapiens_core_98_38.rnaproduct 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
rnaproduct_id int unsigned 10  √ 
rnaproduct_attrib.rnaproduct_id Implied Constraint R
rnaproduct_type_id smallint unsigned 5
rnaproduct_type.rnaproduct_type_id Implied Constraint R
transcript_id int unsigned 10
transcript.transcript_id Implied Constraint R
seq_start int 10
start_exon_id int unsigned 10  √  null
seq_end int 10
end_exon_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 0 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
rnaproduct_id Primary key Asc PRIMARY
stable_id + version Performance Asc/Asc stable_id_idx
transcript_id Performance Asc transcript_idx

Close relationships: